Breaking Down TempDB Contention
Breaking Down TempDB Contention
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...
2010-03-05
82,117 reads
SQL Saturday Schedule Update
In January, I blogged about the upcoming SQL Saturdays for 2010, and since then, many more events have been scheduled,...
2010-03-05
615 reads
Worst Thing to Do to your DBA
Recently Andy Warren Blogged about things that could drive your DBA mad. There was a lot of feedback on SQLServerCentral...
2010-03-05
769 reads
Keep Your Data Clean
In working with client data you start to notice trends that raise flags in your mind. In my case I'm...
2010-03-05
513 reads
Going to Charlotte for SQLSaturday #33
I’m flying up Friday afternoon for SQLSaturday #33. Looking forward to the trip, Charlotte is a great area and I...
2010-03-05
395 reads
PASS Update #24
Time to update you again on all things PASS. First, I haven’t made a lot of progress on the speaker...
2010-03-05
539 reads
More SQL Azure Samples
I have been playing around some more with SQL Azure in order to get ready for an upcoming presentation, so...
2010-03-05
2,281 reads
Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen...
2010-03-05
873 reads
Time Off, Down Time, Round Up
I have taken some time off this week, I have been to the beach with my two golden retriever puppies....
2010-03-04
692 reads
Speaking at SQLSaturday #33 in Charlotte
I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather...
2010-03-04
579 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers