Featured Article(s) Understanding Windows Management Instrumentation Microsoft has come up with Windows Management Instrumentation (WMI); a COM based technology that can be used to retrieve system-related information from a computer system. This is a component of the Windows OS that can be used to retrieve hardware information from a system of any kind. You can use WMI to retrieve both […]
Editorials
How To Hire a SQL Server DBA (questions answered!)
Featured Article(s) How to Hire a DBA? Your Questions Answered. Chris Shaw – Recently I posted an article on How to hire a DBA, I followed that up with a sample of questions that I would ask a DBA during an interview. I have presented the How to Hire a DBA as a 60 min session and I the questions […]
SQL Server 2014 In Memory Tables
SQL Server 2014 In Memory Tables For the first time in six years I am excited about the next release of SQL Server. The core engine of SQL Server has had little improvement since SQL Server 2008 for doing OLTP. There have been some TSQL enhancements, and performance tuning; but, most of the energy seems to have been around the […]
In Memory Tables
SQL Server 2014 In Memory Tables For the first time in six years I am excited about the next release of SQL Server. The core engine of SQL Server has had little improvement since SQL Server 2008 for doing OLTP. There have been some TSQL enhancements, and performance tuning; but, most of the energy seems to have been around the […]
In Memory Tables
SQL Server 2014 In Memory Tables For the first time in six years I am excited about the next release of SQL Server. The core engine of SQL Server has had little improvement since SQL Server 2008 for doing OLTP. There have been some TSQL enhancements, and performance tuning; but, most of the energy seems to have been around the […]
Dependency Injection
Dependency Injection Dependency Injection is a design pattern with the result of decoupling dependent application processes with hard coded implementations. We talk about it a lot with the ability to change from using one implementation of something with another. For example, substituting one database engine with another one, or even different versions or vendors of storage technologies. Instead of coding […]