Steve has a good reason to use a version control system. It's a different kind of backup that you might need.

Soft Skills: Controlling your career

by David Poole

SQLServerCentral

Career

Technical skills come and go while soft skills will serve you throughout your life. They will have the greatest influence over your career, job and role. For some people soft skills come naturally. As an Aspergers person (Aspie) I have to practice my soft skills at every opportunity. Pure techies need not lose hope. Soft […]

How to Stop a SSIS Package Execution from Code

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.

Beware, More Ransomware is Coming

by Steve Jones

SQLServerCentral

Security

Ransomware has become a large problem in the last few years, and Steve thinks this will continue to increase because of insurance payouts.

Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

by Solomon Rutzky

SQLServerCentral.com

In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We then build an assembly, store procedure, and a function that can be called from your T-SQL code.

Backup Techniques Available Exclusively When Using Azure VMs

by Additional Articles

Database Journal

Backup

Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.

Free eBook: Understanding SQL Server Concurrency

by Press Release

Redgate

Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.

“Included columns” for non-clustered indexes explained

by Michael Salzmann

SQLServerCentral

Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]