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

518 reads

Creation & Deletion of Database Snapshot by SQL Agent Job

by Rohit Garg

MSSQLFUN

Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite...

2014-09-15

21 reads

Podcast on Devops and the Database

by Grant Fritchey

The Scary DBA

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

696 reads

I SCHEMABOUND my scalar UDF and you won’t believe what happened next.

by Kenneth Fisher

SQLStudies

Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this...

2014-09-15

1,191 reads

To be brief. What to do when PATH variable is too long to be real PATH.

by sqlcodeguard

SQL Code Guard

Sometimes after installing pretty useful addins when starting SSMS you can see error message like "Exception has been thrown by...

2014-09-15

854 reads

Creation & Deletion of Database Snapshot by SQL Agent Job

by Rohit Garg

MSSQLFUN

Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want...

2014-09-15

503 reads

Houston TechFest 2014: SQL Admin Best Practices with DMV's

by Will Assaf

SQL Tact

Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014, thanks very much...

2014-09-13

572 reads

Clustered Columnstore Indexes – part 41 (“Statistics”)

by Niko Neugebauer

Niko's blog

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

241 reads