T-SQL Basics: using OUTPUT
You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-03
15 reads
Blog Posts
Upcoming Speaking Engagements
I presented a few times in 2019, and I’m starting off 2020 with several as well. Here’s what’s on the schedule for Q1.
2020-01-06 Yep, ISO8601 format. That’s how I...
2020-01-03
15 reads
Why I’m Learning Git via the Command Line Interface
I’ve learned a bit about Git in the last year: I’m now quite comfortable creating and managing Git Repos in Azure DevOps. I frequently do demos with SQL Change...
2020-01-03
11 reads
Ad Hoc Queries Disabled
This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:
Linked Servers and Stats October 17,...
2020-01-02 (first published: 2019-12-20)
1,376 reads
CPU custom module available for Inspector V2
If you need to keep track of CPU and are not fortunate enough to have a monitoring tool to keep hold of historical CPU usage then this module may...
2020-01-02
32 reads
Creative Database Naming
Every now and again, we as DBAs need to get away from the daily grind of the hum drum tasks. We need to find a way to have a...
2020-01-02
579 reads
Creative Database Naming
Every now and again, we as DBAs need to get away from the daily grind of the hum drum tasks. We need to find a way to have a...
2020-01-02
21 reads
Powershell : Desire State Configuration -DSC
Powershell in 2012, Powershell 4.x onwards introduced Desire State Configuration(DSC) which help to build the standard configuration/ process /template for your system state and can be use or maintain...
2020-01-02
195 reads
Prompt in ADS
Ever since VS Code and Azure Data Studio came out, people have been asking for SQL Prompt to port over. I’ve been right there with you, though unsure of...
2020-01-02 (first published: 2019-12-13)
249 reads
2019 in Review
What an incredible year it’s been. I kept thinking that I was busy, but I had no idea until I looked at the final numbers (I have a Power...
2020-01-01
124 reads
Blogs
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
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...
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