Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions

Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...

Dates and Times in SQL Server: What about TIMESTAMP?

It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP...

Azure SQL Data Warehouse Gen2 announced

Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse.  With this performance optimized tier, Microsoft...

Azure SQL Data Warehouse Gen2 announced

Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse.  With this performance optimized tier, Microsoft...

Power BI Custom Visuals Class (Module 101 – Tachometer)

In this module you will learn how to use the Tachometer. The Tachometer for communicating performance against a goal.

Module 101...

Connect to Power BI Report Server with SSMS

Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security...

SQL Homework – May 2018 – Create a database

I’ve really got to make a plan here at some point. So far I’ve been just putting down things as...

5 Ways to Examine Cardinality Metrics

In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...

Getting my Twitter Data via Azure Logic Apps

As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people...

Using CAST() function with User-Defined Data Types…Did you know…

I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the...