Automating SSMS 2016 Updates & Install
Figured I'd share a way to automate the SSMS 2016 updates until it gets it's own fancy self updater. I...
2016-04-26 (first published: 2016-04-19)
2,702 reads
KDiff3
As I write more code, especially database code, and I collaborate with others (or myself), I find that I have...
2016-04-29 (first published: 2016-04-18)
2,347 reads
Easy SQL mistakes: Accidental Correlated Subquery
Just a fun note, because it was a moment of pure puzzlement for me. I’m writing a new SP for Minion Backup...
2016-04-25 (first published: 2016-04-18)
2,963 reads
How to Trim Characters in C#
The removing of leading and trailing characters in c# is made possible by the System namespace.
My demo is uses a windows...
2016-04-18
492 reads
My First PASS Board Meeting
Let me start off with a disclaimer that these thoughts on the January PASS board meeting are my own as...
2016-04-18
86 reads
My First PASS Board Meeting
Let me start off with a disclaimer that these thoughts on the January PASS board meeting are my own as...
2016-04-18
502 reads
How do I rename a column?
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to...
2016-04-18
475 reads
Can’t RDP to Azure VM?
I ran into an interesting problem early this month. I was spinning up an Azure VM with SQL Server 2016...
2016-04-18
563 reads
Columnstore Indexes – part 82 (“Extended Events in SQL Server 2016”)
Continuation from the previous 81 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Previously, I have blogged about about the...
2016-04-16
623 reads
SQL Saturday #492 Follow Up – A Window into Your Data
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-04-16
470 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