Contained Databases – Preventing Collation Conflicts
One of the demos from my Contained Databases talk looks at the issues you can have when your database collation...
2012-06-14 (first published: 2012-06-07)
2,335 reads
PAGE_VERIFY – Checksum vs. Torn Page Detection
All this talk of testing backups and data integrity and checksums has me thinking that maybe now would be a...
2012-06-07
10,821 reads
Service Broker: What does a DBA need to know?
Service Broker is SQL Server’s internal messaging system. It has been designed as an asynchronous, reliable and transactional messaging system...
2012-06-13 (first published: 2012-06-07)
10,674 reads
C# Explicit Interface Implementation
In C# it is possible to write classes that implement an interface but only show the methods of the interface...
2012-06-07
52 reads
Optimise Your Disk Subsystem I/O with An Index File Group and Index Compression
As a DBA who is always seeking solutions to performance bottlenecks, amidst the
daily rituals of validating backups and other regular...
2012-06-06
1,706 reads
Powershell Add-Type – Where’s That Assembly!
I’ve been working a lot lately with SMO and the differences between the various versions between SQL 2005, 2008, and...
2012-06-06
17,476 reads
SQL Server Configuration Manager : Cannot connect to WMI provider – Invalid class [0x80041010]
Following error dialog pops up today, when I tried connecting to SQL Server Configuration Manager on my SQL Server 2008...
2012-06-06
25,007 reads
Unable to recycle SQL Agent log: SQLServerAgent Error: 32.
Today the maintenance job that recycles the SQL Agent error log failed on one of our production SQL Server with...
2012-06-06
2,581 reads
SQLSaturday #164 Cleveland – Tick tock, people!
If you haven’t already heard, Cleveland is hosting SQLSaturday #164 on August 18. That date is coming up fast and...
2012-06-06
646 reads
Do You Know An Exceptional DBA?
Do you know a DBA that saves the day time and again? Or one that doesn’t need to save the...
2012-06-06
988 reads
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Making an Impression
Comments posted to this topic are about the item Making an Impression
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers