Who needs DBA Skills? [#TSQL2sDay]
DBA skills are not just a nice-to-have. It is a requirement. Do it right the first time and avoid the hassle of fixing in the future.
Read moreCategory: Database
My SQLPass Schedule [Training]
My SQLPass Schedule
Read moreIncorrect Bios Settings Can Reduce Database Performance [SQL Server]
It turned out that the issue was not Hyper Threading related, but a Bios misconfiguration instead.
Read moreSummarizing Performance issues and workarounds after migrating from 2005 to 2008 R2 [SQL Server]
We were able to tune the offending processes and go from 85% sustained CPU utilization to almost nil.
Read moreKerberos Double Hop and Delegation between different Active Directory Accounts [SQL Server]
In the past, when I had bare knowledge of Active Directory, I dealt with double hop queries using SQL Server[…]
Read moreSQL Server: Truncating Dates
TRUNC is a function I used a lot when I worked with Oracle and helped me slicing my data in[…]
Read moreSQL Server: Migrating from 2000 EE X86 to 2008 R2 SE X64
Today we had a production migration and brought over one of our legacy applications from a data center located up[…]
Read moreSQL Server: Can I upgrade to 2008 R2 from 2008, 2005 or 2000? #TSQL2sDay
It is known that you can go up 2 major releases. Let’s consider 2008 R2 as a “half release” as[…]
Read moreParticipate in #TSQL2sDay
Sankar Reddy has blogged about what will be discussed as next topic: Misconceptions in SQL Server. What is SQL Tuesday?[…]
Read moreSQL Trace causing error “The client was unable to reuse a session with SPID XXX”
We will open traces whenever a slow performing process needs to be pinpointed. We never experienced a high overhead until[…]
Read more