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

Latest Blog Posts

Indexed views on any core SQL server edition–The video

A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to be one of my most read blog posts. Since then Webucator, provider of SQL Server training, got in contact… Read more

0 comments, 32 reads

Posted in SQL Server Rocks! on 10 October 2015

Video of #sqlrelay talk - build a ci pipeline in 55 minutes

My session yesterday was recorded, apart from the fact that me and mark were having a chat for about 25 minutes before it kicked off it seemed to work quite well:

Skip forward to 24:32 to get to the actual content.

Read more

0 comments, 59 reads

Posted in Ed Elliott's Sql Developer Blog on 9 October 2015

How do you choose a source control system for your SQL Server database

If you already have a source code repository for your app code or other databases or you have another team that uses source control then just use theirs.

If you don't then use whatever the members of your team have used most, they all basically do the same thing and…

Read more

0 comments, 73 reads

Posted in Ed Elliott's Sql Developer Blog on 9 October 2015

SQLRelay Reading - Build a CI Pipeline in 55 Minutes Talk

I had a lot of fun yesterday presenting my talk on how to go from not having your database in version control to deploying to a CI database, running unit tests and generating deployment scripts for a QA/Prod database so effectively how to build a fully functioning continuous delivery process…

Read more

0 comments, 59 reads

Posted in Ed Elliott's Sql Developer Blog on 9 October 2015

Excel Tip #29: Forcing Slicers to Filter Each Other when Using CUBE Functions

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 48 reads

Posted in DataOnWheels on 9 October 2015

Thank You Community

All I can say is, “Wow…Thank you!”.  I won a seat on the PASS Board of Directors and it’s very surreal.  I am beyond excited, but not for what happened.  I’m excited and energized for what is to come.  PASS is young and our industry is in constant flux so… Read more

0 comments, 58 reads

Posted in Ryan Adams on 9 October 2015

Deployed Target Metadata with PoSH

Having just covered the methods to discover the metadata for a deployed session including the details about the session settings, events, actions, and predicates, I am nearly finished with the session metadata. All that remains is to dive into the metadata for Targets.

Through the articles thus far, I have… Read more

0 comments, 44 reads

Posted in SQL RNNR on 9 October 2015

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

0 comments, 62 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, 60 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, 71 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, 73 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, 138 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, 119 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, 98 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, 62 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, 124 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, 99 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, 130 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, 98 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, 76 reads

Posted in SQL RNNR on 7 October 2015

Older posts