How to throttle your Storage with Resource Governor in SQL Server 2014
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-14
1,651 reads
Blog Posts
Independent consultant: How to find work
When I talk to people about switching from being a salaried employee to an independent consultant (see my presentation How to...
2014-01-14
1,839 reads
Laying The Ground For A Successful Reporting Project
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource...
2014-01-14 (first published: 2014-01-09)
3,152 reads
One error which you don’t want to see while doing upgrades – Missing MSI !
The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are...
2014-01-14
1,212 reads
PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login. Regular readers know that I practice the philosophy...
2014-01-14
311 reads
PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server...
2014-01-14
2,277 reads
Sometimes It’s A Dirty Job – #TSQL2sDAY #50
Sometimes being a DBA really stinks. You try to follow best practices in everything you do. You’re not shrinking databases...
2014-01-14
777 reads
SQL in Albuquerque
It’s a little less than two weeks until SQL Saturday #271 – Albuquerque. The second event in that great city, and...
2014-01-14
803 reads
SQL Server Diagnostic Information Queries for January 2014
I spent some time this month to true up the SQL Server 2005 version, with the other versions for the...
2014-01-14
1,064 reads
SQL Server Quick Tip: Growing your database past 2TB on SQL Server 2008
A couple of days ago I had to manually grow the database data file for a client, they do not...
2014-01-14
2,837 reads
Blogs
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...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
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...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
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