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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,898,533 DBAs, developers and SQL Server users

Previous headlines

TEMPDB Enhancements in SQL Server 2016

TEMPDB Enhancements in SQL Server 2016 - By default enforced to follow best practices.  Read more...
By Dharmendra Keshari 2018/03/16 (first published: 2016/04/13) | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 5,971 reads

Data Encryption Using Always Encrypted in SQL Server

The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.  Read more...
By Additional Articles 2018/03/16 | Source: Database Journal | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,137 reads

Take the SQL Estate Data Mapping Survey and help shape Redgate’s products

Help Redgate to learn more about how SQL Server teams keep on top of sensitive data. If you're planning, or are already implementing, an information audit or data-mapping exercise for your SQL Server estate, please complete our short survey.  Read more...
By 2018/03/16 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 1,248 reads

SharePoint Disaster Recovery Plan

Hot standby disaster recovery process where SharePoint farm will become available in minutes  Read more...
By Deepak Kumeri 2018/03/15 | Source: SQLServerCentral.com | Category: disaster recovery
Rating: |  Discuss |   Briefcase | 328 reads

SQL Server Machine Learning Services – Part 6: Merging Data Frames in Python

In the final article in this series, Robert Sheldon demonstrates combining data sources with multiple formats into one Python data frame.  Read more...
By Additional Articles 2018/03/15 | Source: SimpleTalk | Category: python
Rating:  Rate this |   Briefcase | 2,058 reads

Extending DevOps to the database with Redgate: the role of automated testing

This webinar will show you how to use Redgate's SQL Test to include automated testing as part of a database DevOps workflow. There will be a walk-through of an automated build and deployment process with DLM Automation in VSTS, and plenty of time to ask questions.  Read more...
By 2018/03/15 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,885 reads

Stairway to U-SQL Level 20: Querying External Data with U-SQL

Did you know you can query SQL Server data with U-SQL? It's true! Find out how in this latest stairway step.  Read more...
By Mike McQuillan 2018/03/14 | Source: SQLServerCentral.com | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 465 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2018/03/14 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 90,038 reads


By default, when you run a query in SQL Server, your delete/update/insert (DUI) is finished as soon as your query finishes. That’s because the default behavior of SQL Server is IMPLICIT_TRANSACTIONS OFF – meaning, SQL Server doesn’t hold your queries open waiting for a COMMIT or ROLLBACK.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,685 reads

AI in Industries

It is important to showcase how Artificial Intelligence is being used in various fields and industries with some facts  Read more...
Rating: |  Discuss |   Briefcase | 254 reads

Question of the Day

A Mixed TVC

By Steve Jones 2018/03/16 | Category: table value constructor (tvc)
Rating: (not yet rated) |  Discuss |   Briefcase | 516 reads

What happens when I run this code in an AdventureWorks database?

WITH mycte
select id, price
(999, 0.00)
, (9999, -1.00)
, ((SELECT p.ProductID FROM Production.Product AS p WHERE productid = 321)
, (SELECT... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
34692 620035 SSC Guru  
Jeff Moden
31717 570447 SSC Guru  
Steve Jones - SSC Editor
19417 368301 SSC Guru  
Grant Fritchey
16406 252481 SSC Guru  
Lynn Pettis
13626 251678 SSC Guru  
Latest forum posts