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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,906,910 DBAs, developers and SQL Server users

Previous headlines

Introduction to Microsoft R Services in SQL Server 2016

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.  Read more...
By Tomaž Kaštrun 2018/09/14 (first published: 2016/09/15) | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 3,918 reads

Single-Column-Key Missing Index Recommendations are Usually Wrong.

When Clippy suggests an index with only one key, look closer.  Read more...
By Additional Articles 2018/09/14 | Source: Brent Ozar Unlimited Blog | Category: index count
Rating: (not yet rated)  Rate this |   Briefcase | 1,603 reads


Introducing the PARSE function, brought to us in SQL Server 2012.  Read more...
By Matthew McGiffen 2018/09/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,266 reads

How to Linux for SQL Server DBAs — Part 1

As running SQL Server on Linux becomes more common, DBAs must learn and become comfortable with the Linux OS. In this article, Kellyn Pot'Vin-Gorman demonstrates how to create a SQL Server instance running in Linux via a Docker container.  Read more...
By Additional Articles 2018/09/13 | Source: SimpleTalk | Category: linux sql server
Rating: (not yet rated)  Rate this |   Briefcase | 1,695 reads

It’s official: database development is now part of DevOps

You’ll probably have heard of the Accelerate State of DevOps Report from DORA. Now in its fifth year and backed by rigorous research involving 30,000+ professionals worldwide, it has consistently shown that higher software delivery performance delivers powerful business outcomes.  Read more...
By 2018/09/13 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,803 reads

Stairway to SSAS Tabular Level 4: Implementing Date Dimensions

In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.  Read more...
By Thomas LeBlanc 2018/09/12 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 400 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2018/09/12 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 50,754 reads

Deep dive into Python scripts execution in SQL Server

This article looks at how Microsoft implemented the Python language support into SQL Server and how it can be used.  Read more...
By Additional Articles 2018/09/12 | Source: MSSQLTips.com | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,083 reads

What is the impact of setting SET ANSI_WARNINGS OFF?

Setting ANSI_WARNINGS OFF to avoid NULL value elimination warnings can have an impact on the data quality and system behaviour.  Read more...
By Nakul Vachhrajani 2018/09/11 (first published: 2016/08/23) | Source: SQLServerCentral.com | Category: set options
Rating: |  Discuss |   Briefcase | 4,181 reads

SQL Prompt Code Analysis: Avoid using the ISNUMERIC Function (E1029)

Avoid using the IsNumeric() function, because it can often lead to data type conversion errors, when importing data. SQL Prompt Code Analysis rules include an Execution rule, E1029, which will alert you to use of this function, in your T-SQL. If you’re working on SQL Server 2012 or later, it’s much better to use the Try_Convert()or Try_Cast() function instead. On earlier SQL Server versions, the only way to avoid it is by using LIKE expressions.  Read more...
By 2018/09/11 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 2,400 reads

Question of the Day

Password policy on Linux

By Steve Jones 2018/09/14 | Category: sql server on linux
Rating: (not yet rated) |  Discuss |   Briefcase | 289 reads

I have installed SQL Server 2017 RTM on Linux. I am creating a new login for a client. What are my password policy options?

Latest forum posts