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

Latest Blog Posts

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, 51 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, 41 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, 73 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, 90 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, 115 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, 63 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, 68 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, 63 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, 152 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, 64 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, 83 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, 125 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

2 comments, 67 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, 91 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, 133 reads

Posted in WaterOx SQL on 17 October 2014

Why Haven’t You Changed Everything?

The first in what I hope will be many regular reports on what I’m doing on the PASS board.

To answer the question that I’ve already been asked (who had 47 hours in the pool?), first, I’m not on the board yet. I was elected to it and my term… Read more

3 comments, 104 reads

Posted in The Scary DBA on 17 October 2014

Friday Followup For October 17, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Invite for #TSQL2sday #59 – My Hero!
  • Using Encryption To Protect Your Data From Alien Abduction
  • Building (for…

Read more

0 comments, 84 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 17 October 2014

Eliminate Overlapping Dates

I was looking for an efficient way to eliminate overlapping days when provided with a historical table that provided events that could overlap. In my case, I had dates show the range of a process. However, the multiple start and end dates could overlap, and even run concurrently. To eliminate… Read more

0 comments, 164 reads

Posted in BIT Barbarian on 16 October 2014

The Murder Train is making a stop in Salt Lake City

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I… Read more

0 comments, 87 reads

Posted in A Discussion of SQL Server-Related Topics on 16 October 2014

Older posts