A DBAs List of Little Things
Today is Meme Monday. Today we get to talk about all of the little things a DBA does. Thomas LaRock started things off with his list – here. I...
2012-03-05
8 reads
Blog Posts
Are my Linked Servers Being Used?
This is a follow up to an article published on 3/1/2012. That article showed how to find what linked servers...
2012-03-05
2,750 reads
Are my Linked Servers Being Used?
This is a follow up to an article published on 3/1/2012. That article showed how to find what linked servers were created on your instance of SQL Server. You...
2012-03-05
21 reads
Database Mirroring
Introduction
This blog covers the High Availability Solutions provided by SQL Server i.e. Database Mirroring.
Database mirroring is a solution in SQL...
2012-03-05
1,834 reads
Find the latest databse backup SQL server
AdvertisementsUse the simplest script to find the latest database backup and the location.
-- To get the backup history
SELECT top 100...
2012-03-05
866 reads
How to use Change Data Capture (CDC)
With SQL Server 2008 Microsoft added the CDC feature to SQL Server enterprise edition. I haven’t come to play around...
2012-03-05
8,084 reads
Register for SQL Server 2012 Virtual Launch
`As we all are aware SQL Server 2012 virtual launch is scheduled after 60 hours roughly. Earlier I have discussed...
2012-03-05
601 reads
Reporting Services 2008–Books
I have had a few people ask me recently about books that I would recommend to help further develop your...
2012-03-05
741 reads
Restoring a Certificate
I have written about creating a certificate and backing up a certificate, and the next step is the restoration of...
2012-03-05
20,351 reads
RYO Maintenance Plan – Index Maintenance
It’s been a couple of weeks since my last post, but I swear I have a good excuse. I’ve been...
2012-03-05
1,257 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
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers