SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2017

What’s that SSIS Password

A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that relates to SSIS. Clients will call for help with an SSIS package that has started failing and they are stuck trying to figure it out. They are all stuck at… Read more

0 comments, 1,294 reads

Posted in SQL RNNR on 30 October 2017

Drop That Schema

An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of the latter, there is an occasional requirement for change. When this need arises, it can turn into a bit of a problem. That is of course if we are… Read more

1 comments, 2,126 reads

Posted in SQL RNNR on 27 October 2017

Seattle SQL Pro Workshop 2017 Schedule

Seattle SQL Pro Workshop 2017

You may be aware of an event that some friends and I are putting together during the week of PASS Summit 2017. I have created an Eventbrite page with all the gory details here.

With everybody being in a mad scramble to get things… Read more

0 comments, 381 reads

Posted in SQL RNNR on 26 October 2017

Seattle SQL Pro Workshop 2017

Seattle SQL Pro Workshop 2017

October is a great time of year for the SQL Server and Data professional. There are several conferences but the biggest happens to be in the Emerald City – Seattle

Some friends and I have come together the past few years to put on… Read more

0 comments, 1,107 reads

Posted in SQL RNNR on 19 October 2017

Linked Servers and Stats

Linked Servers

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for the use of linked servers. Unfortunately, some are of the belief that a linked server is the solution to… Read more

0 comments, 732 reads

Posted in SQL RNNR on 17 October 2017

Your Name is Your Brand

This topic is one that has been stewing for a while and finally this week it decided to boil over.

My first thought with this post was to write a rant. Instead, I want to try and turn it on its end and try to put a different spin on… Read more

3 comments, 447 reads

Posted in SQL RNNR on 13 October 2017