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

Latest Blog Posts

Addicted To Busy

Our world is made up of technology and being plugged in 24/7. As you walk down the street you may notice on either side of the sidewalk people walking and looking at their phone. Texting, emailing, social media, and the like is all the buzz. I fall victim to this… Read more

0 comments, 30 reads

Posted in The SQL Professor on 30 July 2015

Professional Development – What a Difference 60 Years Makes

Originally appearing at

In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions of concerned Americans. The Soviet government had leapfrogged America technologically. The dot that traversed the nighttime sky marked a change in international politics and fueled the… Read more

0 comments, 27 reads

Posted in Kevin E. Kline on 30 July 2015

Reblog: The shaky bug in SSIS

SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this issue. Also, it seems that sometimes the fix doesn’t work.

You may or may not have noticed it after installing SQL Server 2012/2014: the designer interface in Visual Studio… Read more

0 comments, 37 reads

Posted in Koen Verbeeck on 30 July 2015

List Out All the SQL servers In domain


In One Of the Group the question was asked that How to list all the Servers in which SQL is installed?

It is genuine query. There are many scenario when you need to Find out how much SQL servers are there in the domain ? many a times… Read more

0 comments, 76 reads

Posted in SQLSERVERS’dba on 30 July 2015

Internal Tables and Space Used

Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little bit of diving into the internals to figure out what is happening or even why it is complex.

I enjoy the… Read more

0 comments, 48 reads

Posted in SQL RNNR on 30 July 2015

Power BI v2 is GA

I guess in the age of rapid development and releases the fact of General Availability of the Power BI v 2.0 on the last friday, 24th of July 2015 was something that anyone somehow connected to the world of Business…

Read more

0 comments, 72 reads

Posted in Niko's blog on 29 July 2015

Hey Kids! Let’s Put on a Show at the Old Barn

Alternate Title: I’m traveling a bunch. Let’s get together and talk.

A bunch of trips and presentations coming up, so I thought I’d share. First, I’ll be SQL Saturday Omaha for my first time ever presenting in Nebraska. I’m excited to add this state to my list (which is almost… Read more

0 comments, 64 reads

Posted in The Scary DBA on 29 July 2015

Halloween at PASS–Donate for some fun

This year’s PASS Summit will end on Oct 31, which is Halloween in the US. I’m sure lots of people will have some fun on Friday, though I also suspect we’ll see no shortage of people leaving early to get home to spend the holiday with families.

A few of… Read more

0 comments, 104 reads

Posted in The Voice of the DBA on 29 July 2015

DBTA – IT Employers Must Adapt to the Looming DBA Shortage

Originally appearing in my monthly column at Database Trends & Applications magazine.

In the first of this three-part series, I described some of the findings contained in an intriguing new survey published by Unisphere Research, a division of Information Today, Inc. In that article, I covered the macroeconomic and… Read more

2 comments, 77 reads

Posted in Kevin E. Kline on 29 July 2015

Some of my favorite SSMS Keyboard shortcuts

I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of my other favorites.

  • Shft+Arrow keys (sometimes + Ctrl): Highlight blocks of code. Adding in the control key moves you a word at a time rather than a single character.…

Read more

3 comments, 88 reads

Posted in SQLStudies on 29 July 2015

Synchronous Processing in the SSIS Script Component

Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component.  This control grants ETL developers complete control over the flow of data, leverages the full power of the .NET Framework namespaces, and can be used as a source, destination, or transformation in data… Read more

0 comments, 51 reads

Posted in Tim Mitchell on 29 July 2015

Password for SQL Server Service Accounts

I wrote recently about my philosophy for service accounts, and wanted to add a few more thoughts.

Security is important for our database servers. One of the loopholes that everyone should be aware of is that the service running SQL Server has complete control over the service and potentially… Read more

0 comments, 169 reads

Posted in The Voice of the DBA on 28 July 2015

Grant’s Fly-by-night Leadership Course – The Plan

  1. Get a better name
  2. Define my personal goals for the course

I won’t be sharing these with you. I may share them with my Inner Circle (defined below). I’m thinking this is a 2-3 year commitment I’m making. I need to have my own set of measurements to ensure that… Read more

4 comments, 91 reads

Posted in The Scary DBA on 28 July 2015

SSC Editorial: Would You Pay to Wear Jeans at Work?

Would You Pay to Wear Jeans at Work turned out to be popular piece when posted a couple weeks back. The premise is that some companies allow a relaxed dress code in return for a donation to a specified charity.  I’ve opted in at times and not at others to… Read more

0 comments, 98 reads

Posted in SQLAndy on 28 July 2015

Database Stuck in Single-User Mode Due to Botched Restore

Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the previous version, I had it stuck in single-user mode.

SSMS provided me with helpful messages such as this:

Changes to the state or options of database 'PoorDb' cannot be made… Read more

0 comments, 82 reads

Posted in SQL Barbarian on 28 July 2015

When Emotional Intelligence Trumps Math

I have been in Corporate IT long enough to know that when a bad decision is made, you move out of the way of that train while quietly doing what you can to mitigate the inevitable wreck that is ahead…

(read the rest on LinkedIn, here)

Read more

0 comments, 89 reads

Posted in @chuckboycejr on 28 July 2015

Creative Schools by Sir Ken Robinson

Education. The key topics for everyone. In his incredibly famous TED Talk “Do Schools Kill Creativity“, which might be some of the most important 20 minutes that you will spend this year, Sir Ken Robinson argued about the current state…

Read more

0 comments, 97 reads

Posted in Niko's blog on 28 July 2015

Present at SQL Saturday #386 – Achievement Unlocked!

SQL Saturday #386 (Albany, NY) – My first SQL Saturday Session

So that picture to the right is me out front of the SUNY Albany campus around 6:45 AM. It was a nice cool morning and I decided to start my day with a nice 5k run around the campus.… Read more

0 comments, 73 reads

Posted in on 28 July 2015

SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited events can be written to the server application or security logs, or to a file where you specify the location (the most secure route).   SQL Server Audit is easy to… Read more

0 comments, 105 reads

Posted in Adam Kreul | Blog on 28 July 2015

What’s the Size of that Index?

I have previously written about finding what the big space consumers are within the database. I even shared scripts in those articles on how to find those big consumers (read all about it here).

That is grand when it comes to quickly finding which objects happen to be… Read more

0 comments, 102 reads

Posted in SQL RNNR on 27 July 2015

Older posts