Downloading multiple files from internet with SSIS and C#

This is a tutorial to download multiple files from internet using the SSIS Script Task.

Testing Coders

It seems that everyone has a different idea on how to interview people. Today Steve Jones looks at the technique of having someone improve some code in real time.

Can comments hamper stored procedure performance?

After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.

Byte Me: Meltdown

Cloning a SQL Server Login with all permissions using PowerShell

Cloning a SQL Server login with permissions that match another login is a common task. In this post, Jeffrey Yao shows how this an be done using PowerShell.

SQLBits 2017

SQLBits 2017 has been announced. The conference will take place on April 5-8, 2017 in Telford, UK.

Non-Numeric Measures in DAX

Enhance the functionality of your SSAS Tabular and PowerBI output, by understanding HOW-, WHY- and WHEN to leverage the power of DAX to create text, date or Boolean measures.

What do you do when you inherit a mess at work?

I have seen three common responses to database messes. My favorite is nuclear.

Azure SQL Database - Authenticating Application Access by Using Azure AD Tokens

Learn how to leverage Azure Active Directory when connecting to Azure SQL Database from applications or services in a non-interactive manner, by relying on token-based authentication.

Maintenance Routines for AlwaysOn

How to determine what replica(s) to perform maintenance routines