More on Password Managers
Last week I posted about reviewing passwords and mentioned using a password manager as part of that effort. DaniSQL noted...
2014-01-23
795 reads
Blog Posts
Rochester – Welcome to the PASS MN Family
It started as a vision for expanding the reach of the Minnesota SQL Server User Group a year ago. At...
2014-01-23
680 reads
Star Schema The Complete Reference – Review
I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph...
2014-01-23
1,183 reads
Transactions: Who, What and Where
Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I...
2014-01-23 (first published: 2014-01-20)
3,299 reads
Webcast Follow-Up: The Flavors of Non-Clustered Indexes
Earlier today, I presented a session for Pragmatic WorksTraining on the T’s titled The Flavors of Non-Clustered Indexes. In the session,...
2014-01-23
773 reads
Cumulative Update # 8 for SQL Server 2012 Service Pack 1 is now available!
The 8th cumulative update (CU8) for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-01-22
508 reads
Easy Backup History Review Script
I often use these scripts to check on the backups of all databases in an unfamiliar SQL Server instance, regardless...
2014-01-22
557 reads
Get SQL Server Physical Cores, Physical and Virtual CPUs, and Processor type information using Transact-SQL (T-SQL) script
Today, I received email from one of my blog follower asking if there is any DMV or SQL script, which...
2014-01-22
2,260 reads
Powershell in a Month Day 12 – A Practical Interlude
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-22
872 reads
PowerShell Remote Commands
This is something I've found useful here recently when I had a server acting up. It's a simple way to...
2014-01-22
1,053 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