Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,882,521 DBAs, developers and SQL Server users

Previous headlines

The Mysterious Case of the Missing Default Value

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.  Read more...
By Raul Gonzalez @SQLDoubleG 2017/03/24 (first published: 2015/12/01) | Source: SQLServerCentral.com | Category: sql server internal storage
Rating: |  Discuss |   Briefcase | 5,194 reads

Encrypting SQL Server: Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,901 reads

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 576 reads

Getting Started with Azure SQL Data Warehouse - Part 2

Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,070 reads

Continuous Delivery and the Development DBA

How to do database development with trunk based development and Continuous Delivery  Read more...
By Pedro Lopez 2017/03/22 | Source: SQLServerCentral.com | Category: continuous delivery
Rating: |  Discuss |   Briefcase | 950 reads

Follow-up #1 on leading wildcard seeks

Aaron Bertrand shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.  Read more...
By Additional Articles 2017/03/22 | Source: SQLPerformance.com | Category: wildcard
Rating: (not yet rated)  Rate this |   Briefcase | 2,432 reads

Webinar: how to get started with DevOps

More and more teams are turning to DevOps as way to improve the efficiency and quality of software delivery but it’s not always clear what's the best way to get started. Redgate have invited Steve Thair, CTO of the DevOpsGuys, to share some practical tips on how you can start implementing DevOps in your organization. Register for the free webinar.  Read more...
By 2017/03/22 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,571 reads

TODAY: extending DevOps practices to SQL Server databases

In this free webinar later today, Steve Jones and Arneh Eskandari show how to use migration scripts as part of an automated database deployment. For the demo, they’ll be plugging Redgate’s Database DevOps solution into Git, TeamCity and Octopus Deploy.  Read more...
By 2017/03/21 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,788 reads

Core Database Source Control Concepts

Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.  Read more...
By Additional Articles 2017/03/21 | Source: SimpleTalk | Category: source control
Rating: (not yet rated)  Rate this |   Briefcase | 2,901 reads

Backups in Azure SQL Data Warehouse

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.  Read more...
By Daniel Calbimonte 2017/03/20 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 342 reads
 
Ask SQL Server Central



Question of the Day

It Just Runs Faster - In-Memory Optimized Operations

By Steve Jones 2017/03/24 | Category: in-memory oltp tables
Rating: (not yet rated) |  Discuss |   Briefcase | 543 reads

What does SQL Server 2016 do to make In-Memory Optimized operations run faster?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
17928 74105 SSC Guru  
2.
Jeff Moden
16898 70193 SSC Guru  
3.
Steve Jones - SSC Editor
10023 51315 SSC Guru  
4.
Grant Fritchey
9443 29488 One Orange Chip  
5.
Lynn Pettis
6467 33554 SSC-Dedicated  
Latest forum posts