Improve performance by replacing temp tables with memory optimized tables - Part 1

There are many cases where you will be using temp tables, and many of us are trying to seek for...

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

My backup and SLEEP_BPOOL_FLUSH

I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...

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

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

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

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

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

Pesky Percent File Growth

As DBAs we all know setting your file growth to grow by percent is not optimal.  It can cause all...

Hiring Productive Employees – #TAPtips

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