2016-02-10
206 reads
Articles
Cloud Adoption Survey
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
2016-02-10
5,272 reads
Enabling TDE on Databases in an AlwaysOn Scenario
Enabling Transparent Data Encryption on Databases in Always On Scenario
2016-02-09
13,624 reads
The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs
The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their plans, exploring their context settings, and checking their performance metrics. In using the Query Store to ensure that performance is as good as possible, it isn't long before it becomes important to be familiar with the DMVs that are associated with the query store, and using them in custom queries.
2016-02-09
3,612 reads
Thinking About the Cloud?
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
2016-02-09
5,583 reads
2016-02-08
8,015 reads
Exploration of SQL Server 2016 Always Encrypted – Part 3
In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.
2016-02-08
3,437 reads
Centrally collect replication conflicts and send an alert
Automatically capture replication conflicts and generate an automated email notification.
2016-02-05 (first published: 2011-10-17)
3,592 reads
How to read data from multiple Excel worksheets with SQL Server Integration Services
Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.
2016-02-05
4,291 reads
SQL Azure Performance Benchmarking
An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.
2016-02-04
3,665 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers