Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,868,303 DBAs, developers and SQL Server users

Previous headlines

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.   Read more...
By Gregory Larsen 2016/09/23 (first published: 2015/05/27) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,753 reads

Querying Multiple MySQL Tables

It’s been said that one of the drawbacks to normalization to the third form (3NF) is more cumbersome data extraction due to the greater number of tables. These require careful linking via JOIN clauses. Improper table joining can easily result in erroneous results or even in the dreaded Cartesian Product. In today’s article, Rob Gravelle explores how table joins are achieved in MySQL.  Read more...
By Additional Articles 2016/09/23 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 1,753 reads

Audit and Compliance Survey

Redgate are trying to understand the broad problem of auditing and compliance from a database perspective. Though it's a wide-ranging topic, they're particularly interested in better understanding pain points in the area. Additional to the survey, they're also offering a $30 Amazon voucher for anyone who would be willing to participate in a short phone call.  Read more...
By 2016/09/23 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,839 reads

Monitor up-time and connectivity with Powershell

Use Powershell to troubleshoot SQL connectivity issues. A way to monitor up-time and connectivity of a SQL server database with some simple Powershell commands.  Read more...
By David Rich 2016/09/22 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 894 reads

AT TIME ZONE – a new favourite feature in SQL Server 2016

Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.  Read more...
By Additional Articles 2016/09/22 | Source: | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,511 reads

Code completion, formatting and refactoring for SQL Server

A common misconception is that Redgate’s SQL Prompt is ‘just’ a code completion tool. While this is indeed at the heart of SQL Prompt, there are a host of features that will help you and your team work more quickly and efficiently, freeing you up to concentrate on the important stuff. Take a whistle stop tour around SQL Prompt in this short demo.  Read more...
By 2016/09/22 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,086 reads

Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions

Continuing his examination of the evolving DAX “Function / Iterator Pairs,” Business Intelligence Architect, Analysis Services Maestro, Microsoft Data Platform MVP and author Bill Pearson introduces the DAX Concatenate() and ConcatenateX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Concatenate() and ConcatenateX(), in joining two text strings into a single text string, and in returning the concatenation of an expression evaluated for each row in a table, respectively.  Read more...
By Bill Pearson 2016/09/21 | Source: | Category: dax
Rating: |  Discuss |   Briefcase | 670 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2016/09/21 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 76,192 reads

Free-Con Pre-Con at the Pass Summit 2016

A free day of training on Monday, October 24 in Seattle this year. Join MCMs, MVPs, and Friends of Redgate for a free day of training.  Read more...
By Press Release 2016/09/21 | Source: | Category: conferences and events
Rating: (not yet rated)  Rate this |   Briefcase | 1,502 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2016/09/20 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,899 reads
Ask SQL Server Central

Question of the Day

Getting Ready for R

By Steve Jones 2016/09/23 | Category: microsoft r services
Rating: (not yet rated) |  Discuss |   Briefcase | 553 reads

Which of these sp_configure statements needs to run in order to allow R scripts to be run in SQL Server 2016 with Microsoft R Services?

Top Members (last 30 days)
# Name Score Level
30 days All-time
517 2104 SSCrazy  
GP Van Eron
389 2224 SSCrazy  
250 354 Old Hand  
Jeff Moden
198 41429 SSC-Forever  
188 45297 SSC-Forever  
Latest forum posts