I went to a SQLSaturday event last week and decided to attend Janis Griffith's presentation on SQL Server Extended Events (XE). I thought this presentation would be a good opportunity to catch up on a …
Encryption Aarghh!
I have many readers in the healthcare industry and even more in the e-commerce arena. This newsletter should be of special interest to them. But any company that accepts credit cards should be equally …
The End of the Road for SQL Server 2005
Many things have changed in the SQL Server world since SQL Server 2005 was released ten years ago. This new version brought an overhaul of the database engine for better performance and many important …
Continue Reading about The End of the Road for SQL Server 2005 →
The Performance Cost of Implicit Conversions in SQL Server
The most frustrating times in a DBA's professional life are those times when he or she cannot connect to an unresponsive server or a database. A server may not be responding because a runaway process …
Continue Reading about The Performance Cost of Implicit Conversions in SQL Server →
Big Data, Small Budget
It used to be that Big Data was only a problem for Big Business. Big companies had big data but they also had the mainframes, money and the staff to handle terabytes of data. It did not seem that big …
The Performance Cost of Implicit Conversions in SQL Server
(You can follow the code examples in this article by using one of the AdventureWorks sample databases. We are using AdventureWorks2008R2 but any version should work. Download the sample databases …
Continue Reading about The Performance Cost of Implicit Conversions in SQL Server →