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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,899,851 DBAs, developers and SQL Server users

Headlines today   April 19, 2018

Do you check your backups?

Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.  Read more...
By Michael Higgins 2018/04/19 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 267 reads

SQL Server Graph Databases – Part 2: Querying Data in a Graph Database

Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use the new function.  Read more...
By Additional Articles 2018/04/19 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 852 reads

5 challenges to scaling DevOps at enterprise level

Many large enterprises launch small DevOps initiatives within certain departments, but subsequently find that scaling DevOps across the organization faces a number of challenges that must be overcome.  Read more...
By 2018/04/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 625 reads
Previous headlines

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.  Read more...
By Hugo Kornelis 2018/04/18 (first published: 2015/11/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,523 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2018/04/18 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 102,849 reads

Why sp_prepare Isn’t as “Good” as sp_executesql for Performance

Erik Darling shows how execution plan estimates suffer. 
Rating: (not yet rated)  Rate this |   Briefcase | 1,662 reads

Fixing system database corruption with setup.exe

Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.  Read more...
By Kenneth Fisher 2018/04/17 | Source: SQLServerCentral.com | Category: database corruption
Rating: |  Discuss |   Briefcase | 599 reads

Recover Data in SQL Server AWS RDS with the Help of BACPAC

With Amazon RDS, it’s easy to have a SQL Server running in minutes. There are some limitations, though. Seth Delconte explains a workaround to overcome one of the limitations: the inability to restore a second copy of a database to recover missing data.  Read more...
By Additional Articles 2018/04/17 | Source: SimpleTalk | Category: aws
Rating: (not yet rated)  Rate this |   Briefcase | 1,349 reads

Effective Database Testing with SQL Test and SQL Cover

A well-established technique for improving application code quality, during software development, is to run unit tests, in conjunction with a code coverage tool. The aim is not only to test that your software components behave as you would expect, but also that your suite of tests gives your code a thorough workout.  Read more...
By 2018/04/17 | Source: Redgate | Category: testing
Rating: (not yet rated)  Rate this |   Briefcase | 1,562 reads

SQL Server From .Net: Making A Connection

A basic introduction for developers about creating a connection from .Net to SQL Server, and some of the options available.  Read more...
By Tim Wellman 2018/04/16 | Source: SQLServerCentral.com | Category: ado.net
Rating: |  Discuss |   Briefcase | 537 reads

From the SQLServerCentral Blogs

Azure SQL Database and Columnstore Indexes

I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...  Read more...
By Arun Sirpal 2018/04/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,330 reads

Change SQL Server Collation – Back to Basics

One of my most favorite things in the world is the opportunity to deal with extremely varying database and environment...  Read more...
By Jason Brimhall 2018/04/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,234 reads
Question of the Day

Log shipping for SQL Server 2017 on Linux

By Evgeny Garaev 2018/04/19 | Category: sql server 2017 on linux
Rating: (not yet rated) |  Discuss |   Briefcase | 179 reads

Let's suppose you have two instances of SQL Server 2017, one on Linux and another one on Windows. Is it possible to set up log shipping between these two instances?

Latest forum posts