Up Next, SQL PowerShell for SSAS!

I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...

Up Next, SQL PowerShell for SSAS!

I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...

Aggregate Functions

Aggregate Functions
MINReturns the smallest value in a given columnMAXReturns the largest value in a given columnSUMReturns the sum of the...

My Interview at SQL Server Geeks 2016

One of the biggest highlights of this year for me was speaking at SQL Server Geeks Annual Summit 2016. In...

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

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

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

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

NOLOCK

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