SQLInspireNYC Event - We're giving away SQL MVP Deep Dives Vol.2

Now the PASS has well passed, folks are setting their sites on our upcoming NYC SQLPeople event called SQLInspireNYC .
SQLPeople...

Understanding Kerberos, Part II

The majority of the time, the problems I see with Kerberos are due to a bad SPN (Service Principal Name)...

SQL Server Collation

Instead of just right clicking on SSMS , these are some alternatives to locating SQL Server Collation information I use.
 
--To find...

When was SQL Server restarted?

One of the main goals with this blog is to write stuff when we learn / discover new things or smarter...

AWE has removed from SQL server 2012

AdvertisementsAWE has removed from SQL server 2012

AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit...

SQL Server 2008 R2 RTM CU10

Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 10. This is Build 10.50.1807.0, and it has 13 listed...

SQL Server 2008 R2 SP1 CU3

Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 3. This is Build 10.50.2789.0, and it has 22 listed...

Implicit Conversions warning

After adding an index,  ensuring that an index is actually used is probably the biggest win you will get in...

The Demise of Jar Jar

Today we have a guest post from Steve Jones as Brad is on vacation.
Today we have the third question from...

Guest Appearance in DBA in Space

Win a trip into space!
The DBA in Space competition continues today with the third question. This time I get to...