The Scary DBA Comes to Columbia, SC
*sound of glass crashing* *cue theme music*
(in a wrestling announcer’s shocked voice) “It can’t be! He’s not supposed to be...
2014-05-09
700 reads
Off to Jacksonville for SQLSaturday #298
I’m looking forward to returning to Jacksonville after missing a year (or two?) to speak at SQLSaturday #298. I’m driving...
2014-05-09
340 reads
We’re All Mad Here!
The title says it all!
I just heard that I was selected to present at SQL Saturday in Columbus! I’m excited...
2014-05-09
721 reads
Carolina Cruise
I’m going to speak at three user groups in three days in North and South Carolina. Evidently this is known...
2014-05-09
495 reads
Friday Followup For May 9, 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-05-09
429 reads
Monthly Reflections – April 2014
April was quite a busy month and so apart from the last reflections post and TSQL Tuesday entry Why So Serious...
2014-05-09
686 reads
Error Log Management
Thought I’d write a quick post about managing error logs within SQL Server. Good error log management is essential for...
2014-05-09
2,430 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics conference. The abstract is below. I...
2014-05-09
938 reads
SQL Saturday #308 – Houston TX Presentation
Tabular Data Visualized by Power View
I am presenting this Saturday 5/10/2014 at 4PM at the Houston TX SQL Saturday Event. ...
2014-05-09
710 reads
Cannot Failover Nodes Using TempDB on Local Storage
I ran into an interesting issue while installing SQL 2012 SP1 in a failover cluster configuration and utilizing the local...
2014-05-08
853 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers