Final Reminder – SQLSaturday #32 in Tampa on Jan 23, 1010
I’ve had to cancel my plans to attend, which also included plans for a late lunch at the Green Iguana...
2010-01-22
538 reads
Blog Posts
Microsoft – Follow best practices!
Best practice is to use parametrized queries to enable plan reuse. Will someone please tell Microsoft this.
Presently dm_exec_cached_plans on...
2010-01-22
1,011 reads
SSIS Checkpoints with Tasks Running in Parallel
Several months ago I blogged about why Checkpoints are a great feature in SSIS to use. It seems with every...
2010-01-22
3,476 reads
Andy on Twitter
Just prior to the 2009 PASS Summit I posted about giving Twitter a try, and thought I’d report back on...
2010-01-21
2,190 reads
Azure platform CTP accounts are about to expire?
I recieved the notification from Azure Platform Team that the CTP accouct will be closed at the end of the...
2010-01-21
379 reads
Creating the SSC Maintenance Plan: Part 3
Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...
2010-01-21
1,756 reads
Getting here from there
Another month, another blog chain, this time started by Paul Randal. I got tagged by both Grant and Steve, on...
2010-01-21
395 reads
How Do You Handle the Stress of Being a DBA?
This is a reprint of my editorial at SQLServerCentral.com. There is a lively discussion at the SSC forum on this...
2010-01-21
414 reads
Instant File Initialisation
I have been reading up on instant file initialization and I have read a couple of good blog posts by...
2010-01-21
1,413 reads
Part 3: Creating the SSC Maintenance Plan
Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...
2010-01-21
974 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Pantai Indah Kapuk Tlpn/Wa 0853.7373.7551
Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara, Kecamatan Penjaringan, Jkt...
BCA KCP Tebet Barat 2 Telpon/WA:08137887595
BCA KCP Tebet Barat 2 Telpon/WA:08137887595.Jl. Tebet Raya No.25 B Blok CI, Tebet Tim.,...
BCA KCP Puri Deltamas Tlpn/Wa 0853.7373.7551
Komplek Ruko Puri Deltamas Blok J. 5, Jl. Bandengan Sel. No.43, Daerah Khusus Ibukota...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers