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,664 reads
Blog Posts
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,821 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
862 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,063 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
598 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
734 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,146 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,245 reads
SQL Server 2012 (“Denali”): Details on the next version of SSRS
SQL Server 2012 contains six new features for SSRS:
Excel Renderer for Microsoft Excel 2003, 2007 & 2010 - Excel renderer will support the Excel...
2012-03-05
1,601 reads
What Does a Database Administrator Actually Do?
Most people in your organisation, never mind everyone else, have no real clue as to what it is you do.
It’s...
2012-03-05
1,652 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers