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

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").

Automate Your Backup and Restore Tasks

by Philip Horan

SQLServerCentral.com

Administration

A new article that shows how you can automate a basic function that many environments need: the backup of a production database and the restore on a development system.

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.

Security Decisions

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones looks at how we make secutiy decisions for our systems, and whether this is really the best way to do things.

Jodie Beay and the Production Database Drift

Daily Database Backup Scripts

The Machines are Learning

SQL Server 2016 : In-Memory OLTP Enhancements

Automate Your Backup and Restore Tasks

Byte Me: Christmas Confusion

Solve Common SQL Server Restore Issues

The Years of Experience

Declarative SQL: Using UNIQUE Constraints

Security Decisions

Blogs

Understanding Fabric Ontology

QUOTENAME Basics: #SQLNewBlogger

When growing companies outgrow Excel

Forums

BCA KCP Ngagel Jaya Selatan Telpon/WA:083179431313

BCA KCP Kertajaya Indah Telpon/WA:083179431313

Alamat kontak resmi BCA KCU BLITAR Telp:0817866887

Question of the Day

QUOTENAME Quote Parameters