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

Latest Blog Posts

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

0 comments, 30 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, 71 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, 120 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

2 comments, 93 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, 77 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, 86 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, 81 reads

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

Notes From The October 15, 2014 oPASS & MagicPASS Meeting (The Souza-Thon!)

Both groups met at a special joint meeting last night at Nova University, part of Operation Souza. Before I go into my usual notes, I want to say thank you to Mark Souza for traveling from Redmond for the meeting. He flew overnight to get here and had a 6… Read more

0 comments, 91 reads

Posted in SQLAndy on 16 October 2014

SSRS report rendered in EXCELOPENXML then something went missing

Recently I had been requested by a client to look into one of their SSRS reports issues. They had one report with a text box that contained some padding from the left side. All seems to be OK, report showed indented text values both in RPL and PDF rendering extensions;…

Read more

0 comments, 148 reads

Posted in Data Adventures on 16 October 2014

Learning Options in Seattle Next Month

The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many people attend the conference, there are some additional options for learning that you might think about in addition to the conference itself. While the conference is great, getting deeper dives… Read more

1 comments, 122 reads

Posted in The Voice of the DBA on 16 October 2014

Creating a SharePoint Server Farm on Azure from the Gallery

As many of you know creating a SharePoint farm for testing can be a daunting task. I volunteered to help troubleshoot an issue that was working with SharePoint Excel Services and it couldn’t be done in Office365. So, my first attempt was to grab the SharePoint Server 2013 Trial from… Read more

0 comments, 95 reads

Posted in DataOnWheels on 16 October 2014

Analytics Platform System (APS) AU2 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has recently released an appliance update (AU2), which is sort of like a service pack, except that it includes many new features.  These appliance updates are made available frequently, about every 3-4 months.… Read more

0 comments, 88 reads

Posted in James Serra's Blog on 16 October 2014

Query Performance Tuning in SQL Server

I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query Performance Tuning in SQL Server 2014″ because it seemed like a good idea to bring out the aspects of 2014, and we will. But, I need to tell you,… Read more

0 comments, 91 reads

Posted in The Scary DBA on 16 October 2014

Insufficient Space to Create Databases For SCOM 2012 R2

Ran into a minor issue while installing SCOM. The wizard wants to create two databases. The first requires a minimum size of 1000mb and a log of 50% of that – call it 1.5g, and the same for the second one. We made it through the first database config step,… Read more

0 comments, 137 reads

Posted in SQLAndy on 16 October 2014


You might be wondering why I’m going into such a simple subject. Well the way I see it there are four options here.

  • You already know the difference, it seems really obvious and you are probably wondering why I’m mentioning it.
  • You think you know the difference but it turns…

Read more

5 comments, 228 reads

Posted in SQLStudies on 16 October 2014

PASS SQL Saturday Events: November 2014

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most… Read more

0 comments, 110 reads

Posted in Marc Beacom on 15 October 2014

Webinar Q&A: SSRS Subscriptions and Data Alerts

Updated 10-16-2014 at 11:20 AM Eastern

Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so thank you to everyone… Read more

3 comments, 98 reads

Posted in Bradley Schacht on 15 October 2014

Older posts