Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Database Ghosts

Recently you may have seen my first article on this topic over at SQL Solutions Group.  If not, here is the link so you can read that article first before proceeding here.  This article is intended as a first of two part follow-up to that article.

Now that you… Read more

0 comments, 44 reads

Posted in SQL RNNR on 22 October 2014

Off to London

Today I’m off across the Atlantic again. SQL in the City 2014 kicks off in London and I have 3 talks to give on Friday. Plus a keynote.

Today is keynote practice, last minute packing, and then off to the airport for my flight overnight to London. This will be… Read more

0 comments, 92 reads

Posted in The Voice of the DBA on 22 October 2014

Wishing You a Very Happy Diwali

Wishing You a Very Happy Diwali…………….






??????? : ??????  ???? ?? ???? ??…

Read more

0 comments, 137 reads

Posted in AshishSharePointBlog on 22 October 2014

Force only certain values to be unique

I thought of something rather interesting the other day while answering a question asking for help with some table structures.

In a similar situation to the questioner let’s say we have a Baseball team. There are teams and players. A player can be some combination of coach, assistant coach… Read more

0 comments, 55 reads

Posted in SQLStudies on 22 October 2014

SQL Server Upgrade Preconference at PASS Summit 2014

Please join me and my associates for an all-day SQL Server Upgrade workshop on November 3rd If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop. Join John Martin, Sr. Technology Evangelist from Microsoft, will spend the morning…

Read more

0 comments, 77 reads

Posted in SQL Server BI Blog on 21 October 2014

Have You Contributed to “Argenis Without Borders”?

So, I’m a little behind the ball on all of this.  And others have already blogged about it:

For those that don’t know, earlier this year,… Read more

0 comments, 58 reads

Posted in StrateSQL on 21 October 2014

Consolidating Email Accounts

I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my or either of my email accounts, please use this instead:






I have been slow to respond at times to the other accounts, because I don’t check… Read more

0 comments, 97 reads

Posted in Databases – Infrastructure – Security on 21 October 2014

Webinar: Presenting to the PASS Database Administration Virtual Chapter

In this Webinar, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script, created based on his real-life experience from managing high performing database systems.

Read more

0 comments, 109 reads

Posted in SQLFeatures on 20 October 2014

Minion Reindex arrives this Friday!

The MidnightDBA team is announcing the release of a new, free index maintenance solution for SQL Server: Minion Reindex by MidnightDBA.  We designed Minion Reindex to solve all of the reindexing headaches we’ve experienced at dozens and dozens of client sites. The Bottom Line Your databases need index maintenance for…

Read more

0 comments, 142 reads

Posted in SQL Awesomesauce on 20 October 2014

SQL Server Security Benchmarks

If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:

The Mission of the Center for Internet Security is to enhance the security readiness and response of public private sector entities, with a commitment to excellence through collaboration.

CIS produces consensus-based, best practice secure…

Read more

0 comments, 75 reads

Posted in Databases – Infrastructure – Security on 20 October 2014

Last Weeks Top “Reading” Links #105

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 84 reads

Posted in StrateSQL on 20 October 2014

Add Database File on Database invloved in DB Mirroring

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically.

Steps to Add Database File on Database involved in DB Mirroring :-

1) Break the Mirroring Read more

0 comments, 76 reads

Posted in MSSQLFUN on 20 October 2014

Database Lifecycle Management

There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every application and if you do a similar search, there aren’t very many people talking about Database Lifecycle Management at all. Why not? I’m positive you’re deploying a database with… Read more

2 comments, 165 reads

Posted in The Scary DBA on 20 October 2014

Update to “The clustered index columns are in all of the non clustered indexes.”

I certainly hadn’t planned on creating a part two of this post but in the comments Jeremy Hughes pointed out that my understanding was if not incorrect, incomplete. So I did some additional testing, confirmed a few things with Paul Randal (b/t) and finally felt like… Read more

2 comments, 77 reads

Posted in SQLStudies on 20 October 2014



SQL Server has several ways for you to limit the number of records returned from a query.  For example, the AdventureWorks [sales].[salesorderdetail] table has 121,317 rows loaded in sequential order starting with SalesOrderDetailID 1.  By Using a top 1000 clause I can limit the results… Read more

0 comments, 90 reads

Posted in Business Intelligence and Enterprise Architecture on 20 October 2014

Reducing the size of the distribution database & improving transactional replication performance: Part 3

Part 1 of this series of articles looked at the intricacies of SQL Server transactional replication, and made the observation that the clean-up mechanism treats publications as a collective.  Part 2 looked at how differing distribution job schedules can cause unnecessary bloating in the distribution database.

The final (and much… Read more

0 comments, 136 reads

Posted in Chris Jenkins' Blog on 20 October 2014

Be Careful! Backups Can Bite You!

Here is a riddle for you…

You are requested to move a database from an old server to a new server. As a professional and experienced DBA, you prepare a checklist of actions to take, you script everything, you document your plan, and, of course, you test it before doing… Read more

6 comments, 83 reads

Posted in Guy Glantser on 20 October 2014

Reblog: October 10 to October 16

Photo credit – JStove

Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no such things as unicorns, so I can… Read more

0 comments, 102 reads

Posted in StrateSQL on 17 October 2014

Untrusted Foreign Keys

  What is a Foreign Key?

Do you trust your foreign keys?

A foreign key is a link between 2 tables that is used to enforce referential integrity in the database.

For example, if you have an order and a customer table, there is probably a logical relationship between the 2… Read more

1 comments, 2,635 reads

Posted in WaterOx SQL on 17 October 2014

Older posts