Upgrading Windows 10 Home to Pro
I use Hyper-V and a few other things that require Windows 10 Pro. When I got my new laptop, it had Windows 10 home on it. Not a big...
2019-12-09
96 reads
The Voice of the DBA
HP is the 2019 Laptop Winner
This is for me, not necessarily for you, but I decided to go with the HP Spectre again. I saw an email from Best Buy over the Thanksgiving weekend,...
2019-12-06
49 reads
Resetting an Azure SQL Database Admin Password
This is likely something that most people know, but it was a bit confusing for me. This post is really here to remind me and help cement this in...
2019-12-18 (first published: 2019-12-05)
2,973 reads
A Quick Look at Travel
I was experimenting with visualizations the other day, and started playing with SandDance, a tool from Microsoft that you can use in Power BI or Azure Data Studio. I’ll...
2019-12-24 (first published: 2019-12-02)
291 reads
Take the 2020 State of Database DevOps survey
It’s still 2019, but we’re looking forward to 2020 and wonder how your world has changed since our survey last year. There are a number of questions and this...
2019-12-13 (first published: 2019-12-02)
91 reads
How Serverless is Working in Azure SQL Database
When Azure SQL Database introduced the serverless option, I decided to try it. I moved one of my databases to the tier, though I had to move to a...
2019-12-10 (first published: 2019-11-27)
1,051 reads
Cleaning up the [NOT] NULL for Columns with SQL Prompt 10
SQL Prompt 10 is out and there are a few interesting things that have changed in the product. One of these is the Quick Fixes, inspired by some other...
2019-12-06 (first published: 2019-11-25)
414 reads
Data Masker Reads Column Classificiations
One of the newer features in Data Masker for SQL Server is the ability to read column classifications and suggest rules to clean the data. I decided to give...
2019-12-02 (first published: 2019-11-22)
270 reads
Setting Certificate Backup Permissions for an Instance–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was testing some security change, and...
2019-11-20
118 reads
Getting Started with SQL Prompt 10
This week we released SQL Prompt 10, which is an exciting milestone for us. I remember when I discovered this little gem for Database Weekly and sent it over...
2019-11-15
130 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers