Connection options in SSMS
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know...
2013-11-18
1,686 reads
Blog Posts
Fill Factor, Why Do You Taunt Me? Part 2
So Friday we were discussing the idea of an idea. I think... or an idea of an idea's idea. What...
2013-11-18
1,004 reads
For the Aspiring DBA
Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess...
2013-11-18 (first published: 2013-11-11)
1,489 reads
I’m speaking at SQL Server Saturday #233 – Washington DC!
It’s that time of the year again when SQL Saturday makes its way back to the Washington DC Area. Here...
2013-11-18
591 reads
Last Weeks Top “Reading” Links #58
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-11-18
923 reads
MDX+SSRS #33 – Retrieve manager’s key and fully-qualified member name
A co-worker recently worked on a SSRS report and wanted to use a specific manager’s team for testing. The Manager...
2013-11-18 (first published: 2013-11-08)
2,344 reads
Power Pivot Synonyms
A little gem was included with the latest Office 365 update. After downloading and installing this update you will now find...
2013-11-18
941 reads
SQL Saturday in Verona – Slide deck of “Put databases under source control” available for download
“Put databases under source control” slide deck is available here. The SQL Saturday – Verona event was a great success. Now we’re waiting for...
2013-11-18
484 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
160 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
432 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