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

Previous headlines

The Real World: Implementing Data Compression in SQL Server 2008 R2

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008  Read more...
By Kenneth Igiri 2018/10/19 (first published: 2016/01/18) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 3,090 reads

Your SQL Server is Bored: What Low Wait Times Mean

In which you ask your assistant to fetch your coffee, and time them.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,536 reads

The 4 pillars of SQL Server Monitoring

In this new whitepaper, 5 SQL Server experts; Grant Fritchey, Rodney Landrum, Kathi Kellenberger, Phil Factor and Tony Davis, use their many years of experience working and maintaining data systems to explain the 4 key strategies required for a successful, estate-wide monitoring solution.   Read more...
By 2018/10/19 | Source: Redgate | Category: sql monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,738 reads

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 | 351 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 | 1,591 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 | 1,247 reads

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 | 237 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,461 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,489 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 | 480 reads

Question of the Day

Finding the Percentage

By Steve Jones 2018/10/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 491 reads

I have a database of baseball statistics. In the entire history of batting, I want to find out what percentage of players have hit 40 or more home runs in...  Read more...
Latest forum posts