Implicit Conversion and Performance

Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run...

Weekly Round-up 30 April 2016

It’s been an interesting week for me. I spent last week in Toronto delivering a SQL Server upgrade course and...

SQL Server – Row Level security in SQL Server 2016 – Part 1

Hi friends, in SQL 2016 several new security features gets introduced which will help users to protect their data in...

Goodness-of-Fit Testing with SQL Server Part 7.3: The Anderson-Darling Test

By Steve Bolton
…………As mentioned in previous installments of this series of amateur self-tutorials, goodness-of-fit tests can be differentiated in many...

Monday Morning SQL Break – May 2, 2016

Gotta love Mondays.  At least the weather here in Minnesota is clearing up, the last two weeks have been cold...

SQL Server 2016 available June 1st!

Woo hoo!  Microsoft has announced that SQL Server 2016 will be generally available on June 1st.  On that date all four...

PowerSehll : How to suppress the table heading and remove the blank space from a text file

There are a multiple ways to suppress and remove the first line from text file. The first scenario would be writing...

How to Convince the Boss to Send You to PASS Summit

August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL...

Remove files from a filegroup

You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve...

SQL 2016 - The Time Has Come!

Microsoft dropped it on us this morning:

Get ready, SQL Server 2016 coming on June 1st
https://media.makeameme.org/created/yes-finally.jpg

I read the article and was...