Code Smell Checks With sp_Develop (Podcast)
What if there were a tool that could help developers perform database code (smell) assessments to adhere to best practices? There is, and it was created by Emergent Software's Kevin Martin.
Data Engineering
sp_CRUDGen: A Practical Real-World SQL Server Example
sp_CRUDGen is a free open-source SQL Server stored procedure that generates stored procedures based on your tables and metadata like foreign keys and data types. The generated stored procedure code utilizes the SQL Server community best practices.
5 Signs Your Business Has Outgrown A Data Management System of Spreadsheets
If you're using data spreadsheets as your current data management system, you might be outgrowing it. Emergent Software can help you transform your processes!
Bring Your Dark Data to Light: Why All Businesses Need Analytics
As a small business, it’s important to understand both data analytics and dark data analytics. Here we explore data analytics tools for small businesses along with other key data.
Understanding Business Data Warehouses & Reporting Types
You may have heard of data warehouses but aren't sure if your company needs them. Let's explore each piece that makes up your business data.
Using ID for Primary Key Column Name Database Development Best Practice | sp_Develop
The open-source project contains a stored procedure named sp_Develop that can be used by developers for performing database code (smell) assessments.
When Was Your Last SQL Server Checkup? Why Database Health Checks & Security Audits Matter
Since environments are changing with new databases, reports, and changing permissions, regular SQL Server health checks & security audits are a must.
Protect Your SQL Server Databases from Disaster with Regular Backups and Maintenance
How much data loss can you tolerate? Protecting your database with backups keeps your business functioning at the highest level during a disaster.
Why Choosing a Part-Time Database Consultant Over a DBA May Be a Smart Business Move For You
DBAs with the added bonus of consulting experience have deep exposure across many systems, allowing them to bring more immediate value to your situation.
Choosing Between a Full Time DBA or Consultant: Which Is Right for You?
A company that houses data to run their business needs a skilled DBA to setup, backup, and secure databases. But, do you need a full-time DBA?
Top Categories
About Emergent Software
Emergent Software offers a full set of software-based services from custom software development to ongoing system maintenance & support serving clients from all industries in the Twin Cities metro, greater Minnesota and throughout the country.
