Podcast on Devops and the Database
I’ve been attempting to expand my reach to get back to my roots in development. I’m doing this because I...
2014-09-15
691 reads
Blog Posts
Statistics in SQL Server
I’ve put together a new Curah! of links to some of the better articles on SQL Server Statistics, specifically those...
2014-09-15 (first published: 2014-09-10)
7,392 reads
Thoughts On the NomCom Process
We’ve just wrapped up the interviews and I wanted to jot down a few thoughts on what I’ve seen from...
2014-09-15
515 reads
To be brief. What to do when PATH variable is too long to be real PATH.
Sometimes after installing pretty useful addins when starting SSMS you can see error message like "Exception has been thrown by...
2014-09-15
842 reads
Clustered Columnstore Indexes – part 41 (“Statistics”)
Continuation from the previous 40 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Note: This article is in’s 2nd version, after correcting comments done by...
2014-09-13
236 reads
Houston TechFest 2014: SQL Admin Best Practices with DMV's
Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014, thanks very much...
2014-09-13
570 reads
Friday Followup For September 12, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-09-12
567 reads
Professional Microsoft SQL Server 2014 Administration
Hello Dear Reader! Last September I was approached with a tremendous opportunity to become the Managing Author for the Professional...
2014-09-12
2,059 reads
Reblog: September 5 to September 11
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-09-12
803 reads
Schema on Read vs Schema on Write
Schema on Read vs Schema on Write in Business Intelligence
When starting build out a new BI strategy. There are more...
2014-09-12
1,206 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers