Monday Coffee: Follow the instructions

Last week I was working on an upgrade and ran into a few issues. Whilst waiting for the company’s support...

Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI

Dear All,

Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses...

Getting back to blogging

The past two months have been very hectic for me. I had an unexpected job offer towards end of July,...

What I Learned Today - Configuring tempdb in RDS

Today I learned that you can configure tempdb in RDS!
One of the things we DBA’s do is configure tempdb to...

Columnstore Indexes – part 110 (“The best column for sorting Columnstore Index on”)

Continuation from the previous 109 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In this blog post I wanted to...

Azure support MySQL & PostgreSQL

After SQL Server support on Linux Microsoft is not have another great enhancement where now Azure supports MySQL and PostgreSQL...

SQL Server 2005 – Failed Maintenance Job

I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those...

SQL Server Replication snapshot initialization taking long time to be applied

Hello all,In today's post I want to share a tip that helped me troubleshoot an issue I was facing and couldn't find much documentation about it. To my friends...

Responsible Log Growth with dbatools

I love dbatools, and I’ve been trying to explore the various cmdlets over time, both to practice my PoSh and...

SQL Server Replication snapshot initialization taking long time to be applied

Hello all,
In today's post I want to share a tip that helped me troubleshoot an issue I was facing and...