Get Your SQL Server Product Key with Powershell #dbatools
There are lots of tasks that are easily accomplished with bot h PowerShell and T-SQL.
Get-SqlServerKey is a command that...
2017-02-03
4,275 reads
Blog Posts
How the SQL Agent Job schedule_uid broke my heart, and my jobs!
This is something that has caused me some grief in my life as a DBA. I hesitate to call it...
2017-02-03
409 reads
Setting Up a Productive Work Environment – #TAPtips
Having a productive work environment for you and your team is important to facilitate tasks being accomplished as well as...
2017-02-03 (first published: 2017-01-25)
1,833 reads
SQL Server vNext
I have been pretty busy recently working with Joe Sack from Microsoft and getting my hands dirty with SQL Server...
2017-02-03
729 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some...
2017-02-03
6 reads
What’s a Database Encryption Key (DEK) in TDE
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran...
2017-02-03 (first published: 2017-01-26)
1,738 reads
Backup/Restore–What’s My Status?
The day begins and you find yourself going through a list in your mind of things that need to be...
2017-02-02 (first published: 2017-01-26)
1,887 reads
Compare Execution Plans
Have you ever wanted to compare execution plans from SQL Server Management Studio? Well with the newer version of the...
2017-02-02
437 reads
Getting Started with Power BI: Setup (Part 1 of 3)
This is part 1 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-02
196 reads
Microsoft Data Platform MVP Award
I’m very pleased, humbled, surprised and overall gleeful to announce I’m awarded the Microsoft Data Platform MVP 2017 Award.
This is...
2017-02-02
508 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers