Additional Articles

Getting Started with SQL Server 2012 Express LocalDB

by Additional Articles

MSSQLTips.com

SQL Server 2012

Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task.

2017-07-28

5,168 reads

Statistics in SQL: The Kruskal–Wallis Test

by Additional Articles

SimpleTalk

T-SQL

Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis test is a safe way of determining whether samples come from the same population, because it is simple and doesn't rely on a normal distribution in the population. This allows you a measure of confidence that your results are 'significant'. Phil Factor explains how to do it.

2017-07-27

6,123 reads

How to Read the Transaction Log File

by Additional Articles

SQLServerCentral

Transaction Log

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-07-26

5,228 reads

The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects

by Additional Articles

SimpleTalk

T-SQL

Technical debt is a real problem in database development, where corners have been cut in the rush to keep to dates. The result may work but the problems are in the details: such things as inconsistent naming of objects, or of defining columns; sloppy use of data types, archaic syntax or obsolete system functions. With databases, technical debt is even harder to pay back. Robert Sheldon explains how and why you can get it right first time instead.

2017-07-25

5,860 reads

Testing DML Statements for In-Memory OLTP

by Additional Articles

SQLServerCentral

Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-07-24

4,663 reads

SQL Server User-Defined Functions

by Additional Articles

SimpleTalk

T-SQL

User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can even use scalar UDFs in WHERE clauses, computed columns and check constraints doesn't mean that you should. Multi-statement UDFs come at a cost and it is good to understand all the restrictions and potential drawbacks. Phil Factor gives an overview of User-defined functions: their virtues, vices and their syntax.

2017-07-21

5,686 reads

Find Database Connection Leaks in Your Application

by Additional Articles

SQLServerCentral

Connection

Michael Swart shows how to investigate and fix database connection leaks, an application issue that can lead to connection timeouts.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-07-20

4,604 reads

7 Things Every SQL Server DBA Should Know About Linux

by Additional Articles

MSSQLTips.com

Linux

In this tip John Grover will help you make the transition to SQL Server on Linux by explaining the things you need to know.

2017-07-19

4,274 reads

Simple SQL: Attribute Splitting

by Additional Articles

SimpleTalk

T-SQL

If the design of a relational database is wrong, no amount of clever DML SQL will make it work well. Dr. Codd’s Information Principle is that you have, inside the entity tables, the columns that model the attributes of that entity. The columns contain scalar values. Tables that model relationships can have attributes, but they must have references to entities in the schema. You split those attributes at your peril. Joe Celko explains the basics.

2017-07-18

3,822 reads