2012-04-12
2,193 reads
Administration
The Best Database Administrators Automate Everything
Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once it's gone, that's it, gone forever.
2014-08-22 (first published: 2012-04-06)
18,711 reads
SQL Server Instant File Initialization (PQW)
In this article we’re going to look at instant file initialization. What it is, why it’s cool and how you can use it in your environments.
2012-04-02
5,212 reads
2012-02-24
2,292 reads
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
2014-01-06 (first published: 2012-01-26)
4,311 reads
2012-01-25
2,235 reads
2012-01-23
2,664 reads
2012-01-13
2,163 reads
2012-01-09
2,293 reads
2012-01-05
2,293 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 HARAPAN INDAH Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2 No. 1, RT.10/RW.8, Pusaka...
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