Parameterization Part 4: Handling Non-Uniform Data Distribution
This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I...
2014-09-11 (first published: 2014-09-08)
7,139 reads
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...
2014-09-07
535 reads
Silicon Valley is a different world
I spent the last couple days at Flowcon 2014, a conference that is bringing people together to talk about growing...
2014-09-05
787 reads
Reblog: August 29 to September 4
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-09-05
738 reads
Database Free Space Monitoring – The right way
Lately I spent some time evaluating some monitoring tools for SQL Server and one thing that struck me very negatively...
2014-09-05
461 reads
Speaker of the Month: September 2014
This month I’m very grateful because I was given the opportunity to present at DevLink in Chattanooga. I got to...
2014-09-05
531 reads
Analysis Services Partitions
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-09 (first published: 2014-09-05)
7,448 reads
Analysis Services Partitions
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-05
641 reads
SSC Editorial-Titles Matter – Part 2
I wrote Titles Matter – Part 2 based on lessons learned the hard way not long ago. Titles matter because they...
2014-09-05
521 reads
Speaking at SQLSaturday Barcelona, Spain 2014
A couple of days ago, when I was in Germany – I have received some extremely exciting news that I was...
2014-09-05
137 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