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

Latest Blog Posts

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, 315 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

1 comments, 268 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, 592 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,222 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

1 comments, 1,510 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, 97 reads

Posted in SQL Tact 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, 233 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

3 comments, 161 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, 1,296 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, 411 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

0 comments, 300 reads

Posted in 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, 134 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

1 comments, 1,493 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, 142 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, 502 reads

Posted in Pearl Knows on 24 September 2015

SQL Server Enterprise Edition Advanced Scanning

It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in comparison with Standard Edition. One of these improvements is Advanced Scanning, which allows multiple scans to share one physical read from… Read more

0 comments, 161 reads

Posted in Forrards Group Database Blog on 24 September 2015

Database Mirroring Isn’t Going Anywhere

AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in many cases, the good old Database Mirroring is just good enough (and in some cases, better):

Database Mirroring can work in Standard Edition

Database Mirroring is supported in both… Read more

5 comments, 605 reads

Posted in Matan Yungman on 24 September 2015

Dynamic SQL & Quotename

Not quite fineprint, but sure feels like it!

Quotename can be a pretty cool function to simplify your dynamic sql, as it can ease some of the escaping of strings.

However, I normally use it for table/column names, and so hadn’t ran into a “gotcha” of this function until today. Read more

0 comments, 119 reads

Posted in SQL Barbarian on 23 September 2015

Deployment Contributor KeepTableColumns Filter

To help with this scenario (it is pretty specific):

You have a table that has columns that you do not know about when you create the dacpac, possibly you have a customer who modifies your schema after you deploy. If you deploy your dacpac those columns will be dropped which…

Read more

0 comments, 223 reads

Posted in Ed Elliott's Sql Developer Blog on 23 September 2015

Freecon – Oct 27 in Seattle

Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training, FREECON if you will, in Seattle as a prelude to the PASS Summit of 2015. You can read all about that here, with registration being here.

While I… Read more

0 comments, 195 reads

Posted in SQL RNNR on 23 September 2015

Newer posts

Older posts