SQL Server Thumbnail Metrics – OS Memory
I’m gathering a few metrics around the Internet for SQL Server from people that I think really know how to...
2012-12-07 (first published: 2012-11-29)
3,000 reads
Reasons not to upgrade to SQL Server 2012
As exciting as SQL Server 2012 is, with its multitude of new features, it’s not always possible to upgrade right...
2012-11-29
2,848 reads
Lost in Translation – Deprecated System Tables – sysremotelogins
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-29
1,856 reads
Interview questions for SQL Server Performance Tuning Specialists
If you are the regular reader of my blog posts, you could easily judge in which topics i spend much time these days.
I have...
2012-11-29
10,158 reads
HDInsight: Trying again
And I thought this would be so easy.
Latest attempt. I just did an uninstall of HDInsight. Then I found all...
2012-11-29
1,932 reads
Tables without a Clustered Index
Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the...
2012-11-29
1,544 reads
Chicago: The Travels of a SQL Server Consultant
As regular readers of my blog will now as part of role as a SQL Server consultant and SQL Server...
2012-11-29
2,128 reads
Plan cache bloat by SQLAgent (Prior to SQL2008) !
Recently I was checking the plan cache utilization with the help of the below query which I normally use for...
2012-12-05 (first published: 2012-11-29)
2,473 reads
NY SQL Server User Group Meeting - Bill Pearson
Thursday, November 29, 2012, brings us the November
meeting of the NY SQL
Server User Group, with BI expert, SQL MVP and...
2012-11-28
1,827 reads
Significant Achievements
As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s...
2012-11-28
738 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers