My Biggest Weakness
I took some time off in December and I'm finally getting around to catching up on RSS feeds. Turns out...
2009-12-31
1,517 reads
Blog Posts
Running a Small User Group - Remember, It's Not Exclusively Yours
I'm going to conclude this series on running a small user group with a topic that came up for discussion earlier...
2009-12-31
1,414 reads
Saying Goodbye To 2009
I'll close out 2009 with an update on the goals I set at the beginning of this year and things...
2009-12-31
1,396 reads
Script Individual User Rights in a Database with PowerShell
Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...
2009-12-31
1,436 reads
Stored Procedures to Store and Get Database Users with All Permissions
Introduction
Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...
2009-12-31
1,789 reads
A Small Collection of I/O Specific DMV Queries
It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many...
2009-12-30
4,231 reads
Looking back at 2009 Goals
I set goals at the start of 2009 for the year. They were:
Continue with 400 posts a month Blog Daily...
2009-12-30
1,732 reads
Practice Your Restores
Steven Jones posted an excellent editorial today all about how your backups are only good if you know that you...
2009-12-30
1,322 reads
Running a Small User Group - The Tools
Because running a small user group is a labor of love, we look for time savings wherever we can to...
2009-12-30
1,833 reads
Wrapping Up Blogging for 2009
I think I’ve met my goal of blogging every day. I’m at almost 800 posts now over the past 2.5...
2009-12-30
1,406 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...
BCA KCU RAWAMANGUN Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
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...
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