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

Latest Blog Posts

Author of the Year at

I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at the website!
I am humbled by the recognition of my fellow peers in the SQL Server community and I’d like to thank all of you, the #sqlfamily, for voting. Read more

2 comments, 78 reads

Posted in Koen Verbeeck on 13 January 2015

T-SQL Tuesday #62 - Achieving Healthy SQL with MDW

Today: Tuesday, January 13, 2015 is the 62nd entry and first T-SQL Tuesday of the year 2015, and I am honored to be this month’s host to kick of the New Year!  Last week, I made the announcement, and invited everyone to the blog party started many quantum… Read more

6 comments, 6,121 reads

Posted in Pearl Knows on 13 January 2015

T-SQL – How to find Next Business day from a given date

There are many methods to find next business day. One common way is to use of calendar table.  This post is to get an output using T-SQL Or UDF function.

Download T-SQL  NextBusinessDay

The details are given below

The script can be executed by feeding Input values to SQL. In… Read more

1 comments, 6,065 reads

Posted in PowerSQL By Prashanth Jayaram on 12 January 2015

She Taught Me to Code–A Tribute to Sheila, My Wife

A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals who have impacted my career. I do this as a tribute to my father-in-law, Ed Jankowski who passed away five years ago this past December (2014). Check out my original… Read more

1 comments, 88 reads

Posted in DataOnWheels on 12 January 2015

It’s a Problem When a SysAdmin Can’t Log In

I showcased a demo recently that looked at a potential issue with an application where a user used a simple update statement to gain privileged access to a system. That’s scary, and it’s a potential issue for many applications that handle their own authentication.

The problem with this type of… Read more

0 comments, 5,254 reads

Posted in The Voice of the DBA on 12 January 2015

SQL Cruise Caribbean Is Coming Soon

Want to get out of the winter blues and into some warmer weather for some deep SQL Server training? Join me on the next SQL Cruise to the Caribbean this February! This is my first SQL Cruise, and I’m really excited to go. This trip sets sail to three different… Read more

0 comments, 199 reads

Posted in Technobabble by Klee from @kleegeek on 12 January 2015

Impact Players – SQL Style

Awhile back I did a post on my Fab Five – was one of my favorite ones I’ve done to date because it dealt with individuals who have made a tremendous impact in my professional career in some form or fashion. I am not ashamed to admit I am a… Read more

1 comments, 82 reads

Posted in The SQL Professor on 12 January 2015

Configure Search Topology in ScaleOut Mode in SharePoint 2013 || Configure Search Service in SharePoint 2013

Hello Friends,

With a New Year and my earlier commitments. Below is the way to configure Search Service 2013 in Scale out mode.

Search Service configuration 2013 in Standalone mode can be viewed at: “How to Configure Search in SharePoint 2013”

 As described earlier, Microsoft is focusing more and more…

Read more

0 comments, 257 reads

Posted in AshishSharePointBlog on 12 January 2015

I’m a SQL Server MVP!

I have been working with SQL Server for the past 17 years, and in the past few years I have been also very involved in the SQL Server community in Israel and around the world. I love SQL Server, and I also love the community around SQL Server, which is… Read more

0 comments, 86 reads

Posted in Guy Glantser on 12 January 2015

Discussing Security with Boris Hristov on SQLHangout #29

Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I ever wrote was security related. A brief explanation and solution for the Double Hop problem on SQL Server Central. Well continuing that theme I had an all to brief, but… Read more

0 comments, 113 reads

Posted in SQLStudies on 12 January 2015

DBTA – PowerBI: The Self-Service BI App That Can Change Your Life

Here’s a real-world story: Data collection and analysis is, ironically, for a data management profession, one of the toughest parts of my job. I regularly pull data from our various databases and packaged application reporting systems for CRM, licensing, and user information.

If you’ve ever worked with a packaged product,… Read more

1 comments, 110 reads

Posted in Kevin E. Kline on 12 January 2015

David Postlethwaite - Exciting news.

By David Postlethwaite

I have been chosen to speak at SQL Saturday in Vienna, Austria  on 28th February.
The organisers have just moved the event to a larger venue to cope with the expected demand.

My talk is entitled Putting Your head in the Cloud– A Beginner’s Guide to SQL…

Read more

0 comments, 80 reads

Posted in The SQL DBA in the UK on 12 January 2015

T-SQL Random Numbers using RAND() for Test Data

T-SQL Random Numbers using RAND()

SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1 of float datatype.  To create a random number execute Select Rand(), in my example it returned .0131039082850364.  If I wanted to always return the same number I can… Read more

1 comments, 112 reads

Posted in Business Intelligence and Enterprise Architecture on 12 January 2015

2014 Year In Review

As is our want, we must look back over the past year to see what happened. While I normally focus on work related items, this year was a crazy year for our family as well as my career. So let’s have a look at what happened this year.

Traveling Family

Read more

0 comments, 64 reads

Posted in DataOnWheels on 11 January 2015

A Whole New Mind by Daniel Pink

I have dedicated much more time to reading in the past 6 weeks (Since the beginning of December 2014), and as a result I have finished one more book – “A Whole New Mind“, written by Daniel H Pink. This…

Read more

0 comments, 137 reads

Posted in Niko's blog on 11 January 2015

In-Memory OLTP Part 2 : Memory-Optimized tables

In part 1 of the In-memory OLTP articles we gave you an introduction into In-memory OLTP, showing what the requirements are, the limitations and a quick look at the Advisors.

In this article we are going to dive a little deeper into a large portion of In-memory OLTP: Memory-Optimized (or… Read more

0 comments, 174 reads

Posted in DotNine SQL Server and more on 11 January 2015

An Overview of the SQL Server System Databases

The endowment of Microsoft’s extensive data storage platform, SQL server carries out breakthrough efficiency in storing and maintenance of data. It is a highly featured database that is primarily designed to cope with the business environment. The SQL server supports ANSI-SQL and T-SQL query languages. The query languages are used…

Read more

0 comments, 405 reads

Posted in Zora's SQL Tips on 10 January 2015

SQL Saturday NYC Update #3

SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2 of them are on Friday May 29th and we have had many submissions so far.  We are taking submissions until 1/15/2015 so just under a week left to email them… Read more

0 comments, 5 reads

Posted in Another SQL Geek on 9 January 2015

Learning SQL #1–Start from buying a Copy of SQL Server Developer Edition

If learning SQL is in your New Year Resolution, then you will be happy to read this post.

We all make resolutions that we fail to keep. What I am suggesting here will give that failure minimum chance.

Here is what I am suggesting:

  • Get a copy of the SQL…

Read more

1 comments, 188 reads

Posted in Sherry Li's BI Corner on 9 January 2015

SQL – Split delimited columns using XML Or UDF function

The requirement is to convert the delimited column into rows

Input data and required output details are given below

Eno Ename Esloc EDept
1 ABC NJ 10,20,30,40,50


Eno Ename Esloc EDept
1 ABC NJ 10
1 ABC NJ 20
1 ABC NJ 30
1 ABC NJ 40

Read more

0 comments, 107 reads

Posted in PowerSQL By Prashanth Jayaram on 9 January 2015

Newer posts

Older posts