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...

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...

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...

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...

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...

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...

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...

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...

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...

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...