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

   Items 1 to 20 of 17076    Older >>
 

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: (not yet rated) |  Discuss |   Briefcase | 190 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 | 8 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 | 374 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 | 503 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 | 47 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 | 293 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 | 72,699 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 | 2,470 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 | 56 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 | 712 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,592 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,619 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,594 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,546 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 | 50 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 | 73 reads

The conflict between data protection and DevOps

Data breaches are the new normal – according to the Identity Theft Resource Center there were nearly 1,600 of them in 2017 in the US alone, exposing 179 million records. No wonder companies want to keep data confidential and protected. At the same time, however, the increasing pace of business means developers need to create and release code in much shorter DevOps timescales. Steve Jones discussed ways to solve this conflict  Read more...
By 2018/08/13 | Source: Redgate | Category: data protection
Rating: (not yet rated)  Rate this |   Briefcase | 1,356 reads

The Worst Day

Today Steve Jones reminisces about his career and asks you to do the same.  Read more...
By Steve Jones 2018/08/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

Learning about FOR JSON

Links and information about the FOR JSON clause in SQL Server 2016.  Read more...
By Site Owners 2018/08/10 (first published: 2015/10/05) | Source: SQLServerCentral.com | Category: for json
Rating: |  Discuss |   Briefcase | 4,424 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2018/08/10 (first published: 2016/09/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,995 reads
   Items 1 to 20 of 17076    Older >>