SQL and the other technologies

I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow.   Charted data looks like in...

Write-Host || Cannot invoke this function because the current host does not implement it

Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...

A Letter To A Younger Yates

Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a...

Another 5 Power BI Tips

If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about...

Disabling #sqlprompt Formatting

I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want...

Hiring Productive Employees – #TAPtips

Starting a business is easy. Have an idea, some skills, a customer or two, and you are in business. However,...

How to Count the Total Number of Rows Across Multiple Tables

I have been working on SQL Server Consulting assignment,  a SQL Server 2014 migration for a new client over the...

Join webinar on SQL Server 2016 Always on

Click [HERE} to Join webinar.
SQL Server 2016 - AlwaysOn
An availability group supports a failover environment for a discrete set of user databases, known...

JSON Support Is The Best New Developer Feature in SQL 2016 — Part 2: Creating JSON

This is the second article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON.

Part...

My First SQL Saturday – As A Speaker!

I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.
I...