Blog Refresh – Growing Readers
Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes of sharing new technology I was learning. The first post was as you could guess,...
2020-10-27
32 reads
How To: Create Schema Only Database Copies
Have you ever been asked to make a schema only copy of a database? What is your preferred method to complete this request? Below we will discuss how to...
2020-10-26 (first published: 2020-10-20)
1,432 reads
Copying an Azure SQL Database
Copying an Azure SQL Database is a vital skill when managing cloud databases. Recently, a request was received from the “business”. They wanted to create a copy of an...
2020-10-21 (first published: 2020-10-13)
291 reads
Checking your dumps!!!
No, No, not those dumps: SQL Server Memory dumps!! Recently, I was on Slack and wondered into the #firstresponderkit channel. I am a big fan of all the First...
2020-10-13 (first published: 2020-10-06)
685 reads
Failing SQL Agent Jobs – Part 4
Here we are, another Tuesday!! It is time for our Fourth and final installment in the Failing SQL Agent Jobs series. This week, we will cover how to store...
2020-10-06 (first published: 2020-09-29)
328 reads
[MSSQLTips] Visual Studio 2019 Configuration for the Production DBA
Happy Tuesday everyone… Today I am honored to have my first article published on MSSQLTips.com. As a Production SQL Server Database Administrator, you do not usually find yourself in...
2020-09-28 (first published: 2020-09-22)
592 reads
Failing SQL Agent Jobs – Part 3
It is Tuesday!! Time for Part 3 in the series about SQL Server Agent Job Failures. This installment will show you how to setup SQL Agent Alerts and Operators...
2020-09-22 (first published: 2020-09-15)
314 reads
Failing SQL Agent Jobs – Part 2
Welcome to Part 2 in the series about SQL Server Agent Job Failures. In this part you are going to learn how to build an HTML report with Failed...
2020-09-18 (first published: 2020-09-10)
644 reads
T-SQL Tuesday #130 – Automate Permissions Audits
This month’s T-SQL Tuesday is being hosted by Elizabeth Noble. The subject chosen “what have you automated to make your life easier?” For me the topic is near and...
2020-09-14 (first published: 2020-09-08)
441 reads
Failing SQL Agent Jobs – Part 1
SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log...
2020-09-09 (first published: 2020-09-01)
646 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers