The March release of Azure Data Studio now supports Jupyter Notebooks with SQL kernels. This is a very interesting feature...
2019-04-08 (first published: 2019-03-20)
677 reads
Last week I showed you how to use WorkloadTools to analyze a workload. As you have seen, using SqlWorkload to...
2019-03-27 (first published: 2019-03-12)
1,647 reads
Last week I introduced WorkloadTools and promised additional posts to describe what it can do in more detail. So, here...
2019-02-26
560 reads
If you ever tried to capture a benchmark on your SQL Server, you probably know that it is a complex...
2019-02-15
466 reads
I wish I could say that every DBA has a love/hate relationship with Replication, but, let’s face it, it’s only...
2018-07-11 (first published: 2018-07-03)
2,193 reads
While getting a new workstation is usually nice, reinstalling all your softwares and settings is definitely not the most pleasant...
2017-12-19
885 reads
Let’s face it: column enlargement is a very sensitive topic. I get thousands of emails every month on this particular...
2017-11-15
922 reads
Three years ago, I started to work on a project called ExtendedTsqlCollector. I blogged about it multiple times here on...
2017-10-27 (first published: 2017-10-19)
1,266 reads
If you’re working for a big company, chances are that your IT already has a strategy and tools for dealing...
2017-09-13
972 reads
Today I was reading William Durkin‘s fine post on Presentation Mode in SSMS vNext when inspiration struck.
One of the things that...
2017-03-13
493 reads
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers