Audit Configuration Changes

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

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

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

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

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

Why is My New Server Under CPU Pressure?

Signal waits frequently translate to the amount of time that SQLOS is under pressure for CPU resources, as outlined in...

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

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

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