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

Headlines today   January 18, 2018

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: (not yet rated) |  Discuss |   Briefcase | 227 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 | 549 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/18 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,704 reads

Finding code smells using SQL Prompt: old-style join syntax

SQL Prompt implements a static code analysis rule which will check code automatically for occurrences of non-ANSI standard JOIN syntax - here's how it works.  Read more...
By 2018/01/18 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 364 reads
Previous headlines

Stairway to MDX - Level 5: Members, and an Introduction to the MDX Members Functions

Bill explains what is meant by a 'Member' and 'Member function' in MDX. A member is an item in a dimension that include the 'measures' which are the values of the attributes that belong to a dimension. 'Measures' are themselves members of a dimension called the “measures” dimension. MDX has a set of functions, known as member functions, each of which allow us to perform operations upon any member of a dimension   Read more...
By Bill Pearson 2018/01/17 (first published: 2011/09/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,993 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2018/01/17 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 65,550 reads

Introduction to Agile with SQL Server

Working with SQL Server in Agile software development can be difficult. Ben Brumm provides an overview of Agile, specifically Scrum, and what to expect when SQL Server, or really any SQL platform, is involved.  Read more...
By 2018/01/17 | Source: SimpleTalk | Category: agile
Rating: (not yet rated)  Rate this |   Briefcase | 1,790 reads

Disk Encryption and The Impact to DBAs

As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.  Read more...
By John F. Tamburo 2018/01/16 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 680 reads

Step by Step Guide to Migrate SQL Server Data to SQL Server 2017

This step by step approach explains how to assess your SQL Server migration using DMA. Learn how to understand the behavior of your existing version and what changes need to be made to migrate to a newer version of SQL Server.  Read more...
By 2018/01/16 | Source: SimpleTalk | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 2,685 reads

NEW – Create, protect and manage non-production databases with SQL Provision

Redgate's newest offering helps address data privacy and protection concerns by creating copies of SQL Server databases that mask all sensitive data. SQL Provision serves as a gateway between production and non-production environments, to ensure the safe distribution of database copies from one central location, without blocking the team’s development and release processes.  Read more...
By 2018/01/16 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,272 reads

From the SQLServerCentral Blogs

Template Variables (Day 7)

Do you have scripts that you need to run frequently, but every time you need to set some different parameters?...  Read more...
By Wayne Sheffield 2018/01/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 321 reads

How to Size Your Database Files?

Let’s say you need to create a new SQL Server database, which is going to grow very fast, but you...  Read more...
By Guy Glantser 2018/01/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 445 reads
Question of the Day

Collation order by

By George Copeland 2018/01/18 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 129 reads

In SQL Server 2015, with an English default (code page 1252), look at this code:

--Declare a table variable with a varchar column and insert the following values--
(CHAR(65) + '-Uppercase... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
42748 547805 SSC Guru  
Jeff Moden
39771 505730 SSC Guru  
Steve Jones - SSC Editor
24093 328309 SSC Guru  
Lynn Pettis
18101 223194 SSC Guru  
Grant Fritchey
17888 221148 SSC Guru  
Latest forum posts