Additional Articles

All authors

External Article

Jodie Beay and the Production 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

External Article

Declarative SQL: Using UNIQUE 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

Technical Article

Exploration of SQL Server 2016 Always Encrypted – Part 1

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-12-14

3,661 reads

Technical Article

Integrating Big Data Applications into Operational Environments

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-12-11

4,993 reads

All authors

Blogs

A Daily Report from Claude

By

Redgate had some Claude training recently, which I went through as my knowledge has...

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By

How I used AI for this postChatGPT to generate images based on info specifically...

Read the latest Blogs

Forums

Demo Tracking Dropped Objects

By Artur Sanin

Comments posted to this topic are about the item Demo Tracking Dropped Objects

Randomly Selecting Columns and Rows from a Table or View

By Artur Sanin

Comments posted to this topic are about the item Randomly Selecting Columns and Rows...

How Can SQL Server Detect Application Errors When Developers Can’t?

By Pablo Echeverria

Comments posted to this topic are about the item How Can SQL Server Detect...

Visit the forum

Question of the Day

Getting Database MaiL Profiles

If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?

See possible answers