Additional Articles

Jodie Beay and the Production Database Drift

by Additional Articles

SimpleTalk

Database Drift

You make an example database, like NorthWind or WidgetDev in order to test out your deployment system and the next thing you know you're worrying about constraints, backup and security. Then you add an index to the production system and feel a pang of guilt. What would the Devs say? Somehow databases take on lives of their own, populated by the lost souls of users, Developers and DBAs. Has the Redgate DLM Team's practice Forex database somehow come alive?

2015-12-18

3,479 reads

SQL Server 2016 : In-Memory OLTP Enhancements

by Additional Articles

SQLPerformance.com

in-memory oltp

Aaron Bertrand takes a look at the changes in store for In-Memory OLTP (the feature formerly known as "Hekaton").

2015-12-17

5,473 reads

Solve Common SQL Server Restore Issues

by Additional Articles

MSSQLTips.com

Backup and restore

Understanding backup and restore processes is essential for developers and DBAs to be more confident when dealing with uncommon situations and having the ability to suggest flexible solutions related to these processes. In this article, Sergey Gigoyan answers some key questions relating to backup and restore.

2015-12-16

3,341 reads

Declarative SQL: Using UNIQUE Constraints

by Additional Articles

SimpleTalk

constraints

In SQL, you can express the logic of what you want to accomplish without spelling out the details of how the database should do it. Nowhere is this more powerful than in constraints. In this introduction to Declarative SQL, Joe Celko demonstrates how you can write portable code that performs well and executes some complex logic, merely by creating unique constraints.

2015-12-15

6,149 reads

Exploration of SQL Server 2016 Always Encrypted – Part 1

by Additional Articles

Database Journal

SQL Server 2016

With the introduction of SQL Server 2016 you now have a new way to encrypt columns called Always Encrypted. With Always Encrypted, data is encrypted at the application layer via ADO.NET. This means you can encrypt your confidential data with your .NET application prior to the data being sent across the network to SQL Server. In this article, Greg Larson explains his experience with exploring setting up a table that stores always encrypted data.

2015-12-14

3,661 reads

Integrating Big Data Applications into Operational Environments

by Additional Articles

Database Journal

Big Data

Integrating big data appliance solutions into a data warehouse requires preparation and forethought. DBAs and business data consumers must work together both to address the implementation issues above and to meet the needs of multiple business data consumers. Lockwood Lyon discusses the topic.

2015-12-11

4,993 reads

Database Continuous Integration with SQL CI and Jenkins

by Additional Articles

SimpleTalk

Continuous Integration (CI)

If it's deemed important to test application code as part of a CI process, the same must apply to the database. In this blog post, Jason Crease shows how to create a smooth process where you can build and deploy databases alongside your application code from within Jenkins with the SQL CI plugin.

2015-12-10

3,631 reads