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

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

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