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

Popular Content

The risks of using EXECUTE (‘SQL Script’)

Using dynamic SQL is unavoidable at times, but it is reckless to execute dynamic SQL that is created directly from strings that include values that change at execution time. It can allow SQL Injection and it is also inefficient.  Read more...
By 2019/02/22 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 4,512 reads

6 DBA Lessons I Wish Someone Would Have Taught Me Earlier

The name of the Agent job isn't necessarily what it does, and just because your'e not getting failure emails doesn't mean the job is working.  Read more...
By Additional Articles 2018/10/05 | Source: Brent Ozar Unlimited Blog | Category: dba tips
Rating:  Rate this |   Briefcase | 6,500 reads

The BI Journey: The Analyst

Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are just getting started. This article, by Data Platform MVP Gogula Aryalingam, describes how analytics can start small – with just one Power BI dashboard – and grow from there.  Read more...
By Additional Articles 2019/02/21 | Source: SimpleTalk | Category: bi
Rating:  Rate this |   Briefcase | 3,451 reads

Protecting Credit Card Data when Testing

Privacy regulations, ranging from GDPR to HIPAA, among many others, put strict compliance requirements on the storage and use of personal and sensitive data. In this article Grant Fritchey explains how the data masking technology in SQL Provision can help you protect credit card data while maintaining characteristics and distribution of the real thing.   Read more...
By Additional Articles 2019/03/05 | Source: Redgate | Category: sql provision
Rating:  Rate this |   Briefcase | 2,928 reads

How Check Constraints MIGHT Improve Your Queries and Missing Index Requests

In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.  Read more...
Rating:  Rate this |   Briefcase | 3,987 reads

Index Tuning Week: How Many Indexes Are Too Many?

When you're not sure, start by aiming for 5 or less indexes per table, with 5 or less fields each.  Read more...
By Additional Articles 2018/11/02 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating:  Rate this |   Briefcase | 4,287 reads

Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters

In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.  Read more...
By Additional Articles 2018/09/17 | Source: MSSQLTips.com | Category: like
Rating:  Rate this |   Briefcase | 4,263 reads

Adaptive Query Processing in SQL Server 2017

As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new in 2017, represents a new direction. This set of features provides some flexibility for varying join types, multi-statement table valued functions, and memory grants. In this article, Robert Sheldon explains the three features that make up Adaptive Query Processing  Read more...
By 2018/10/25 | Source: SimpleTalk | Category: adaptive query processing
Rating:  Rate this |   Briefcase | 3,686 reads

SQL Prompt Code Analysis: Avoid using the ISNUMERIC Function (E1029)

Avoid using the IsNumeric() function, because it can often lead to data type conversion errors, when importing data. SQL Prompt Code Analysis rules include an Execution rule, E1029, which will alert you to use of this function, in your T-SQL. If you’re working on SQL Server 2012 or later, it’s much better to use the Try_Convert()or Try_Cast() function instead. On earlier SQL Server versions, the only way to avoid it is by using LIKE expressions.  Read more...
By 2018/09/11 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 4,268 reads

Avoid use of the MONEY and SMALLMONEY datatypes

One of SQL Prompt's code analysis recommendations is that you avoid using the MONEY and SMALLMONEY datatypes - this article from Phil Factor explains why.  Read more...
By 2018/05/04 | Source: Redgate | Category: code analysis
Rating:  Rate this |   Briefcase | 6,270 reads

Finding code smells using SQL Prompt: Asterisk in SELECT list

In this article Phil Factor explains how to find code smells using SQLPrompt: Asterisk in SELECT list  Read more...
By 2018/06/15 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 4,780 reads

SQL Prompt as a Layout Tool: A Survival Guide

Phil Factor's guide to taming SQL Prompt layout options, and getting it to format code just the way you like it.  Read more...
By 2018/11/05 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 2,865 reads

An Easier Way of Pivoting Data in SQL Server

There are several methods to pivot, or transpose, data in T-SQL, but most are difficult to understand and write. Phil Factor demonstrates how to take advantage of JSON support, introduced with SQL Server 2016, to create a function that makes pivoting data simple.  Read more...
By 2018/02/16 | Source: SimpleTalk | Category: pivoting
Rating:  Rate this |   Briefcase | 7,641 reads

Help Redgate improve Data Masker for SQL Server?

Redgate are looking for people to help them get a deep understanding of compliance and SQL Server data masking requirements in order to ensure they can provide a world class solution. In return for your feedback you’ll have early access to new releases, insights into new features and their ongoing support to get up and running.   Read more...
By 2018/11/08 | Source: Redgate | Category: data masking
Rating:  Rate this |   Briefcase | 2,560 reads

Introducing SQL+ Dot Net

SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.  Read more...
By Alan Hyneman 2019/03/07 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,924 reads

SQL Server Logical Reads – What do they really tell us?

SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading  Read more...
Rating:  Rate this |   Briefcase | 3,265 reads

SQL Clone V3: New features heighten visibility and manageability of clones and images.

With a brand new dashboard, activity feed and search functionality there is a lot happening in the SQL Clone v3 release. Check out the full breakdown of the update and get onto the latest version.   Read more...
By 2018/11/06 | Source: Redgate | Category: sql clone
Rating:  Rate this |   Briefcase | 1,992 reads

SQL Code Smells

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. There are now around 150 of these smells and SQL Code Guard is committed to cover as many as possible of them.  Read more...
By Additional Articles 2017/11/06 | Source: SimpleTalk | Category: sql
Rating:  Rate this |   Briefcase | 8,933 reads

Verify File Exists Using PowerShell

In this tip we look at a PowerShell script that can be used to compare actual files that exist against a list of files that should exist for a project to identify any missing files.  Read more...
By Additional Articles 2019/02/27 | Source: MSSQLTips.com | Category: powershell
Rating:  Rate this |   Briefcase | 2,703 reads

“But I don’t need to back up that database.”

Brent Ozar shares four stories of people who thought they could avoid backups - and got burned.  Read more...
By Additional Articles 2018/05/04 | Source: Brent Ozar Unlimited Blog | Category: backups
Rating:  Rate this |   Briefcase | 5,670 reads