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

Latest Blog Posts

How to Encrypt password in SQL Server ? TIP #87

Security is always a concern for every database developer. How to secure valuable information is one of the major and important aspect.

The first approach toward security to have a strong username & password and the next step is to have password in encrypted form.

Now this article will help… Read more

0 comments, 68 reads

Posted in Rajat Jaiswal-337252 on 24 February 2015

Presentation slides for “Building a Big Data Solution”

Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop, Cloud and MPP) for Pragmatic Works today.  The abstract for my session is below and the recording will be available here tomorrow.  I hope you enjoyed it!

Here is the… Read more

0 comments, 181 reads

Posted in James Serra's Blog on 24 February 2015

Troubleshooting full-day workshop in Richmond (March) and Configuration full-day workshop in Huntington Beach (April)

Want to learn more about SQL Server? Now’s a good time to get a full day of inexpensive high-quality training on both the east and west coast, in March and April, respectively.

I hope you’ll join me for a full-day troubleshooting and performance tuning workshop on the Friday preceding the… Read more

2 comments, 82 reads

Posted in Kevin E. Kline on 24 February 2015

Check Out Josh’s Blog on Creating Percentile in DAX

I would like to introduce a “new” blogger to you. Joshuha Owen has restarted his blog and will be covering topics on business intelligence and data. I have worked with Josh for years at a Magenic and now Pragmatic Works. I look forward to seeing what he will be writing… Read more

0 comments, 105 reads

Posted in DataOnWheels on 24 February 2015

T-SQL :- How to Search String in all Stored Procedures across All User Defined Databases

There are many different ways to accomplish this tasks.

Download Link

The below examples uses undocumented sp’s to loop through all the user defined database to search the SP’s using given string

CREATE TABLE  #ProcSearch  (databaseName VARCHAR(100),ROUTINE_CATALOG varchar(50),ProcName VARCHAR(128),RoutineType varchar(100),CreateDate date)

DECLARE @command varchar(1000) 
SELECT @command = 'IF ''?''…

Read more

0 comments, 2,184 reads

Posted in PowerSQL By Prashanth Jayaram on 24 February 2015

DevOps, the DBA, and the word “No”

Check out this DevOps Reactions animated GIF and caption.

It’s funny on multiple levels, but it also makes me both mad and disappointed.

I get mad because it’s 2015. Surely by now most of us, especially those who have worked in the enterprise with development teams, know that the old… Read more

10 comments, 1,941 reads

Posted in The Scary DBA on 24 February 2015

SQL Cruise Caribbean 2015 Recap

UPDATED: Don't just take my word. Read the feedback from others.

I wish I could just re-post…

Read more

0 comments, 84 reads

Posted in Everyday SQL on 24 February 2015

Identifying Blocking via Extended Events

There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can run the undocumented sp_who2 stored procedure but that will only give you the session that is being blocked. You could download the excellent sp_whoisactive, written by Adam Machanic, which… Read more

4 comments, 2,056 reads

Posted in The DBA Who Came In From The Cold on 24 February 2015

Speaking at SQLBits and SQLRally

Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun.


On Wednesday, March 4, at 4:45PM, I’ll deliver my session “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen.

The session talks about a big… Read more

0 comments, 90 reads

Posted in Matan Yungman on 24 February 2015

Preparing a Technical Session Part 3: Writing an Abstract

So you’ve come up with a great idea for a session and now you have to translate that idea into a thorough abstract that helps both organizers and attendees understand what to expect from your session. This can make the difference between you getting a session at your favorite conference… Read more

0 comments, 1,819 reads

Posted in Devin Knight on 24 February 2015

How easy to determine table dependencies ? TIP # 86


Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which  SQL Server provides.

By using this stored procedure we can easily determine all the dependencies of particular table.

The stored procedure is sp_msdependencies

We can use this stored procedure… Read more

0 comments, 23 reads

Posted in Rajat Jaiswal-337252 on 24 February 2015

Missing Full Text Extensions in Express

I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were causing a few extra items to appear in a SQL Compare demo and weren’t needed. The individual that had set up the VM I was using wasn’t sure what to… Read more

0 comments, 133 reads

Posted in The Voice of the DBA on 23 February 2015

ICYMI: Sequences, CPUs, and Trimming T-Logs – SQL Server Performance Topics

Have you read any of the great articles on The deep-dive technical info about SQL Server performance issues authored by the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013:


Generate a set or sequence without… Read more

2 comments, 122 reads

Posted in Kevin E. Kline on 23 February 2015

Book Review: Virtualizing SQL Server with VMware

It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to buy or not to buy a book, but don’t contain a lot of the “why” or “why not” to do so. But, every once in a while a book comes… Read more

0 comments, 155 reads

Posted in Technobabble by Klee from @kleegeek on 23 February 2015

Exam Prep 70-463: Variables and Parameters

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

0 comments, 168 reads

Posted in Cleveland DBA on 23 February 2015

Join me for Dashboards in a Day

Seats are limited – act fast!

This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA on Wednesday, February 25th and Friday, February 27th. Join me to learn how to use Microsoft’s self-service Business Intelligence platform, Power BI.

In the first part of… Read more

0 comments, 167 reads

Posted in SQLDownSouth on 23 February 2015

Tales of a DBA fed up with NOLOCK. Part 2

Feb 16, 2015
Dear Diary,
A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were not just putting NOLOCK on almost every query but they had SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED at the beginning of the stored procedures. HAL’s done his job… Read more

6 comments, 3,488 reads

Posted in SQLStudies on 23 February 2015



Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same result set.  EXCEPT returns the records from the query on the left that are not found in the right query.  INTERSECT returns the distinct rows that are in… Read more

2 comments, 4,041 reads

Posted in Business Intelligence and Enterprise Architecture on 23 February 2015

“sp_helptext“ – Useful command to view detail TIP #85


It might be already known to you but I thought for sharing because I frequently use this command and it is very useful command.

When someone wants to determine detail of a function or stored procedure he/she can use this useful command.

The syntax is very simple. Just write… Read more

0 comments, 11 reads

Posted in Rajat Jaiswal-337252 on 22 February 2015

SQL Saturday NYC Update #4

SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th.  Before I announce what they are I wanted to first say thank you to everyone who submitted it certainly made making a choice very difficult.


Precon #1:  Bradley Ball will… Read more

0 comments, 256 reads

Posted in Another SQL Geek on 21 February 2015

Newer posts

Older posts