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?

Daily Database Backup Scripts

by Greg Bernstein

SQLServerCentral.com

Backup

Execute these stored procedures to backup all your database daily and your transaction logs several time daily. Save space by using the overwrite feature.

The Machines are Learning

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones talks about the advances in machine learning.

SQL Server 2016 : In-Memory OLTP Enhancements

by Additional Articles

SQLServerCentral

in-memory oltp

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

Byte Me: Christmas Confusion

by Bob Lang

SQLServerCentral

Byte Me

Setting Santa straight.

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.

The Years of Experience

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones looks at your experience, and what you do with it.

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.