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...

5 MCM Readiness Indexing Videos You Should Watch

Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification.  In the process of...

A Rickety Stairway to SQL Server Data Mining, Algorithm 4: Logistic Regression

  by Steve Bolton
              In the last installment of this series of self-tutorials on SQL Server Data Mining (SSDM), A Rickety...