Articles

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. SQL Prompt is committed to cover as many as possible of them. Phil has also updated his book, which is free to download.

2018-05-03

5,999 reads

Preventing Invalid Data Early In An ETL Flow

by Additional Articles

MSSQLTips.com

ETL (Extract Transform and Load)

In this post, Tim Smith will look at some of the considerations for both data rules and logic to prevent invalid data early in the ETRL process.

2018-05-02

3,324 reads

Random Word Generation for Data Scrubbing

by John F. Tamburo

SQLServerCentral.com

RAND()

With HIPAA and GDPR requiring your careful scrubbing of data for lower environments, random word generation promises to be a huge helper. Read here how to do it.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(17)

You rated this post out of 5. Change rating

2018-05-01

5,921 reads

Discuss

Introduction to Azure SQL Managed Instance

by Additional Articles

SQLServerCentral

Azure SQL Managed Instance

Microsoft currently offers two built-in methods of running production SQL Server databases in Azure. The first relies on the ability of Infrastructure-as-a-Service (IaaS) Azure virtual machines to host a variety of on-premises workloads, including SQL Server instances. The second one leverages Platform-as-a-Service (PaaS)-based Azure SQL Database. With the introduction of the Azure SQL Managed Instance service, you have a third option, which combines the benefits of its two predecessors.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2018-05-01

3,285 reads

Self SQL Injection

by Alessandro Mortola

SQLServerCentral.com

Dynamic SQL

Based on a real fact, this article demonstrates how a bad use of sp_executesql can lead to unpleasant surprises

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(23)

You rated this post out of 5. Change rating

2018-04-30

1,833 reads

Discuss

Execution Plans and Data Protection

by Additional Articles

SimpleTalk

Execution Plans

One of the most important tools for query tuning is ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection.

2018-04-30

3,411 reads

PowerShell To Get Active Directory Users And Groups into SQL

by Lowell Izaguirre

SQLServerCentral.com

PowerShell

Use Powershell to query AD for Users, Groups and GroupMembers

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(25)

You rated this post out of 5. Change rating

2018-04-27 (first published: 2016-03-31)

30,920 reads

Discuss

SQL Server Closure Tables

by Additional Articles

SimpleTalk

T-SQL

SQL Server has a couple of different ways to represent hierarchies, but they do not allow storing any additional information that is important to the relationship between objects. In this article, Phil Factor explains how to use closure tables to overcome this deficiency.

2018-04-27

3,926 reads

SQL Server From .Net: Building a DataSet with Code

by Tim Wellman

SQLServerCentral.com

ADO.NET

A basic introduction for developers about working with the DataSet object in ADO.Net to represent objects in a SQL Server database, and some of the options available.