New Built-in Function CONCAT_WS() – SQL Server 2017

In my previous post on new functions in SQL Server 2017, I discussed about the STRING_AGG function. Here, I am...

A Swiss Army Knife Might Not Make the Best Shovel

You might have noticed that I’ve been pretty quiet as of late. We’re working on a super top secret internal...

Speaking at the 2018 Techno Security and Digital Forensics Conference

One of my favorite conferences is held in Myrtle Beach, SC, in June. It’s a security and digital forensics conference which...

An overview of SQL Server backup-and-restore process

In a manner of speaking, planning and implementing a SQL Server backup design is an art. Backup, Restoration, Recovery, Business...

Database Superhero Adventures, March 2018 Edition

I had two SQL Saturdays this month SQLSaturday Cleveland (which was very cold) and SQLSaturday Tampa (which had very nice...

Azure SQL Database – Allow Azure Services to Access Server

When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there...

What do recruitment agents do for contractors?

WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships

Are you...

Information Measurement with SQL Server, Part 3: Inverse Probability and Bayes Factors

By Steve Bolton
…………In the last segment of this series of amateur self-tutorials, we discussed how to code various ways of...

Power BI Custom Visuals Class (Module 92 – KPI Ticker MAQ Software)

In this module you will learn how to use the KPI Indicator Custom Visual by MAQ Software. The KPI Ticker...

Offline installation of SQL Server 2017 on Linux

SQL Server is now compatible with different Linux distributions, and there is a lot of excitement about it.
How ever one of the main questions when ever you say SQL...