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

Archives: September 2015

Fixing MSI errors during patching

Patching is an activity that is frequently performed by DBA’s. It is the responsibility of a DBA to keep the SQL servers up and running all times and ensure the  Cumulative Updates, Service Packs, out of band hot-fixes are applied to the instances.It’s hardly a 30 min task if…

Read more

0 comments, 3,314 reads

Posted in Kruti's SQL Blog on 29 September 2015

SQL Server – Various methods to generate unique number sequence

Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number …

Continue reading Read more

0 comments, 563 reads

Posted in Kapil Blogs on 28 September 2015


I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow my career in a few different ways, as well as investigate where some of the new languages and platforms might be useful for data analysis. As I’ve talked to some… Read more

0 comments, 655 reads

Posted in The Voice of the DBA on 28 September 2015


I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow my career in a few different ways, as well as investigate where some of the new languages and platforms might be useful for data analysis. As I’ve talked to some… Read more

0 comments, 354 reads

Posted in The Voice of the DBA on 28 September 2015

Intro to the Social DBA with a bit of #SQLHelp

Are you a Social DBA?  No I don’t mean that you are a DBA and attend a myriad of merry mixers, networking events, post SQLSaturday soirees, or PASS parties. (Yet that’s a great way to make connections, and build your professional database of career-complimenting contacts.) I’m talking about putting… Read more

0 comments, 2,145 reads

Posted in Pearl Knows on 28 September 2015

Deployed Session Settings

You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking about deployed sessions again. And it may even be considered metadata as well. This time around, the metadata I will be discussing is a little bit different but will build… Read more

2 comments, 1,078 reads

Posted in SQL RNNR on 28 September 2015

SSMS Connection Information

If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it can be kind of hard to remember which connection is which. Fortunately all of the information you need is readily available.

Connections in the Object Explorer

Notice that for each… Read more

0 comments, 1,918 reads

Posted in SQLStudies on 28 September 2015

Advanced SSIS Training Course Preview

If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and me in the Washington, DC area for our 4-day Advanced SSIS classroom training course. This course will be held December 7-10 in Reston, VA (just outside of DC). I’ve… Read more

0 comments, 1,932 reads

Posted in Tim Mitchell on 28 September 2015

Power Bi, PowerShell and SQL Agent Jobs

Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs – The SQL Agent Job report. You can get the scripts and reports here

This gives a quick overview of the… Read more

3 comments, 3,019 reads

Posted in SQL DBA With A Beard on 28 September 2015

Why I Don't Use the Architect Title

I get nervous when I see the title "architect" in IT job roles.

I've had this title before as an employer's standard, but lobbied against it. I instead prefer separating job titles from project roles.


"Architect" as an IT role descriptor carries an appropriate level of technical expertise and…

Read more

2 comments, 375 reads

Posted in SQL Tact on 28 September 2015

Table partitioning

What is partitioning.

To start with partition is the feature provided by SQL server in which very large tables are split between multiple files and file-groups for ease of access and faster retrieval/ update purposes.
Consider a table which consists of millions of records. When we insert all the records…

Read more

0 comments, 368 reads

Posted in Kruti's SQL Blog on 28 September 2015

SQL Saturday as an Attendee

Last week I did something that many people have already done. However this was my first experience, and I really enjoyed it. We’ll see if I get to do it again.

I went to SQL Saturday #441 – Denver as an attendee. I hadn’t submitted to speak, but I spent… Read more

0 comments, 559 reads

Posted in The Voice of the DBA on 25 September 2015

Thoughts on the 2015 PASS Election

We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim Ford – for participating, and congratulations to Jen, Ryan, and Tim for being elected. PASS surely can’t survive without volunteer leaders and it’s great to see that we continue… Read more

0 comments, 556 reads

Posted in SQLAndy on 25 September 2015

The Extended Event GUI

In the previous article in this series I shared the basics around assembling an XEvent session. The method used in that article was via TSQL script. In this article, I will introduce the Extended Events GUI. While I prefer to use TSQL to create and manage my sessions, the… Read more

2 comments, 2,090 reads

Posted in SQL RNNR on 25 September 2015

SQL Server SSIS: ReplaceNull

One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have the operator similar to ISNULL () in T-SQL. To be more exact, there was such an operator, but it works in… Read more

0 comments, 862 reads

Posted in Forrards Group Database Blog on 25 September 2015

Azure Virtual Machine Blog Series – Changing the size of a VM

I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on Azure VM/SQL Server related topics.Here is the 1st post –

“Changing the size of a VM”

When creating an Azure VM to host your SQL Server, you have an… Read more

2 comments, 2,098 reads

Posted in SQLSailor.com on 24 September 2015

I Was Once a Very Crappy Carpenter + SQL Bolts to Buzzwords

Tonight I spoke to Dr. Alkadi's CMPS 411 class, which was hijacked by the Hammond .NET User Group onsite at Southeastern University! Thanks once again to Sparkhound who sponsored!

Here's the slide deck for my presentation, which combined two topics I wanted to talk about. The first, I Was Once…

Read more

0 comments, 490 reads

Posted in SQL Tact on 24 September 2015


Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I ran across a question on Facebook, of all places, the other day. Someone had asked a friend how to return a value from a procedure and assign… Read more

3 comments, 2,461 reads

Posted in The Voice of the DBA on 24 September 2015

Assembling a Session

Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is good reason for that. The components I have discussed are essential pieces of Extended Events and are critical to building useful sessions.

Previously, I only touched lightly on the… Read more

1 comments, 415 reads

Posted in SQL RNNR on 24 September 2015

Excel as a Database Professional

People ask me all the time how to become a DBA.  This is a topic that so many colleagues of mine write about, and talk about in their professional development tracks.  The more important question is once you “are” in the role of DBA, what to do next? Read more

0 comments, 1,732 reads

Posted in Pearl Knows on 24 September 2015

Newer posts

Older posts