Additional Articles

Microsoft Azure DocumentDB

by Additional Articles

SimpleTalk

Azure

Microsoft's DocumentDB is a late-entrant in the Document-oriented database field. However, it benefits from being designed from the start as a cloud service with a SQL-like language. It is intended for mobile and web applications. Its JSON document-notation is compatible with the integrated JavaScript language that drives its multi-document transaction processing via stored procedures, triggers and UDFs. Robert Sheldon investigates its SQL-like query language.

2016-01-21

3,691 reads

Network Load Testing Using iPerf

by Additional Articles

SQLPerformance.com

Network Load Testing

Tim Radney of SQLskills shows how to measure your network so you have more ammo to take to your network team when there is a performance issue.

2016-01-20

3,314 reads

Getting Started with Stretch Database Functionality in SQL Server 2016 - Part 2

by Additional Articles

Database Journal

Stretch Database

Arshad Ali explains and demonstrates the impact of enabling the Stretch database feature on backup and restore operations. He also discusses ways to pause, resume, and disable this feature altogether when not needed.

2016-01-19

4,779 reads

Documenting Your PowerShell Binary Cmdlets

by Additional Articles

SimpleTalk

PowerShell

Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as to provide comprehensive help at the command-line or IDE, the same isn't true of binary cmdlets written in C#. At last, there is an open-source utility to assist with this that is being actively maintained and updated. At last, binary cmdlets need no longer be the poor cousins of scripted cmdlets in their documentation

2016-01-18

3,322 reads

Wherever I Lay My Hat: Release Management in TeamCity with Redgate DLM

by Additional Articles

SimpleTalk

Release Management

Where you have multiple services, applications and databases in your environment, and perhaps with high levels of scrutiny and governance, you'll probably want a Release Management system for deploying database and application code together: You can, alternatively, use a separate Release Management component. But for simpler applications, you can use your existing build system such as TeamCity to deploy changes. Using a database deployment example, Richard Macaskill shows how.

2016-01-15

3,536 reads

SQL Server 2016 : Availability Group Enhancements

by Additional Articles

SQLPerformance.com

Availability Group (AG)

Aaron Bertrand reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.

2016-01-14

6,823 reads

Comparison of SQL Server Serializable and Snapshot isolation levels

by Additional Articles

MSSQLTips.com

Isolation Levels

Both Serializable and Snapshot isolation levels exclude concurrency issues such as Dirty Reads, Non-repeatable Reads and Phantoms. However the way in which they deal with such issues is quite different. In this article, Sergey Gigoyan explains the main differences between the two.

2016-01-13

3,453 reads

Declarative SQL: Using References

by Additional Articles

SimpleTalk

Declarative Referential Integrity (DRI)

There are several ingenious ways of using SQL References to enforce integrity declaratively. Declarative Referential Integrity (DRI) is more effective than using procedural code in triggers, procedures or application layers because it uses the SQL paradigm, thereby making optimisation easier and providing clearer expression of the rules underlying the data. Joe Celko explains.

2016-01-12

6,270 reads

Top 10 MySQL Reporting Tools

by Additional Articles

Database Journal

MySQL

Both management and various departments rely on data reports to help guide their business decisions. Rob Gravelle presents ten open source and commercial report generation tools for MySQL and other relational databases.

2016-01-11

4,964 reads