The Nature of the Database-Driven Developer
Bear with me as I wax philosophical for two sentences. Our societies are becoming more polarized with each passing day. ...
2010-06-03
685 reads
Blog Posts
Catch Performance Issues Early!
I have posted this before elsewhere. However, due to the frequency in which I come across this, I feel it’s...
2010-06-03
593 reads
Daily SQL Server 2008 new Feature – Day 15
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-03
402 reads
Drive Space
I found a cool series of scripts from Jeremiah Peschka on getting disk space from SQL Server. They’re useful queries,...
2010-06-03
1,982 reads
List of indexes and Parallel queries
Today while being on forum found this information so though to blog for future reference. thanx Uri Dimant for sharing...
2010-06-03
461 reads
Notes about Server SSDs
Note: This isn’t a recommendation or endorsement, just notes from some research I’ve done. Please contact your vendor before making...
2010-06-03
552 reads
One more Fix Database Role in SQL Server
Fixed Database Rols are: db_ddladmin, db_owner, db_accessadmin, db_securityadmin, db_backupoperator, db_datawriter, db_datareader, db_denydatawriter, db_denydatareader + one more that is dbm_monitor.
This is...
2010-06-03
1,701 reads
Performance Tuning Series
To kick off this blog, I am going to start with a topic that is hot on the mind of...
2010-06-03
754 reads
Sins of a Recursive CTE?
On June 1, 2010, Steve Gray had an article, Sins of SQL: The Time Table, published on sqlservercentral.com. I’m not...
2010-06-03
2,591 reads
Slides from SQL Server Auditing Class
Here are the slides from the SQL Server Auditing Class held on June 2, 2010.
Hour 1 - Attacking SQL Server
Hour 2...
2010-06-03
1,021 reads
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers