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

Latest Blog Posts

AdventureworksCI Step 3 Handling data with SSDT

This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server database into source control? What issues do we face and how hard is it? Then how do we build a continuous…

Read more

0 comments, 26 reads

Posted in Ed Elliott's Sql Developer Blog on 7 July 2015

SQL Server Infernals – Circle 4: Anarchic Designers

Constraints are sometimes annoying in real life, but no society can exist without rules and regulations. The same concept is found in Database Design: no good data can exist without constraints.

What they say in Heaven

Constraints define what is acceptable in the database and what does not comply with… Read more

0 comments, 29 reads

Posted in SpaghettiDBA on 7 July 2015

T-SQL Tuesday #68 - Just Say No to Defaults & Stay Healthy

Happy T-SQL Tuesday, July 07, 2015! @SQLBek, Andy Yun, has launched his own “Just Say No” campaign, and that is in the form of this month’s terrific T-SQL Tuesday topic, #68, “Just Say No To Defaults (To view the original invite, click on the previous… Read more

0 comments, 36 reads

Posted in Pearl Knows on 7 July 2015

Are People’s Food Habits Changing? A Power BI Analysis

A few years ago on road trips I’d happily grab whatever I can find to eat at service stations. That usually includes either McDonald’s, KFC, or Burger King. But today I wouldn’t mind driving a few miles off-route to eat something healthier. If you follow any financial news, you’ll notice… Read more

0 comments, 49 reads

Posted in Sam Vanga on 7 July 2015

Use Trace Flag 902 to Recover from a Cumulative Update Failure

Recently, I ran into a critical error while I was helping a customer troubleshoot an issue in SQL Server. That may not sound like a big deal, but we were installing Cumulative Update 6 for SQL Server 2012 SP2 to fix our initial problem when we encountered the following error.

Read more

0 comments, 47 reads

Posted in Everyday SQL on 7 July 2015

TSQL Tuesday #68 – backup checksum default


Well it seems like TSQL Tuesday #68 is providing me with a real good reason to get back into my blogging again. It been a while – due to various life events – but I think it’s time to dust off my virtual pen and start a (hopefully)… Read more

0 comments, 31 reads

Posted in measure twice, cut once. on 7 July 2015

It is OK its NULL only TIP #103


We always take NULL very lightly. Like if we are designing database then whether it is necessary or not we allow the data field to accept null.We think it will not affect anything.

Actually , at some point this is not always true.

According to Microsoft NULL is an… Read more

0 comments, 44 reads

Posted in Rajat Jaiswal-337252 on 6 July 2015

Execute All Packages Within SSIS Project Catalog

The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the package execution logging and reporting that is provided by this model but …. (there is always a but :), right), lately I’ve been looking for ways to execute all packages… Read more

0 comments, 78 reads

Posted in Select SIFISO Blogs on 6 July 2015

But I Don’t Have a Test Server…

I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to do something I’ve never done before directly on my production servers…” This is usually followed by questions along the lines of:

  • But that’s OK and I won’t get fired, right?

Read more

0 comments, 102 reads

Posted in The Scary DBA on 6 July 2015

New Extended Events for 2016

As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made available to us in order to help support and troubleshoot these new features. With that, it… Read more

0 comments, 60 reads

Posted in SQL RNNR on 6 July 2015

Adding a new keyboard shortcut in SSMS.

I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. Not that I won’t use the mouse, but only when I have to. One frequent (and annoying) task that I haven’t been able to find a keyboard shortcut for is… Read more

2 comments, 68 reads

Posted in SQLStudies on 6 July 2015

Columnstore Indexes – part 58 (“String Predicate Pushdown”)

Continuation from the previous 57 parts, the whole series can be found at I have previously blogged on the predicate pushdown matter in the post Columnstore Indexes – part 49 (“Data Types & Predicate Pushdown”), and from the published…

Read more

3 comments, 104 reads

Posted in Niko's blog on 5 July 2015

Announcing Columnstore Indexes Script Library

Today, the 3rd of July 2015 marks the 2rd anniversary of my very first Columnstore Indexes blog post in the series that is going strong for 60 different posts (57 traditional + 3 azure-focused ones) since then. On this day,…

Read more

2 comments, 123 reads

Posted in Niko's blog on 5 July 2015

How to Run DBCC CHECKDB to Check SQL Database Integrity

Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The command is supported in databases that contain memory-optimized tables but the validation is only supported in disk-based tables. The DBCC repair option is unavailable in memory-optimized tables and therefore,… Read more

0 comments, 210 reads

Posted in Zora's SQL Tips on 4 July 2015

Run SQL Server In A Container Today July 2015

Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official support to Windows. While this is great news it is unlikely to be something most IT departments can use in the near term mainly because it takes time for everyone…

Read more

0 comments, 43 reads

Posted in Ed Elliott's Sql Developer Blog on 3 July 2015

010 – Ayman El-Ghazali - WaterOx Consulting

Reading Time: 2 minutes

The community makes it all happen! In WOxPod!, episode # 009 –...

The post 010 – Ayman El-Ghazali appeared first on WaterOx Consulting.

Read more

0 comments, 118 reads

Posted in WaterOx SQL on 3 July 2015

Speaker of the Month: June 2015

With my travel schedule, I don’t always get out to events where I can see a community speaker. Sometimes, I just see pros. That’s the case this month. Instead of skipping the month entirely, which feels wrong, I’ve decided to do a special award.

Speaker of the Month for June… Read more

0 comments, 90 reads

Posted in The Scary DBA on 3 July 2015

Speaking engagements for August and September

August and September are going to be some busy weeks!
In those two months I will be speaking on three SQLSaturday events:

Read more

0 comments, 111 reads

Posted in DotNine SQL Server and more on 3 July 2015

How to drop a Temporal Table

No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or in other words, system-versioned tables. We’ll see what catches on. In a gist, such a table keeps track of the history of its rows by the use… Read more

0 comments, 123 reads

Posted in Koen Verbeeck on 3 July 2015

Older posts