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

Latest Blog Posts

The Database Corruption Challenge

For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes today and even though I haven’t been able to take part in all of them, I have thoroughly enjoyed working through these challenges.

DBAs don’t often get… Read more

1 comments, 201 reads

Posted in The DBA Who Came In From The Cold on 20 July 2015

How to close all active database connections in one shot?

While trying to restore SQL Server database or do any other actions which require exclusive database access you may face with the following error:

Exclusive access could not be obtained because the database is in use.

Here is a quick solution which is much handier than killing all connections manually… Read more

6 comments, 594 reads

Posted in Forrards Group Database Blog on 20 July 2015

Filtered Index restrictions and Kendra Little’s Index Quiz

A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had to give them a shot and while I was somewhat disapointed in my scores on a few over all they were a lot of fun.… Read more

0 comments, 1,376 reads

Posted in SQLStudies on 20 July 2015

SQLSaturday Orlando 2015–Classes on Thursday and Friday for Even More Learning

We have a solid tradition here in Orlando of offering some all day classes the Thursday and Friday before SQLSaturday. It started way back at #1 when we brought Joe Celko to town! It’s a way to give our local community the chance to do some deeper learning at a… Read more

0 comments, 88 reads

Posted in SQLAndy on 20 July 2015

SQL Server Polybase (2016)

What is SQL Server Polybase?

Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage.  This technology will allow you to continue to leverage SQL Server for your data warehousing and access data stored in different formats… Read more

0 comments, 216 reads

Posted in Business Intelligence and Enterprise Architecture on 20 July 2015

Introduction To Temporal Tables In SQL Server 2016

Hi friends, today I will get you introduced with another new feature of SQL Server 2016 i.e. Temporal Tables. SQL …

Continue reading Read more

0 comments, 2,077 reads

Posted in Kapil Blogs on 20 July 2015

HASSUG BI Developer Presentation on 7/14/2015

I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG).  This session resulted from feedback we received in the user group on differences between database developers and BI developers.  If you are interested in seeing the presentation content it is uploaded here: Read more

1 comments, 142 reads

Posted in Business Intelligence and Enterprise Architecture on 19 July 2015

See you at SQL Saturday Baton Rouge 2015!

SQL Saturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day of technical training. The Baton Rouge SQL Saturday 2015 event is produced by the Baton Rouge User Groups, and will be our sixth annual event on campus at LSU. We…

Read more

0 comments, 95 reads

Posted in SQL Tact on 19 July 2015

Merge statement- A simple way for DML TIP#105

When, I first saw this statement a Hindi proverb  come to my mind which is “1 teer 2 nishane” . The meaning of this proverb means a single bow which hit two different aim in one shot.

So let me explain “Merge” statement in more detail. With the help of… Read more

0 comments, 256 reads

Posted in Rajat Jaiswal-337252 on 18 July 2015

SQL Server Infernals – Circle 5: Inconsistent Baptists

There’s a place in the SQL Server hell where you can find poor souls wandering the paths of their circle, shouting nonsense table names or system-generated constraint names, trying to baptize everything they find on their way in a different manner. They might seem innocuous at a first glance, but… Read more

6 comments, 1,714 reads

Posted in SpaghettiDBA on 17 July 2015

012 – Carlos Chacon - WaterOx Consulting

Reading Time: 2 minutes

Someone worth getting to know in the Mid-Atlantic region! In WOxPod!, episode...

The post 012 – Carlos Chacon appeared first on WaterOx Consulting.

Read more

0 comments, 148 reads

Posted in WaterOx SQL on 17 July 2015

WaitForSql (to start)

In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a SQL Server database and just keeps retrying until it is available:

What? Huh?

If you have a CI build and…

Read more

0 comments, 152 reads

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

Validating Cluster Instance Owner with Powershell

A few weeks ago, for TSQL Tuesday, I wrote about how I used Powershell to manage failing over clusters.  At work, we have now implemented that script in our patching process and it has reduced our patching time significantly.  However, the process was still missing something.  A validation… Read more

0 comments, 205 reads

Posted in John Morehouse | on 17 July 2015

Murder and XE Train in Louisville

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops here.

Amazing this… Read more

0 comments, 372 reads

Posted in SQL RNNR on 17 July 2015

SQL Server: utilize partitioning to purge large tables

Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables are large enough. This can be done using table partitioning. Such approach is used rarely but in case of really large table it is very useful. In this article we`ll… Read more

0 comments, 688 reads

Posted in Forrards Group Database Blog on 17 July 2015

Speaking next Wednesday July 22nd, at Vermont SQL PASS group, thanks to Roman Rehak? for the invite!

Speaking next Wednesday, Vermont SQL PASS group, thanks to Roman Rehak? for the invite!
I'll be doing an update to Database Security Best Practices for the Vigilant DBA and Developer, with a look at SQL 2016 CTP2.1 Always Encrypted option.
UPDATE, post meeting download available now (improved link too):…

Read more

0 comments, 137 reads

Posted in The Database Hive for SQL Server DBAs on 17 July 2015

Introduction To Query Store In SQL Server 2016 – Part 2

Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what …

Continue reading Read more

0 comments, 262 reads

Posted in Kapil Blogs on 17 July 2015

How do different types of functions compare performance wise?

A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement Table-Valued Functions (MSTVF). Since then, whenever I speak about ITVFs / MSTVFs, I’m frequently asked about how Scalar Functions (SF) perform. My stock answer has always been that they perform… Read more

0 comments, 129 reads

Posted in A Discussion of SQL Server-Related Topics on 16 July 2015

SSC Editorial: Is the Golden Age of Information Technology Almost Over?

Posted last week, Is the Golden Age of Information Technology Almost Over? generated some interesting comments. It’s tough to write about potential changes without saying the sky is following, but it does make a good opinion piece!

I was discussing it with Steve Jones after it was published and he… Read more

0 comments, 108 reads

Posted in SQLAndy on 16 July 2015

Professional Development – Interviews are a Two-way Street

(Originally appearing at

I was recently chatting with a friend who was seeking advice about difficulties in their job. This was a job which, a year ago, she described as her dream job. It quickly became evident to her that it was actually a nightmare job. The company,… Read more

0 comments, 735 reads

Posted in Kevin E. Kline on 16 July 2015

Newer posts

Older posts