Type 2 SCD with SQL Merge

I was going through some notes I had from previous projects and came across a sample script for created a...

Audit Configuration Changes

Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was...

Day 17 of 31 Days of Disaster Recovery: When are Checksums Written to a Page

Today is day 17 of 31 Days of Disaster Recovery. The series has skipped a couple of days due to...

Day 19 of 31 Days of Disaster Recovery: How Much Log Can a Backup Log

It’s day 19 of my 31 Days of Disaster Recovery series, and today I want to talk about how much...

Frequently asked Scripts during Interviews

1.Select no of Months between two dates:

SELECT    DATEDIFF(MONTH,'4/1/2011','01/23/2013')+    CASE        WHENDAY('4/1/2011')<DAY('01/23/2013')        THEN 1         ELSE 0     END
Output:
----------------
22

2.What will be the
output of following...

If You Need To Fix Database Filename Extensions

In a recent post I showed how the file extension for a database doesn’t matter. It can be confusing, however,...

Missing Data Quality Service (DQS) buttons in Excel

The Master Data Services add-in for Excel has Data Quality Services functionality to help you match data before publishing it...

New Year Aspirations – Jonathan Allen – DBA

Thanks for agreeing to do this Jonathan, I know you’re busy with arrangements for SQL Saturday #194 in Exeter
 
Before we...

SQL Server – Check Enabled Trace Flags for Server

In SQL Server you can enable a Trace Flag at session (effective for current session only) level and global level....

SQLSaturday 194 (Exeter)

It’s an exciting time for SQL Server Professionals in the South West of the UK, we’re now just a few...