Denali, the next release [SQL Server]
SQL Server Codename “Denali” Community Technology Preview 1 released
Read moreCategory: SQL Server
Split a Partition and Expect Locks [SQL Server]
Not in every scenario. But as a rule of thumb, test before you perform a split operation in a production environment.
Read moreMediaWhiz’s BI Solution Goes Live [Analytics]
We presented the solution to the business owners, with multiple sample reports generated by SSMS, Regular Pivot Tables and PowerPivot for Excel. We sliced and diced at the client level, server level and the results were coming back pretty fast. They were extremely happy as they just found a way to slice “everything by everything”. I even heard the statement ”This will be the company’s biggest asset”.
Read moreData Compression before or after loading operations? [SQL Server]
Based on what we have experienced, it appears that its more efficient to just immediately insert into a compressed table, with a partitioned clustered index.
Read moreWho 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 moreMy 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 more