Hardware Wrestling

A few weeks back I had some issues. They were related to this:

My standing desk was down and as you...

Time Zones are a Drag … Seriously

Time Zones were definitely being a drag today. I got an email from one of the developers at work asking...

SSIS Issues : A Day of Learning

Seldom are the days when you run into complex issues but resolve them in the shortest interval of time.

Thanks to...

Azure data centers and Regions: How to pick a best azure region.

Azure data centers and Regions:

Azure data centers are located worldwide and a team/division MCIO (Microsoft Cloud Infrastructure and Operations) manages all the data centers...

Thankful

It’s been a long career for me. In fact, I’ve been a SQL Server data professional for 17 years, just...

Azure SQL Database – Service Tiers

Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from...

SQL SERVER ON LINUX INSTALLATION – PART3 – INSTALL SQL SERVER COMMAND-LINE TOOLS ON RHEL

As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it...

Biml for a Task Factory Dynamics CRM Source Component

I recently worked on a project where a client wanted to use Biml to create SSIS packages to stage data...

Finding #dbatools #PowerShell commands

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...

MySQL has this feature that SQL Server needs

In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because...