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

   Items 1 to 20 of 17080    Older >>
 

The Best Days

Today Steve wonders about the best days of your career.  Read more...
By Steve Jones 2018/08/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 28 reads

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,166 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 | 1,649 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 | 947 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 | 847 reads

What Data is Really Needed?

With the GDPR being enforced, a court in Germany makes a ruling.  Read more...
By Steve Jones 2018/08/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 41 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,487 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,625 reads

Maintain Your Trustworthiness

DBAs and sysadmins need to be trustworthy.  Read more...
By Steve Jones 2018/08/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 57 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 | 358 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,039 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,008 reads

The Master of the Schema

Go database first, not code first.  Read more...
By Steve Jones 2018/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 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 | 754 reads

How to Remove Transparent Data Encryption From a Database

There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.  Read more...
By Additional Articles 2018/08/14 | Source: Database Journal | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 1,736 reads

Practical PowerShell Processes with SQL Change Automation

How to use the PowerShell cmdlets of SQL Change Automation to take the source code of a database from a directory, validate it, document it and then create a NuGet package of it.  Read more...
By 2018/08/14 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 1,795 reads

Why QUOTENAME is important

Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.  Read more...
By Thom Andrews 2018/08/13 | Source: SQLServerCentral.com | Category: quotename()
Rating: |  Discuss |   Briefcase | 1,689 reads

Go Unit Tests: Tips from the Trenches

In this article, Michael Sorens describes unit testing for applications written in Go. While focused on Go, many of his recommendations and techniques can be applied to other languages as well.  Read more...
By Additional Articles 2018/08/13 | Source: SimpleTalk | Category: go
Rating: (not yet rated)  Rate this |   Briefcase | 1,696 reads

What is NoSQL?

Steve talks about the definition of what a NoSQL database might be and where they are useful.  Read more...
By Steve Jones 2018/08/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 55 reads

The TSB disaster: Where were the grown-ups?

Phil Factor describes how TSB performed a major public disservice with micrsoservices.  Read more...
By Phil Factor 2018/08/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 82 reads
   Items 1 to 20 of 17080    Older >>