The default settings in SQL Server are usually quite performant. Just like many other data engines, there are things you can do to optimize the performance specific to your unique requirements. Often, the things you can do are based on physics. As the persistence engine matures, the number of things you can do is decreasing. Back to the comment about […]

SQL Server provides the User Defined Table Types as a method to create a pre-defined temp table. Additionally, because they are a defined object in a database, you can pass them around as parameters or variables from one query to another. They can even be read only input parameters to stored procedures. In sql you might do something like the […]

Why would you want to use windows service bus, hosted in Azure or on premise? The best answer is that it makes communication easy between your applications. How many times have you had to roll your own message queues in an SQL Table? How often do you configure replication between databases? Do you have multiple applications that need to be […]

SQL Server has supported the concept of Sparse Columns since 2008 R2. The purpose of the Sparse columns is to optimize storage and performance in those instances where you have a table containing a lot of null data. In my experience, this is often due to a schema that is not normalized. While normalization is generally the best policy, there […]

SQL Server supports creating extended properties for objects in your schema. Extended properties are the equivalent of a property bag, allowing you to create as many key/value pairs as you like on schema objects. Tables, columns, views, procedures are some of the SQL objects supporting extended properties. Tables are the most likely candidate, in my mind, for the use of […]

Today I want to consider an aspect of Microsoft SQL Server that I acknowledge I take for granted. When you consider the different applications that may be supported by the SQL Server engine(s), it is really quite amazing. You can use an embedded version, that may only run in memory. You can use a personal edition, freely distributable with your […]

Optimizing your data warehouse load processes can be a difficult problem to crack. The more there is normalization in your warehouse, such as using a snowflake schema, the harder it can be to import large volumes of data. Yet, that is the main purpose of a data warehouse; to store and mine large volumes of data. The reason it becomes […]

While reviewing some of the enhancements made in the Dot Net Framework 4.6.1, the most recent released version of the framework, I observed 2 additions to the ADO.Net classes. They have added native storage of external Hardware Generated Encryption keys. They have also improved the performance for establishing and maintaining connections to SQL Servers utilizing always on failover implementations. https://msdn.microsoft.com/library/ms171868(v=vs.120).aspx#ADO.NET461 […]

What happens to all the other stuff? This is a common question that was recently brought up in response to my editorial on a Retrospective technique. In my editorial I reviewed a method where we identified a number of things we didn’t like and things we did like. Then, as a team, we prioritized the list into a top three […]

I’d like to share a personal experience of one of the most effective ways I have experienced a when taking a retrospective look at a body of work. That body may be for any period. It just needs to have a specific start, finish and intended goals. I was simply a participant, and don’t know if this isn’t already covered […]