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
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
Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation.
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
What is a Foreign Key?
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
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
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…
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
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
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
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
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
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
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
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
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…
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
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