Collecting Historical Wait Statistics
As a DBA, I'm sure you've heard many times to always check the sys.dm_os_wait_stats DMV to help diagnose performance issues...
2013-12-16 (first published: 2013-12-11)
2,517 reads
Blog Posts
DBA JumpStart – A SQL Community Ebook for DBAs
If you could give a DBA just one piece of advice, what would it be?
I asked 20 successful and experienced...
2013-12-16 (first published: 2013-12-10)
3,323 reads
Forty Things You Didn’t Know About SQL Server
Last week I delivered a seminar at the Expert Days 2013 event by the name of 40 Things You Didn’t...
2013-12-16
590 reads
Last Weeks Top “Reading” Links #62
Monday afternoon and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout most days I tweet...
2013-12-16
1,386 reads
NFC Tags-Fun, And Maybe Useful at SQLSaturday
Last week I had one of those days when I read something and then heard someone talking about the same...
2013-12-16
907 reads
Nine T-SQL best practices
SQL Server databases are the backbone of many enterprise applications, and good Transact-SQL (T-SQL) code is the best way to...
2013-12-16
972 reads
Scalzi’s Law of Cleverness, as applied to resumes
John Scalzi (blog, Twitter) – science fiction writer, Hugo award winner, philosopher, and blogger extraordinaire – has an adage that I wish...
2013-12-16
943 reads
SQL Saturday in Ancona and Verona – English slide decks available for download
You can download the english version of my sessions at SQL Saturdays (on SlideShare):
SQL Saturday 257 in Verona: “Put databases...
2013-12-16
306 reads
SQL Server 2012 AlwaysOn Presentation Given at Vermont PASS SQL Server User Group Last Week
This past Wednesday evening, 11th Dec, I braved the snowy roads down from Montreal to Winooski (Burlington area) to join...
2013-12-16
1,342 reads
Talk Your Boss Into A Free Lunch and Giveaways!: Day 6
Monday Giveaway!
It's Monday again! I know we all hate Mondays, but let's have a Fun Monday!It's another week to give...
2013-12-16
656 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
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
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
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