How to find empty tables in SQL Server : Quick Tip
These quick tips are short and sweet. They are nothing more than an explanation and some code. If you have...
2013-11-06
551 reads
Blog Posts
Murder They Wrote
For those of you that know me, you know that I enjoy learning, and passing on what I have learned...
2013-11-06
798 reads
One Database Mirror disconnected case
Today I got a database mirror case, I was told the all databases were in disconnected\in recovery status on both...
2013-11-06
1,250 reads
Physical Join Operators by Ami Levin
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these...
2013-11-06
686 reads
SQL Saturday Dallas
I've been to five SQL Saturdays so far and this was my first year to attend the Dallas conference. Therewere...
2013-11-06
407 reads
Transactionally Consistent
What does this mean? I had someone ask me in a session recently, and I think I have a good...
2013-11-06
1,103 reads
Adding a column to a table with a default (NULL vs NOT NULL)
There are lots of ways to learn new things, or be reminded of old things. One of my favorites is...
2013-11-05 (first published: 2013-10-30)
5,178 reads
Fast-Track Data Warehouse for Windows Azure
Microsoft has introduced an image into the Windows Azure Virtual Machine Gallery that is pre-optimized for a Fast Track Data...
2013-11-05
1,461 reads
Is There Interest in SQL Server Security Pre-Cons?
I’m very passionate about security, especially database security. As the numbers with regards to data breaches continue to climb, this...
2013-11-05 (first published: 2013-10-30)
2,729 reads
Murder They Wrote
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2013-11-05
7 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