BIML is better even for simple packages

BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a...

Free Your Mind. Release Your Inner Developer

I have always liked the drawings done by MC Escher.  Looking at his drawings has always forced me to look...

PASS Elections and Verifying Account

It is that time of the year when PASS starts a process to help update memberships and clean up duplicate...

PSA: Update Your PASS Profile

I got my annual two emails from the PASS organization with the notification to update my profile to vote. I’m...

Putting Your Head in the Clouds 2 –Advantages and Disadvantages of Cloud Solutions

By David Postlethwaite

If you are thinking about using Cloud Computing then it’s worth considering the pros and cons.
Advantages of...

Using PowerShell to Export SQL Data to CSV. How well does it perform?

So here we are at week 4 of the #SQLNewBlogger challenge. Earlier in the week I responded to the following...

Video: Bringing Together Databases, Virtualization and Storage

Bala Narasimhan, Vice President of Products from PernixData, and I recently sat down and discussed the convergence of infrastructure, SQL Server,...

Azure SQL Data Warehouse

Analytics Platform System (APS) is Microsoft’s massively parallel processing (MPP) data warehouse technology.  This has only been available as an on-prem...

Backup your SQL Server jobs using PowerShell script

This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent of an instance. It’s an useful job that you...

Backup your SQL Server jobs using PowerShell script

This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent...