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

Headlines today   January 19, 2018

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,466 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 | 2,237 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 | 956 reads
Previous headlines

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,066 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,348 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 | 3,183 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:  Rate this |   Briefcase | 1,548 reads

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 | 8,016 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,840 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:  Rate this |   Briefcase | 2,188 reads

From the SQLServerCentral Blogs

Advent of Code 2017 Day 2–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...  Read more...
By Steve Jones 2018/01/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 696 reads

Summiting that Technical Challenge

Conquering Challenges I really like the topic of the TSQLTuesday party today. Today we have been instructed in no uncertain terms...  Read more...
By Jason Brimhall 2018/01/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 652 reads
Question of the Day

Basic COUNTs 1

By Steve Jones 2018/01/19 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 526 reads

I've got this table and data:

intcol INT
, charcol CHAR(10)
, varcharcol VARCHAR(100)
, datecol datetime2
INSERT TheCounts
VALUES (1, 'West', 'Denver Broncos', '2018-01-01')
, (2, 'West', 'Oakland Raiders', '2018-01-01')
, (3, 'West',... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
41774 549493 SSC Guru  
Jeff Moden
38633 507231 SSC Guru  
Steve Jones - SSC Editor
23592 329258 SSC Guru  
Lynn Pettis
17511 223896 SSC Guru  
Grant Fritchey
17454 221817 SSC Guru  
Latest forum posts