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

Latest Blog Posts

Untrusted Check Constraints

Check constraints are useful for more than just verifying the data that goes into your tables. The query optimizer can use them to avoid looking for values that couldn’t possibly be there.

For example, imagine a listprice field with a constraint that keeps the field value over $100. If a… Read more

1 comments, 86 reads

Posted in SQLSERVERS’dba on 9 October 2015

log reader uses single CPU

For replication even if you have multi core CPU it uses only one as log reader agent has single threaded operation it will use only one threaded only.

Read more

0 comments, 79 reads

Posted in Vinay Thakur on 9 October 2015

MS SQL Server 2014 Mirroring – thanks for being alive!

I decided to check if there is still database mirroring option in MS SQL Server 2014

Wow! It works!

MIrroring is still alive in SQL Server 2014

However in the screenshot you see a message that new tables “in memory” can not be used together with mirroring.

It’s worth noting… Read more

0 comments, 91 reads

Posted in Forrards Group Database Blog on 8 October 2015

Deployed Action and Predicate Metadata with PoSH

I have recently shown that using PowerShell can be extremely powerful in obtaining insight into how to investigate deployed Extended Event Sessions. Throughout the demos I have used, I hope that it has also shown that PowerShell can be very easy to use.

Querying this metadata through TSQL is… Read more

0 comments, 96 reads

Posted in SQL RNNR on 8 October 2015

Be a Social SQL DBA Superhero - #SQLHelp

Following up on my previous blog on introducing the “Social DBA”, I spoke about the concept of leveraging social networking to excel in your professional database career.  The Microsoft SQL Server technical community is quite a unique and diverse bunch, with the commonality of SQL Server technology… Read more

0 comments, 156 reads

Posted in Pearl Knows on 8 October 2015

A Long Trip Ahead

This is my last day at home for a long time. At least long by my standards. I head to the airport tomorrow for a ten day trip, not returning to CO until Saturday, Oct 17. I rarely travel more than 4 or 5 days at the most, so this… Read more

1 comments, 147 reads

Posted in The Voice of the DBA on 7 October 2015

SQL Server Contracting – The first 14 months (or so)

Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem to be adjusted to the world of contracting (or rather adjusted to working more than a mile away from where I… Read more

0 comments, 114 reads

Posted in SQL Server Rocks! on 7 October 2015

Speaking at SQL Saturday #445 - Raleigh, NC - October 10

I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come out to this free training event to hear a bunch of great professionals talk about SQL Server. You can register for the event here: So come on…

Read more

0 comments, 78 reads

Posted in Everyday SQL on 7 October 2015

You DO have outstanding, free backup and maintenance, right?

It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on, or that you read about it on (or one of our newsletters). Or it’s possible that you’ve missed the news. So, ahem. Index Maintenance We have created…

Read more

0 comments, 143 reads

Posted in SQL Awesomesauce on 7 October 2015

Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick - WaterOx Consulting

The Assumption I assume you already have a Hyper-V basic configuration on...

The post Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick appeared first on WaterOx Consulting.

Read more

1 comments, 114 reads

Posted in WaterOx SQL on 7 October 2015

Kicking the Tires on SSIS 2016

Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services in SQL Server 2016. The current beta of SSIS 2016 has some exciting new features that I think you’ll like. The recording of that webinar is below. Enjoy!

The post… Read more

0 comments, 356 reads

Posted in Tim Mitchell on 7 October 2015

Finding the error from a failed job.

This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you have a failed SQL Server job.

Here is our job that will fail:


Then we run it and it fails!

And when we click on the error… Read more

0 comments, 112 reads

Posted in SQLStudies on 7 October 2015

Exposing Deployed Event Metadata with PoSH

In the last article I introduced a power tool that can be used to help manage Extended Events. That tool is PowerShell. In that article, I focused primarily on introducing PowerShell as a power tool to help in discovering the Extended Event Sessions deployed to the server as well… Read more

0 comments, 84 reads

Posted in SQL RNNR on 7 October 2015

TUGA IT Conference 26-28th of May 2016

Between 26th and 28th of May 2016, we (TUGA Association) are organising a major IT event in Portugal – TUGA IT. Targeting Microsoft Data Platform, BizTalk, SharePoint, Office365, Azure Infrastructure & much more, this event will be one of the…

Read more

0 comments, 122 reads

Posted in Niko's blog on 6 October 2015

SQLSaturday Portugal – I am not the principal organiser anymore

Unless you have been sleeping under the rock in the past 5 days, if you are a twitter user, you should have definitely seen some of the reactions and pictures from the passed SQLSaturday Portugal Port-Wine edition 2015. Our second…

Read more

0 comments, 109 reads

Posted in Niko's blog on 6 October 2015

TechFuse Minnesota Follow Up


My Session: Using Azure SQL Database for Enterprise Needs

On 10/6/2015, I presented on Azure SQL Database at TechFuse Minnesota. Some of the highlights from the session included a comparison of the various SQL Server offerings and how Azure SQL Database fits into the overall picture. During the session we… Read more

0 comments, 80 reads

Posted in DataOnWheels on 6 October 2015

Testing Sum By Month

I’ve been on a testing kick, trying to formalize the ad hoc queries I’ve run into something that’s easier to track. As a result, when I look to solve a problem, I’ve written a test to verify that what I think will happen, actually happens.

The Problem

I saw a… Read more

0 comments, 126 reads

Posted in The Voice of the DBA on 6 October 2015

Index selectivity and index scans

There was a question raised some time back ‘If an index is not selective, will the query operators that use it always be index scans’?

It’s an interesting question and requires a look at what’s going on behind the scenes in order to answer properly..

Short answer: No, not always. Read more

0 comments, 97 reads

Posted in SQL In The Wild on 6 October 2015

How I Got my Start at Pragmatic Works

October 4th of this month was my seven year anniversary as an employee of Pragmatic Works. Things have changed a lot over the past seven years. Working with the wonderful people at Pragmatic Works has been quite an amazing journey and incredible opportunity. With that in mind I thought that… Read more

6 comments, 94 reads

Posted in SQL with Dustin Ryan on 6 October 2015

Today at 12pm Central: #MinionEnterprise Talk – Backup Management!

Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how “ME” can help you with your database enterprise. Specifically, this month we’ll show off enterprise backup management. Configure, manage, and report on all backups from a…

Read more

0 comments, 110 reads

Posted in SQL Awesomesauce on 6 October 2015

Newer posts

Older posts