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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,905,777 DBAs, developers and SQL Server users

Previous headlines

Using Code Snippets in SSMS

Snippets will allow you to code faster by inserting chunks of code with few key strokes.  Read more...
By Luis Cazares 2018/08/17 (first published: 2016/04/07) | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 4,411 reads

How to Check Performance on a New SQL Server

Before you go live, test your backup and CHECKDB speeds.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,393 reads

Forget GDPR. Think HIPAA, SOX, PCI, SHIELD and the CCPA.

Data protection legislation in the USA, however, has been around for a long time, and more is on the way, and for most types of business, the changes will move compliance from a minor issue to a big concern.   Read more...
By 2018/08/17 | Source: Redgate | Category: hipaa
Rating: (not yet rated)  Rate this |   Briefcase | 1,435 reads

Aggregate Data for the Last Day of the Month

On some occasions you will need to aggregate Data for the Last Day of the Month. This article explains how.  Read more...
By Adam Aspin 2018/08/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 891 reads

Information Security in Practice

Along with the GDPR, regulations require that confidential data is protected and used properly. In this article, William Brewer discusses the ways that data manages to migrate around the organisation and the challenges found in protecting that data.  Read more...
By Additional Articles 2018/08/16 | Source: SimpleTalk | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 1,754 reads

SQL Prompt code analysis: avoid non-standard column aliases

Phil Factor looks at SQL Prompt code analysis; column alias violations and the right way to alias  Read more...
By 2018/08/16 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 1,806 reads

Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux

In this first article of the Stairway to SQL Server on Linux, learn how to set up your host server.  Read more...
By Danilo Dominici 2018/08/15 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: (not yet rated) |  Discuss |   Briefcase | 367 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2018/08/15 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 73,197 reads

SQL Server Performance Tuning Scripts, Tips and Tricks

In this webcast, Tim Smith takes a look at various tips and tricks to assist you with performance tuning your SQL Server databases. Knowing how to find and resolve problems is key to improving performance, so join him to learn how to optimize your systems  Read more...
By Additional Articles 2018/08/15 | Source: MSSQLTips.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 3,303 reads

Using pw-inspector in Brute Force attack on SQL Server

In this article we're going to explore the world of brute force attacks and pwd-inspector for tests with SQL Server  Read more...
By Anil Kuhat 2018/08/14 | Source: SQLServerCentral.com | Category: brute force
Rating: |  Discuss |   Briefcase | 766 reads

Question of the Day

Using UPDATE()

By Steve Jones 2018/08/17 | Category: update()
Rating: (not yet rated) |  Discuss |   Briefcase | 517 reads

Where can I use the UPDATE() function?

Latest forum posts