Is It Possible To Conditionally Index JSON Data?

Watch this week's video on YouTube
Recently I received a great question from an attendee to one of my sessions on JSON (what's up Nam!):

At first glance it sounds like...

Version Update, Code Signing and publishing to the PowerShell Gallery with VSTS

At the fabulous PowerShell Conference EU I presented about Continuous Delivery to the PowerShell Gallery with VSTS and explained how...

Database Superhero Adventures, May 2018 Edition

Well, three SQL Saturdays down for April.  Raleigh which was local for me and I helped organize, Philadelphia where I...

Database Superhero Adventures, May 2018 Edition

Well, three SQL Saturdays down for April.  Raleigh which was local for me and I helped organize, Philadelphia where I...

Determine Referenced Objects in the Stored Procedures

It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...

PoshSSDTBuildDeploy Updated - Now With Install .NET!

Hello!
I’m currently working on a project that requires building and deploying SSDT-based projects. So it’s been a great opportunity of making use of PoshSSDTBuildDeploy and work through any issues....

SQL Server Removing Outliers With Standard Deviation

When running aggregations for reporting in some situations outliers can throw out the numbers.
For example lets say we have a...

Guide for Setting up Telegraf to Monitor InfluxDB

Problem
If you been reading this series you are used to looking at Windows and SQL Server but who knows what...

Guide for Setting up Telegraf to Monitor InfluxDB

Problem
If you been reading this series you are used to looking at Windows and SQL Server but who knows what...

Security: Create and view Audit Logs

It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...