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,421 DBAs, developers and SQL Server users

Headlines today   October 18, 2018

Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server

Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server Level Audit Group.  Read more...
By Deepak Prasad Sahu 2018/10/18 | Source: SQLServerCentral.com | Category: audit specification
Rating: |  Discuss |   Briefcase | 252 reads

Creating Machine Learning Applications using Azure Cognitive Services

Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this article, Supriya Pande provides a brief explanation of machine learning and then walks you through creating a sentiment analysis application.  Read more...
By Additional Articles 2018/10/18 | Source: SimpleTalk | Category: machine learning (ml)
Rating: (not yet rated)  Rate this |   Briefcase | 934 reads

Join Kendra Little at SQL in the City to capture the value of DevOps

Kendra Little is giving a 75-minute session on ‘Capturing the Value of DevOps’ at the upcoming SQL in the City Summits in New York City on October 12, London on October 18, and Chicago on October 26. The Summits are for C-level IT executives, directors, managers, and senior database engineers and administrators interested in learning about all things DevOps.  Read more...
By 2018/10/18 | Source: Redgate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 763 reads
Previous headlines

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 | 216 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 | 100,020 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 | 1,144 reads

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 | 463 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,230 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,526 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 | 749 reads

From the SQLServerCentral Blogs

The Project Graveyard

This post is a response to this month’s T-SQL Tuesday #107 prompt by Jeff Mlakar.  T-SQL Tuesday is a way...  Read more...
By Bert Wagner 2018/10/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,965 reads

Creating Wait stats widget on Azure Data Studio for macOS

A couple of weeks ago, Microsoft released a new multi-platform tool called Azure Data Studio, this tool is the final...  Read more...
By Carlos Robles 2018/10/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,621 reads
Question of the Day

Estimating DTUs

By Steve Jones 2018/10/18 | Category: azure sql database
Rating: (not yet rated) |  Discuss |   Briefcase | 313 reads

I am considering moving my on-premises SQL Server database to Azure SQL Database. I want to estimate what number of DTUs that I need to contract for. Which counters do...  Read more...
Latest forum posts