How to check advanced options in SQL Server?

To check the available advanced options configured at instance level in SQL Server, you need to use the  sp_configure system...

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