T-SQL Tuesday #47: Your Best SQL Server SWAG
The Stuff We All Get!
Fall has arrived which means it's conference season: Connections is happening this week, the PASS Summit...
2013-10-07 (first published: 2013-10-03)
1,678 reads
Blog Posts
Wrapping Up The 2013 PASS Election-Part 3
Today I’ll continue with my notes and thoughts on the 2013 election process and a good place to start is...
2013-10-06
719 reads
One-stop Shopping for Backups
First, let me say that yes, I’m aware of Ola Hallengren’s excellent set of maintenance scripts, including those for doing...
2013-10-05
386 reads
Wrapping Up The PASS 2013 Election–Part 2
I watched the election this year with interest and the advantage of having seen PASS elections from a number of different...
2013-10-05
680 reads
Disaster Recovery and Business Continuity
Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work. ...
2013-10-04 (first published: 2013-09-30)
2,174 reads
Reblog: September 27 to October 3
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-04
937 reads
SQL Server Analysis Services Activity Viewer 2012 1.0.0.1 Beta Released
(Worth noting that there is a more recent version available here!)
Hi all, yesterday morning I created a project based on an old blog post Upgrade Analysis Services Activity Viewer...
2013-10-04
16 reads
The SQL in the City Tour is Almost Here
Five days. That’s how long I’m in Denver after my last trip before I head back to the airport for...
2013-10-04
723 reads
DevConnections Slides and Code
I had a great time at DevConnections this week, It was a fairly quick trip for me, with lots of...
2013-10-03
596 reads
Does Business Intelligence equal Data Warehousing?
I have seen many times at clients where the terms business intelligence and data warehousing are used interchangeably. In reality, these...
2013-10-03
949 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