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,266 DBAs, developers and SQL Server users

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,160 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 | 3,983 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 | 918 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,194 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 | 1,946 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 | 633 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,832 reads

Calculating Employee Attrition with DAX – Part 2

In part 1, we described the requirements for calculating attrition and also demonstrated one method that doesn’t rely on writing DAX code at all. In the second part of this tip, we introduce alternative methods of creating a calculation in DAX to calculate the number of employees that have left the company.  Read more...
By Additional Articles 2018/05/16 | Source: MSSQLTips.com | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 1,824 reads

Covering Indexes: Not Just for SELECT but also for UPDATE statements

Covering indexes help UPDATE performance also 
By Mike Byrd 2018/05/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,073 reads

Pseudonymizing your data with SQL Data Generator

SQL Data Generator was, as its name suggests, intended to generate the data for databases, as required for testing, development work and training. However, it is perfectly at home with using the original data as the default source of the new data, and then substituting in fake data for any column that you want to mask - here's how.  Read more...
By 2018/05/15 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,482 reads

Question of the Day

Short Circuit or not?

By Steve Jones 2018/05/18 | Category: coalesce()
Rating: (not yet rated) |  Discuss |   Briefcase | 508 reads

What happens with this code?

SELECT COALESCE(5, CAST('A' AS INT), (SELECT (1/0)))  
Latest forum posts