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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,908,362 DBAs, developers and SQL Server users

Headlines today   October 17, 2018

Installing the Database Server - Level 2 of the Stairway to SQL Server on Linux

In this next level, we learn how to install SQL Server on Linux and verify that everything is working.  Read more...
By Danilo Dominici 2018/10/17 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: (not yet rated) |  Discuss |   Briefcase | 97 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 2018/10/17 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 99,292 reads

Using Azure Quickstart Templates

In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.  Read more...
By Additional Articles 2018/10/17 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 621 reads
Previous headlines

Using Redgate API to compare data in the same table

I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.  Read more...
By Ben Kubicek 2018/10/16 | Source: SQLServerCentral.com | Category: redgate
Rating: |  Discuss |   Briefcase | 428 reads

Configuring a MySQL Database on Amazon RDS

Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.  Read more...
By Additional Articles 2018/10/16 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 1,022 reads

Testing the Performance of Individual SQL Statements within a Batch using SQL Prompt

This article is all about using a SQL Prompt snippet to create and run a test harness on a batch of SQL code, to provide performance data. Behind the scenes, the snippet creates and starts an Extended Events event session, inserts and runs the text of the batch of SQL you’ve selected in SSMS, and uses XQuery on the XML event data, to return it in digestible, tabular form.  Read more...
By 2018/10/16 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 3,145 reads

Being Careful with Schema Ownership

When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.  Read more...
By Steve Jones 2018/10/15 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 721 reads

A Primer on Defect Management

Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this article, Afsana Atar explains defect management, including prevention and resolution.  Read more...
By Additional Articles 2018/10/15 | Source: SimpleTalk | Category: defects
Rating: (not yet rated)  Rate this |   Briefcase | 1,183 reads

Trigger Happy

This article looks at using triggers to audit and to prevent the performing of unintended actions.  Read more...
By Andy Jones 2018/10/12 (first published: 2016/03/28) | Source: SQLServerCentral.com | Category: trigger
Rating: |  Discuss |   Briefcase | 3,761 reads

Finding & Fixing Statistics Without Histograms

Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.  Read more...
By Additional Articles 2018/10/12 | Source: Brent Ozar Unlimited Blog | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 2,261 reads

From the SQLServerCentral Blogs

Generate a random number of children for each parent

I was asked an interesting question the other day. Is it possible to get a different random number of rows...  Read more...
By Kenneth Fisher 2018/10/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,156 reads

SQL Server Data Collection and Management Data Warehouse

We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party...  Read more...
By SQLEspresso 2018/10/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,270 reads
Question of the Day

Single Element Tuples

By Steve Jones 2018/10/17 | Category: python
Rating: (not yet rated) |  Discuss |   Briefcase | 183 reads

I am creating a tuple in Python that for now contains a single item, a 7. I plan to add to this later, but how do I define this tuple,...  Read more...
Latest forum posts