Practical Web Scraping–More Reading

As part of my learning goals for 2018, I wanted to work through various books. This is part of  my...

Restoring a Database from Azure

In a previous post, I described how you can use Azure storage to store SQL Server database backup files.  This...

Published in the ISACA Journal!

In my effort to write more regularly, I’ve branched out a bit to write in the audit and compliance space....

Data story behind a Global Fishing Power BI report

(2019-Mar-01) The first time I heard about the Data For A Cause initiatives was at one of the Power BI meetups in Toronto....

It’s always parameter sniffing: Line Endings

Combining a few themes of recent posts today. I’ll mix in some sp_executesql, it’s always parameter sniffing, and the plan...

What Data Is Being Sent Externally By Power BI Visuals?

As you build your Power BI reports, you may want to use maps and custom visuals. Have you thought about...

Why i choose to use memory optimized table in MS SQL Server in some circumstances

MSSQL SERVERI was supporting an application which will be making a lot of concurrent calls to the database. The application which will be widely used and it will be...

Why i choose to use memory optimized table in MS SQL Server in some circumstances

MSSQL SERVERI was supporting an application which will be making a lot of concurrent calls to the database. The application which will be widely used and it will be...

Proposed SQL Server defaults: disable priority boost

A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...

Dem queries

Dem queries, dem queries, dem slow queries,

Dem queries, dem queries, dem fast queries,

Dem queries, dem queries, dem big queries,

Now write...