Powershell in a Month Day 10 – Formatting
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-15
1,068 reads
Blog Posts
Restore Master From Backup
There are a few posts running around talking about restoring master from backup. Thomas LaRock has a fantastic "How To:...
2014-01-15
625 reads
Sausage Making
For those who don’t know, I work for Red Gate Software. I’m not a developer, but I work directly for...
2014-01-15 (first published: 2014-01-08)
2,043 reads
Should You Run For the PASS Board? How Do You Decide?
Here are some of the questions I ask when someone is thinking about running for the Board:
Are you eligible? Read...
2014-01-15
547 reads
sp_SrvPermissions & sp_DBPermissions V4.0
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
907 reads
SQL Server Filtered Index Performance
Filtered Index – Database Performance
SQL Server 2012 includes filtered indexes and is a great feature for Business Intelligence and Reporting databases. ...
2014-01-15
1,001 reads
Two-Factor Authentication
Something you have and something you know – that’s the heart of two-factor, sometimes called multi-factor, authentication. RSA was for years...
2014-01-15 (first published: 2014-01-09)
6,364 reads
2014 Polar Plunge #SQLPlunge
In just a couple months… on March 1… I’m going to jump into a lake in Minnesota. Now it’s cold...
2014-01-14
645 reads
Flash sale – discount code for SQL Saturday Nashville Precon
Announcing a flash sale today from 10a-12p Central time for my upcoming SQL Saturday Nashvillepreconference training session ‘Virtualization for SQL...
2014-01-14
566 reads
Google Buys Nest
I was a bit sad to see that Google bought Nest. I like upstarts that see a problem and solve...
2014-01-14
631 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