SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,897,565 DBAs, developers and SQL Server users

Rss
Headlines today   February 22, 2018

Performance Comparison Between SQL Server 2014 and 2016

This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.  Read more...
By Savaram Ravindra 2018/02/22 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 938 reads

Introducing a DevOps culture

Your organization’s culture of DevOps will often be the defining factor on whether you have a successful organizational change, or whether the changes that you implement impact pockets of your organization.  Read more...
By 2018/02/22 | Source: Redgate | Category: devops
Rating:  Rate this |   Briefcase | 1,529 reads

Degree of Duplication

Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe Celko reminisces about the history of database design and how it relates to the concept of ‘Degree of Duplication’ in this article.  Read more...
By Additional Articles 2018/02/22 | Source: SimpleTalk | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 1,294 reads
Previous headlines

Stairway to Database Design Level 9: Normalization

In the final step of Database Design, Joe Celko gives a simple but effective explanation of the normalization process and why it is important.  Read more...
By Joe Celko 2018/02/21 (first published: 2011/11/11) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,219 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2018/02/21 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 92,184 reads

SQL Server Reporting Services 2017 Tutorial

SQL Server Reporting Services has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, web front end and security make SSRS the tool of choice.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,339 reads

Solve Sudoku with T-SQL - Part 1

A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.  Read more...
By bevan ward 2018/02/20 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 1,581 reads

How to Move a TDE Encryption Key to Another SQL Server Instance

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,825 reads

Sign up for more free training from Redgate

Redgate has committed to hosting a free virtual event in every quarter of 2018, and will be kicking this off on February 28 with a livestream themed around data privacy and protection. The agenda has now been released, so you can see who will be presenting, what they will be presenting, and how you can tune in to watch.  Read more...
By 2018/02/20 | Source: Redgate | Category: event
Rating: (not yet rated)  Rate this |   Briefcase | 2,020 reads

Implementing John Conway's Game of Life in Microsoft SQL Server

A fun exercise, using CTEs to implement John Conway's Game of Life cellular automata simulation  Read more...
By Paul Chang 2018/02/19 (first published: 2015/09/22) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 5,661 reads
 

From the SQLServerCentral Blogs

Obsessing over query operator costs

A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators. The...  Read more...
By Gail Shaw 2018/02/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,486 reads

Database Maintenance Without Breaking The Bank

Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of...  Read more...
By MarlonRibunal 2018/02/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,870 reads
Question of the Day

Restoring with CDC

By Steve Jones 2018/02/22 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 382 reads

I have a database, called Finance, with Change Data Capture (CDC) enabled inside of it. During a DR event, we decide to restore the most recent backup of this database...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
36167 591654 SSC Guru  
2.
Jeff Moden
32042 544643 SSC Guru  
3.
Steve Jones - SSC Editor
19956 352400 SSC Guru  
4.
Grant Fritchey
15004 239245 SSC Guru  
5.
Lynn Pettis
14258 240497 SSC Guru  
Latest forum posts