Microsoft Drops Support For Itanium after SQL Server 2008 R2
Microsoft’s Dan Reger has announced that Microsoft will not be supporting the Itanium architecture after Windows Server 2008 R2, SQL...
2010-04-05
2,336 reads
Glenn Berry
A DMV a Day – Day 5
The DMV for Day 5 is sys.dm_db_mirroring_auto_page_repair, which is described by BOL as:
Returns a row for every automatic page-repair attempt...
2010-04-05
1,022 reads
A DMV a Day – Day 4
The DMV for Day 4 is sys.dm_os_sys_memory, which is described by BOL as:
Returns memory information from the operating system. SQL...
2010-04-04
1,348 reads
A DMV a Day – Day 3
The DMV for Day 3 is sys.dm_os_sys_info, which is described by BOL as:
Returns a miscellaneous set of useful information about...
2010-04-03
1,057 reads
A DMV a Day – Day 2
The DMV for Day 2 is sys.dm_exec_sessions, which is described by BOL as:
Returns one row per authenticated session on SQL...
2010-04-02
405 reads
Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring
Microsoft’s Kevin Cox (from SQLCAT) and I co-authored a blog post titled Using SQL Agent Job Categories to Automate SQL...
2010-04-01
925 reads
A DMV a Day – Day 1
Just as an experiment, I am going to post a different DMV query every day for the next 30 days. ...
2010-04-01
886 reads
Intel Xeon 7500 Series aka Nehalem-EX
Intel has finally released the long awaited (at least by me) 45nm Xeon 7500 series processor. This beast has eight...
2010-03-31
2,004 reads
SQL Server 2008 Database Mirroring: It takes a licking but it keeps on ticking!
With apologies to Timex, I just wanted to relate a minor incident that happened with one of my mirrored databases...
2010-03-30
6,174 reads
Using Custom Connection Colors in SSMS
One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was...
2010-03-29
3,967 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers