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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,901,374 DBAs, developers and SQL Server users

Headlines today   May 21, 2018

SQL Server on Linux, does it have Microsoft's full attention?

SQL Server on Linux doesn't support Ubuntu 18.04 LTS. Why weren't Microsoft ready for the next LTS release?  Read more...
By Thom Andrews 2018/05/21 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: |  Discuss |   Briefcase | 399 reads

Working with Windows Containers and Docker: Save the Data

Docker continues to make improvements in their products running on Windows. In this article, Nicolas Prigent explains how to share data between Windows containers and the container host. As a bonus, he also shows how to run a Linux container on Windows Server 2016.  Read more...
By Additional Articles 2018/05/21 | Source: SimpleTalk | Category: windows containers
Rating: (not yet rated)  Rate this |   Briefcase | 319 reads

The State of SQL Server Monitoring 2018

Over 600 technology professionals who work in organizations that use SQL Server recently responded to our survey to discover the current state of SQL Server monitoring.  Read more...
By 2018/05/21 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 378 reads
Previous headlines

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.  Read more...
By Joshua Feierman 2018/05/18 (first published: 2015/10/19) | Source: SQLServerCentral.com | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 4,225 reads

Transaction Locking and Row Versioning Guide

This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.  Read more...
By Additional Articles 2018/05/18 | Source: Microsoft MSDN | Category: locking
Rating: (not yet rated)  Rate this |   Briefcase | 4,502 reads

Using SQL Server as a Source with for an Excel Application

I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.  Read more...
Rating: |  Discuss |   Briefcase | 972 reads

Artificially Intelligent - Text Sentiment Analysis

One of the truisms of the modern data-driven world is that the velocity and volume of data keeps increasing. We’re seeing more data generated each day than ever before in human history. And nowhere is this rapid growth more evident than in the world of social media, where users generate content at a scale previously unimaginable.   Read more...
By Additional Articles 2018/05/17 | Source: Microsoft MSDN | Category: ai
Rating: (not yet rated)  Rate this |   Briefcase | 2,421 reads

Welcome to Redgate tools for SQL Operations Studio

Built on top of Visual Studio Code, SQL Operations Studio is a free lightweight tool for modern database development and operations that runs on Windows, macOS and Linux. It’s been designed for developers without a deep knowledge of database administration, so that they can manage databases and maintain them.  Read more...
By 2018/05/17 | Source: Redgate | Category: sql operations studio
Rating: (not yet rated)  Rate this |   Briefcase | 2,180 reads

What is the Machine Learning Server? Level 2 of the Stairway to ML Services

In Level 2, we look at the architecture and structure of the Machine Learning Services server process.  Read more...
Rating: |  Discuss |   Briefcase | 659 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2018/05/16 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 95,962 reads

From the SQLServerCentral Blogs

Extended Events – Using Azure Storage

Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/)  and gave an example where I was capturing deadlocks...  Read more...
By Arun Sirpal 2018/05/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,096 reads

Helper procedure to dynamically execute list of statements

I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some...  Read more...
By faig.garayev 2018/05/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,692 reads
Question of the Day

Corrupted Backups

By Steve Jones 2018/05/21 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 394 reads

I have a database in which the last DBCC CHECKDB reported corruption errors. Before I try to repair this, I want to be sure I have a copy of the...  Read more...
Latest forum posts