If not me, then who?
[Content Warning: this post contains references to subjects that may trigger a trauma response. Read with caution.] This is not a technical post. I was going to write about...
2020-09-16
55 reads
Blog Posts
Resizing Tempdb (When TEMPDB Wont Shrink)
Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of...
2020-09-16 (first published: 2020-09-09)
897 reads
Automate Credit Card Audits
In this article, I have shown how to use the power of automation to help identify the risk of having card data stored in the database. Identifying this risk...
2020-09-15 (first published: 2020-09-08)
272 reads
Automation Ideas for T-SQL Tuesday #130
This month we have another great T-SQL Tuesday topic, and again, a host that I pressured into writing the invitation. Elizabeth Noble (@SQLZelda) and I were talking DevOps last...
2020-09-15 (first published: 2020-09-08)
664 reads
Azure DevOps at the Data Platform Summit 2020
I was lucky enough to go to the Data Platform Summit in 2017. I still have one of my favorite speaking pictures from the event: I took my whole...
2020-09-15
26 reads
Daily Coping 15 Aug 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-15
9 reads
Daily Coping 14 Sep 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-14
19 reads
Reflections on Being a New Gopher With A Dotnet Background
Disclaimer
Newbie Gopher.
Much of what I observe is likely to be half right.
I’ll probably look back at the end of the year and shake my head, but gotta start the...
2020-09-14 (first published: 2020-09-07)
281 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
2020-09-13
24 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