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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,889,744 DBAs, developers and SQL Server users

Headlines today   August 23, 2017

Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events

Over the course of this stairway series, we're going to explore in detail the use of Extended Events as a diagnostic data collection tool, to track down causes of poor performance in SQL Server. This first level will start from a point known and familiar to many DBAs, namely the use of SQL Trace to track down and investigate long-running queries.  Read more...
By Erin Stellato 2017/08/23 (first published: 2015/12/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,950 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2017/08/23 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 84,636 reads

Installing SQL Server Agent on SUSE Linux

Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.  Read more...
By Additional Articles 2017/08/23 | Source: MSSQLTips.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 792 reads
Previous headlines

Load Extended Events via Powershell

Learn how you can load Extended Events with PowerShell, nice and fast.  Read more...
By Aakash Patel 2017/08/22 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 507 reads

How to Find Out Which Database Object Got Deleted

Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.  Read more...
By Additional Articles 2017/08/22 | Source: Database Journal | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,720 reads

Azure DWH part 14: PolyBase to access to Non relational data

In this article, we will learn how to work with PolyBase using Azure SQL DWH.   Read more...
By Daniel Calbimonte 2017/08/21 | Source: SQLServerCentral.com | Category: polybase
Rating: |  Discuss |   Briefcase | 294 reads

Is It Time To Stop Using IsNumeric()?

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.  Read more...
By Additional Articles 2017/08/21 | Source: SimpleTalk | Category: isnumeric()
Rating: (not yet rated)  Rate this |   Briefcase | 3,033 reads

Extending DevOps practices to SQL Server databases with Redgate, Git & Jenkins

Join Microsoft Data Platform MVP, Grant Fritchey, for our next Database DevOps demo webinar. He’ll be plugging Redgate’s tools into Git and Jenkins to show you how Redgate's Database DevOps solution helps you build, test and deploy your database changes alongside your app code.  Read more...
By 2017/08/21 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,703 reads

Analysing Sales Patterns: R + SQL Server

We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.  Read more...
By Nick Burns 2017/08/18 (first published: 2015/12/15) | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 6,819 reads

Database Code Analysis

Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.  Read more...
By Additional Articles 2017/08/18 | Source: SimpleTalk | Category: code analysis
Rating: (not yet rated)  Rate this |   Briefcase | 2,388 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

Automatic Sample Sizes for Statistics Updates

I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...  Read more...
By matthew.mcgiffen 73574 2017/08/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 678 reads

Always Encrypted with Azure Key Vault

I recently wrote a post about using Transparent Data Encryption (TDE) with Azure Key Vault as an alternative to managing...  Read more...
By Bradley Schacht 2017/08/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 580 reads
Question of the Day

Shape the matrix

By Steve Jones 2017/08/23 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 344 reads

I assign a simple set of values to a variable in R:

football <- c("LT", "WR", "LG", "HB", "C", "QB", "RG", "FB" ,"RT", " ", "TE", "WR")

I then want to shape this somehow,... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
75195 299395 SSC Guru  
Jeff Moden
63168 278038 SSC Guru  
Steve Jones - SSC Editor
39274 185620 SSC Guru  
Lynn Pettis
28668 123441 SSC Guru  
27069 98759 SSC Guru  
Latest forum posts