It seems as though the quality of much software isn't very good. What is that? Couldn't we do better? Certainly some people write much better code. Why can't the rest of us imitate them?

Validate File Properties with PowerShell Prior to Import into SQL Server

by Additional Articles

MSSQLTips.com

PowerShell

We recently faced an issue where an internal data provider began providing an incomplete or inaccurate files because it lacked the proper length (or didn't exceed a certain size). In our case, we implemented a check on the file before importing using PowerShell, here's what we did.

Byte Me: Storm Cloud

by Bob Lang

SQLServerCentral.com

Editorial

Is that a public, private, or cumulus cloud you've got there?

Stairway to SQL PowerShell Level 7: SQL Server PowerShell and the Basics of SMO

by Ben Miller (DBAduck)

SQLServerCentral.com

In this level we begin our journey into the SQL Server SMO space. SMO stands for Shared Management Objects and is a library written in .NET for use with SQL Server. The SMO library is available when you install SQL Server Management Tools or you install it separately.

The Performance of Traversing a SQL Hierarchy

by Additional Articles

SimpleTalk

Performance testing

Dwain Camps shows that, depending on the size and characteristics of some hierarchical data, six different methods of traversal can each be the fastest at some point. He illustrates the danger in generalizing from just one set of test data, and that it's foolish to assume that just because SQL code looks neat, it will perform well.

Better Training

by Steve Jones

SQLServerCentral.com

Editorial

What are better ways to train people to work in the technology field? Steve Jones has a few ideas.

Encrypt a file from SSIS using the Advanced Encryption Standard (AES)

by Stan Kulp

SQLServerCentral.com

AES-256

This article demonstrates how to create a CLR assembly that can encrypt or decrypt a file with AES-256 cryptography, how to reference the CLR assembly from an SSIS script task, and how to generate an MD5 checksum file so that its recipient can confirm the integrity of the encrypted file.

SQL Injection: How it Works and How to Thwart it

by Additional Articles

SimpleTalk

sql injection

This is an extract from the book Tribal SQL. In this article, Kevin Feasel explains SQL injection attacks, how to defend against them, and how to keep your Chief Information Security Officer from appearing on the nightly news.