Reading the January 2017 PASS Minutes
I’ve been catching up on stuff this week, including reading the January 2017 minutes. It was in-person meeting so a...
2017-03-27
378 reads
Reviewing the PASS 2017 Budget
I did a quick review of the 2017 PASS Budget. It’s not a page turner, but it has a lot...
2017-03-27
373 reads
Test your Sqlserver backups on Linux with PowerShell and dbatools
I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts.
With SQL Server vNext...
2017-03-27
352 reads
SQLBits 2017
I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which...
2017-03-27
309 reads
Monday Coffee 2017-03-27
Hey all, I’m back after attending SQL Saturday in Iceland. This week’s going to be busy!
I’ve said before that SQL...
2017-03-27
248 reads
How easy it is to implement Row Level Security in SQL SERVER 2016 ?
To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.Problem 1 Suppose, you have a Multi-tenant e-commerce website...
2017-03-27
972 reads
Columnstore Indexes – part 100 (“Identity”)
Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In Data Warehousing one will not be...
2017-03-25
798 reads
The Public Speaking Roadmap
So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like....
2017-03-25
341 reads
Using Pester with dbatools Test-DbaLastBackup
In previous posts I have shown how to use Test-DbaLastBackup from dbatools and how you can make use of the...
2017-04-11 (first published: 2017-03-25)
1,664 reads
TSQLTuesday.com – Quick WordPress Setup in Azure
When I agreed to host the T-SQL Tuesday site, I wasn’t sure what to do. I thought about just putting...
2017-03-24
1,134 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