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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,888,544 DBAs, developers and SQL Server users

Headlines today   July 28, 2017

SQLCMD and Batch File magic

Execute scripts in a folder with a single click using SQLCMD and a batch file.  Read more...
By Manu Mohanan 2017/07/28 (first published: 2015/11/19) | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 7,587 reads

Getting Started with SQL Server 2012 Express LocalDB

Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task.  Read more...
By Additional Articles 2017/07/28 | Source: MSSQLTips.com | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 1,253 reads

Simple Talk is hiring a full-time editor

Have experience editing and writing technical content? Redgate is currently hiring for their educational publishing site, Simple Talk. They're open to accepting remote workers, so if you're interested, there's no excuse not to go ahead and apply!  Read more...
By Site Owners 2017/07/28 | Source: Redgate | Category: hiring
Rating: (not yet rated)  Rate this |   Briefcase | 965 reads
Previous headlines

Advanced Analytics with R and SQL Part II - Data Science Scenarios

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.   Read more...
By Frank A. Banin 2017/07/27 | Source: SQLServerCentral.com | Category: data science
Rating: |  Discuss |   Briefcase | 552 reads

Statistics in SQL: The Kruskal–Wallis Test

Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis test is a safe way of determining whether samples come from the same population, because it is simple and doesn't rely on a normal distribution in the population. This allows you a measure of confidence that your results are 'significant'. Phil Factor explains how to do it.  Read more...
By Additional Articles 2017/07/27 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 2,276 reads

SQL-On-Hadoop: Hive - Part I

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.  Read more...
By Frank A. Banin 2017/07/26 | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 691 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 2017/07/26 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 84,346 reads

How to Read the Transaction Log File

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.  Read more...
By Additional Articles 2017/07/26 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 2,984 reads

Azure DWH part 12: Permissions, roles, logins and users

In this article we will show some common roles and queries related to Azure SQL Data Warehouse.  Read more...
By Daniel Calbimonte 2017/07/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 285 reads

Containers for enhanced Data Governance and Compliance

Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.  Read more...
By Paul Stanton 2017/07/25 | Source: SQLServerCentral.com | Category: windocks
Rating: |  Discuss |   Briefcase | 216 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

PowerShell $env Variables

I was playing with containers the other day, reading a Simple Talk article on the topic, and noticed the code...  Read more...
By Steve Jones 2017/07/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 972 reads

How to display more text in SSMS

Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL...  Read more...
By Daniel Janik 2017/07/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,624 reads
Question of the Day

Converting XML

By Steve Jones 2017/07/28 | Category: try_convert()
Rating: (not yet rated) |  Discuss |   Briefcase | 409 reads

I run this code, and I get a NULL because this isn't valid XML.

What is returned with this code?

SELECT TRY_CONVERT(XML, 4)  
Top Members (last 30 days)
# Name Score Level
30 days All-time
79407 235354 SSC Guru  
Jeff Moden
68774 224029 SSC Guru  
Steve Jones - SSC Editor
42534 151828 SSC Guru  
Lynn Pettis
31185 99133 SSC Guru  
Grant Fritchey
27654 101711 SSC Guru  
Latest forum posts