How Can I Get Accepted to Speak at the PASS Summit?

There has been some discussion and concern over the changes to the speaker selection process for the PASS Summit. I’ve...

Microsoft Build event announcements

Another Microsoft event and another bunch of exciting announcements.  At the Microsoft Build event this week, the major announcements in...

Quick Graph Database

There’s a sample to work through here: https://docs.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-sample
I decided to try this in CTP2 and just see how it works....

Simple Security Report

Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over...

Speaking at Charleston PASS on May 18, 2017

During the day of the 18th I’ll be at the Syntax Code and Craft Conference in Charleston, SC. That evening...

Azure Data Factory and the Case of the Missing JRE That Wasn’t

On a recent project I used Azure Data Factory (ADF) to retrieve data from an on premises SQL Server 2014...

Creating an Azure SQL Database via PowerShell

This post is about using the brilliance of PowerShell to script the creation of databases in Azure.

Background:
Apart from the obvious question...

DevOps Basics–Creating a local repo and committing files

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

Dynamic SQL and the joys of QUOTENAME

I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...

Find the number of rows for a value, without querying the table

Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6

Lets, say the table contains...