SQL Server Dedicated Admin Connection and Why You NEED It!

DAC or Dedicated Admin Connection is one of those things you don’t know you need until it’s too late.

What is...

Thoughts and Lessons Learned From A Power BI Embedded POC

I worked on a Power BI embedded POC where a report with an in-memory Power BI model as the dataset...

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 same way that SQL Server. No surprise - 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...

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 testing and ETL processes

Unit testing using tSQLt is really great, you call FakeTable on any tables your code touches and then insert the columns and rows your test actually need, nothing more,...

Day 1: MySQL History

Swedish Company: MySQL AB by – Michael Widenius (Monty), David Axmark and Allan Larsson Name Combination: Michael’s Daughter name –“My” and...

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,...

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...

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...