Monday Coffee 2016-12-12

Speaking and presenting
One of my biggest fears is public speaking and judging by this article, I’m not alone.
However it’s something...

Database synchronization in the Software Development Life Cycle

Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development Life Cycle (SDLC)? Stick around, because I'll get to...

Database synchronization in the Software Development Life Cycle

Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...

How to use DTA (Database Tuning Advisor) with Plan Cache option?

SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File...

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

Aggregate Functions

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

Analysis Services and Power BI: Time-travel, Space-warping and Teleportation

As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. ...

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