Actual Emails: TL;DR: Stop using varchar(max)
Wrote this email recently to a crew of developers who were shooting themselves in the foot with a database rich...
2013-09-05 (first published: 2013-09-03)
3,224 reads
SQL Server – How to Perform Striped Database Backup & Restore Using T-SQL Command
Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my...
2013-09-03
1,670 reads
SQL Server: Data File Structure
In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about the organization of the data file.In other words...
2013-09-03
835 reads
Sending Mail using SQL Server Express Edition
In SQL server standard and enterprise edition,A DataBase mail functionality in built to sent mail.But in SQL Server express edition,You...
2013-09-02
65,490 reads
Rare Species, Extinction and the MCM
As of 11:04 PM MST ( -6 UTC ), the Microsoft Certified Master along with the other certifications in the Advanced certification series at Microsoft joined the ranks of...
2013-09-02
9 reads
Rare Species, Extinction and the MCM
As of 11:04 PM MST ( -6 UTC ), the Microsoft Certified Master along with the other certifications in the Advanced certification...
2013-09-02
1,217 reads
SQL Server: Data File Structure
In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about...
2013-09-02
2,647 reads
Handling Large Many to Many bridge tables
In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of...
2013-09-02
3,392 reads
70-457 Reviewer #11 Configuring and Maintaining a Backup Strategy
This topic is the second part for lesson Manage Data which covers 20% of the examination. Understanding Backup Types SQL...
2013-09-01
544 reads
Is the Master Certification Dead or Will it be Born Again?
The Certified Master and Architect community was collectively notified Friday, August 30, 10 PM Pacific Time (Microsoft Time) that the...
2013-09-01
939 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers