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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,896,203 DBAs, developers and SQL Server users

Headlines today   January 22, 2018

Automatic Database Seeding

Set up and use the automatic databases seeding feature for Availability Groups.  Read more...
By Evgeny Garaev 2018/01/22 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: (not yet rated) |  Discuss |   Briefcase | 431 reads

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.  Read more...
By Steve Jones 2018/01/22 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,543 reads

Do Disabled Indexes Affect Missing Index Recommendations?

Brent Ozar opens up the Stack Overflow database, turns on actual execution plans, and runs a query that will cause SQL Server to beg and plead for an index.  Read more...
By 2018/01/22 | Source: Brent Ozar Unlimited Blog | Category: missing index finder
Rating: (not yet rated)  Rate this |   Briefcase | 937 reads

Free webinar: Database DevOps demo

Microsoft MVP Grant Fritchey, and Redgate’s Arneh Eskandari, will show you how Redgate’s Database DevOps solution works to improve your database development and deployment processes. You'll see a demo of tools from Redgate's SQL Toolbelt and see how they plug into GIT, Jenkins and Octopus Deploy. There will also be plenty of time to ask Grant and Arneh questions.  Read more...
By 2018/01/22 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 756 reads
Previous headlines

Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes

An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.  Read more...
By Mike McQuillan 2018/01/19 (first published: 2016/06/15) | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 6,559 reads

How to identify blocking in SQL Server

Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock. This forces the second connection to be blocked until the first connection completes.   Read more...
By 2018/01/19 | Source: MSSQLTips.com | Category: blocking
Rating: (not yet rated)  Rate this |   Briefcase | 3,092 reads

Keeping track of history: SQL Compare and Temporal Tables

SQL Compare 13 introduces support for deploying changes to temporal tables, which were introduced in SQL Server 2016. This means that any changes made to the definition of a temporal table in a source database, including to the retention policy for that table, will be included automatically in any deployment script that SQL Compare generates for that database.  Read more...
By 2018/01/19 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,627 reads

Introducing sp_BlitzLock: For Troubleshooting SQL Server Deadlocks

Erik Darling's new easy script lists out deadlocks, apps, queries, and the users involved.   Read more...
By 2018/01/18 | Source: Brent Ozar Unlimited Blog | Category: deadlocks
Rating: (not yet rated)  Rate this |   Briefcase | 2,884 reads

Formatted ASCII Results from a SELECT

Generate aligned output from SELECT statement for code comments using a simple stored procedure.  Read more...
By bevan ward 2018/01/18 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 1,141 reads

From the SQLServerCentral Blogs

Azure VPN – Point to Site IP Addresses

Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an...  Read more...
By SQLRUs 2018/01/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 498 reads

Alwayson Availability Groups vs Alwayson Failover Cluster Instances

SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It...  Read more...
By Lincoln Burrows 2018/01/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,618 reads
Question of the Day

Changing Extensions

By Steve Jones 2018/01/22 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 464 reads

I have a database with 2 data files. I discover that the performance of this database is very poor as the anti-virus software is freezing access to one of the...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
42034 554575 SSC Guru  
Jeff Moden
38809 511789 SSC Guru  
Steve Jones - SSC Editor
23609 331975 SSC Guru  
Grant Fritchey
17524 223855 SSC Guru  
Lynn Pettis
17428 225918 SSC Guru  
Latest forum posts