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
695 reads
I SCHEMABOUND my scalar UDF and you won’t believe what happened next.
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,189 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
851 reads
Creation & Deletion of Database Snapshot by SQL Agent Job
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want...
2014-09-15
500 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
571 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
240 reads
SQLSaturday Orlando Marketing Plan-Part 42
Reg count at 479. Looking very good for hitting 500!First sponsor sent out a geo-targeted message for us, another one...
2014-09-12
641 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
806 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,061 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
571 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers