SQL Server events in the UK – December 2013
The Christmas countdown has begun for a number of us. This doesn’t mean it’s time to relax, there’s still plenty...
2013-12-02
606 reads
Blog Posts
Why do DBAs like to say “It Depends” so much?
Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice...
2013-12-02
651 reads
Why SQL Server Professionals should love Windows 8
Alright, I’ve got your attention. You’re probably thinking “who is this crazy guy that is using the word Love with...
2013-12-02
559 reads
Temporary Post Used For Theme Detection (ce478925-8370-4f2b-8509-8988dd7a717e – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e6e588b0-6d28-4504-914d-36fc0145f1b9 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2013-12-01
404 reads
Traveling, Talking, and a PASS Attack Have Happened
Well, this fall has been crazy. As you may have noted from a couple of my previous posts, link to...
2013-12-01
618 reads
Getting the read/write ratio for a database
EDIT: Please also see in depth comment from Brent Ozar on my main site which extends the query provided below...
2013-11-30
4,801 reads
Understanding SQL Server related Windows Registries
SQL Server related information from Windows registries
The Windows Registry is a hierarchical database that stores configuration settings and options on Microsoft Windows operating systems. It contains...
2013-11-30
2,194 reads
What’s In My Utility Belt? Issue #2
Wow, can you believe it’s been a month already since I posted the first issue of “What’s In My Utility...
2013-11-30
1,105 reads
Digging Around For Free Tools – SQL Server
Tool Archaeology, Digging Through The Web About every three to six months I will burn some time and just go digging for tools. Mostly, I’m looking for stuff related...
2013-11-29
24 reads
Digging Around For Free Tools – SQL Server
Tool Archaeology, Digging Through The Web
About every three to six months I will burn some time and just go digging...
2013-11-29
1,364 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