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

Popular Content

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 | 6,638 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 | 4,490 reads

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.  Read more...
By Steve Jones 2018/01/22 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 4,408 reads

Why is My Database Application so Slow?

When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.  Read more...
By Additional Articles 2017/11/02 | Source: SimpleTalk | Category: performance
Rating:  Rate this |   Briefcase | 5,646 reads

Introduction to Agile with SQL Server

Working with SQL Server in Agile software development can be difficult. Ben Brumm provides an overview of Agile, specifically Scrum, and what to expect when SQL Server, or really any SQL platform, is involved.  Read more...
By 2018/01/17 | Source: SimpleTalk | Category: agile
Rating:  Rate this |   Briefcase | 3,983 reads

How to Do a SQL Server Architecture Review

How do you get management to help you figure out if a cluster or an AG is right for you? In this post, Brent Ozar explains the steps involved when doing a review of your SQL Server architecture.  Read more...
By Additional Articles 2017/11/09 | Source: Brent Ozar Unlimited Blog | Category: architecture
Rating:  Rate this |   Briefcase | 5,293 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.  Read more...
By Additional Articles 2018/01/09 | Source: SimpleTalk | Category: in-memory oltp
Rating:  Rate this |   Briefcase | 3,685 reads

Quickly Restricting Database Access

There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed. You want to stop users from connecting right away, but you want the database to be in a state that you can perform maintenance.   Read more...
By Additional Articles 2017/12/28 | Source: Database Journal | Category: access control
Rating:  Rate this |   Briefcase | 4,053 reads

SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server

SQLCLR is now considered a robust solution to the few niche requirements that can't be met by the built-in features of SQL Server. Amongst the legitimate reasons for avoiding SQLCLR, there is the fear of getting bogged down in code with special requirements that is difficult to debug. Darko takes a real example, extending the features of sp_send_dbmail, to demonstrate that there need be few terrors in SQLCLR.  Read more...
By Additional Articles 2017/09/25 | Source: SimpleTalk | Category: sqlclr
Rating:  Rate this |   Briefcase | 6,392 reads

Finding code smells using SQL Prompt: procedures that lack schema-qualification

It is a very good idea to get into the habit of qualifying the names of procedures with their schema. It is not only makes your code more resilient and maintainable, but as Microsoft introduces new features that use schemas, such as auditing mechanisms, you code contains no ambiguities that could cause problems.  Read more...
By 2018/01/12 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 3,941 reads

Performance Myths : Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...
By Additional Articles 2017/08/02 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 7,010 reads

Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask

Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you don't even know what the letters stand for. You just feel too shy to ask those basic questions that seem ridiculous once you're up to speed. Laerte Junior answers all the questions you need answers for when facing the prospect of getting familiar with Amazon's useful Database Migration Service.  Read more...
By Additional Articles 2017/12/29 | Source: SimpleTalk | Category: aws
Rating:  Rate this |   Briefcase | 3,878 reads

SQL Server R Services: Digging into the R Language

It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots.  Read more...
By Additional Articles 2017/09/15 | Source: SimpleTalk | Category: sql server r services
Rating:  Rate this |   Briefcase | 5,983 reads

Finding code smells using SQL Prompt: old-style join syntax

SQL Prompt implements a static code analysis rule which will check code automatically for occurrences of non-ANSI standard JOIN syntax - here's how it works.  Read more...
By 2018/01/18 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 3,334 reads

Let’s Corrupt a Database Together, Part 3: Detecting Corruption

Having already shown how to corrupt a database, and then how nonclustered indexes can be corrupted independently, in this post Brent Ozar explains how you can detect corruption.  Read more...
By Additional Articles 2017/08/15 | Source: Brent Ozar Unlimited Blog | Category: corruption
Rating:  Rate this |   Briefcase | 5,736 reads

So, what is GDPR and why should Database Administrators care?

You’ve no doubt heard at least something about the GDPR, the EU’s new privacy and Data Management law with its greatly increased maximum fines for non-compliance and tighter definitions for acceptable use of personal information. If you’ve continued reading past paragraph one of any of the many articles, you’ll be aware that the law applies globally, to all organizations holding EU citizens’ data – it’s not bounded by geography or jurisdiction.  Read more...
By 2017/10/03 | Source: Redgate | Category: gdpr
Rating:  Rate this |   Briefcase | 5,007 reads

The Basics of Good T-SQL Coding Style

TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and plan to never change job, then you need to comment and document your code, it must be inherently readable, well laid out, use informative and obvious names, and it must be robust and resilient; written defensively. It must not rely on deprecated features of SQL Server, or assume particular database settings. Robert Sheldon starts a series of articles that explains the basics.  Read more...
By Additional Articles 2017/07/05 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 7,077 reads

Performance Myths: Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...
By Additional Articles 2017/07/13 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 6,970 reads

sp_AllNightLog: Creating Jobs Like I’m The President

Erik Darling explains why sp_AllNightLog creates so many jobs by default.  Read more...
Rating:  Rate this |   Briefcase | 5,461 reads

The Best of Both Worlds: Using Excel and Power BI Together

Excel and Power BI work well together. This allows you to use the two tools together to provide for many types of business workflow and BI practices. You can publish an Excel file to Power BI to share with others, analyse a Power BI dataset in Excel or import either an Excel workbook or Excel data to Power BI. You can gain the workgroup power and business-orientation of Power BI without losing the ease and versatility of Excel. Saurabh shows how.  Read more...
By Additional Articles 2017/09/22 | Source: SimpleTalk | Category: excel
Rating:  Rate this |   Briefcase | 5,427 reads