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,705 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,355 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,965 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
502 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
89 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
506 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
476 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
625 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
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers