Linux – How to generate and configure SSH Key authentication to connect to a remote system

Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today...

Interviewed on Channel 9

Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy.
https://channel9.msdn.com/Blogs/vsppstories/Including-the-database-in-your-DevOps-pipeline/player

Filed under: Blog Tagged: DevOps,...

Easily Move Databases with Copy-SqlDatabase

One of the things that people have asked to be implemented for many years is an easy way to copy...

Why won’t my SP work THIS time?

Why won't my SP work? I did this exact thing. You're never too old to do something like this.
The post...

Hide and Group Columns in SSRS Using a Parameter

Ever had users come to you and request another version of a report just to add another field and group...

In Memory OLTP – 2

Good day everyone , In last post

In Memory OLTP – 1
we saw the what is In Memory OLTP and what are the...

Friday Reading 2016-12-09

One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to...

NOLOCK

NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and...

What keeps clearing my query stats?

I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface...

What Port Should I Use?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...