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

<< Newer    Items 21 to 40 of 15850    Older >>
 

Dealing with High Concurrency with Table Hints

Systems with a large number of requests on a critical database table are prone to blocking and slowness. We take a look at getting things done using T-SQL table hints.  Read more...
By Joao Osorio 2017/06/20 | Source: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 1,058 reads

Properly Persisted Computed Columns

Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.  Read more...
By Additional Articles 2017/06/20 | Source: SQLPerformance.com | Category: trace flags
Rating: (not yet rated)  Rate this |   Briefcase | 3,053 reads

Statistics in SQL: Kendall’s Tau rank correlation

Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating correlation, regression and variance on large quantities of data. It just isn't always immediately obvious how. In the second of a series of articles, Phil factor shows how calculating a non-parametric correlation via Kendall's Tau or Spearman's Rho can be stress-free.  Read more...
By Additional Articles 2017/06/20 | Source: SimpleTalk | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 2,322 reads

Scoring Outliers with R

What is normal? More to the point, what is abnormal? We will look at using R to score outliers in a typical monitoring dataset.  Read more...
By Nick Burns 2017/06/19 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 533 reads

Help for DBAs Who Support SSIS…

SSIS Catalog Compare helps DBAs work with their SSIS project configurations and catalogs, deploying changes from environment to environment.  Read more...
By Andy Leonard 2017/06/19 | Source: SQLServerCentral.com | Category: ssis catalog compare
Rating: (not yet rated) |  Discuss |   Briefcase | 647 reads

DevOps Can Help

DevOps can help, not just development, but also infrastructure, if you spend time adapting the practices to your environment.  Read more...
By Steve Jones 2017/06/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 30 reads

The Need for DRE

We need to become engineers instead of administrators.  Read more...
By Steve Jones 2017/06/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 55 reads

Extending DevOps practices to SQL Server databases - Story Tracking

Join Microsoft Data Platform MVP Grant Fritchey for the next Database DevOps demo webinar. He’ll be plugging Redgate tools into Atlassian's Jira, Bitbucket, and Bamboo, as well as showing how you can integrate database changes, code, and issues.  Read more...
By 2017/06/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,451 reads

Your Job Description

This Friday Steve Jones talks about job posting and descriptions. This is the chance to think about what you do and how you might describe this to your replacement.  Read more...
By Steve Jones 2017/06/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 84 reads

The Invisible DBA

Do you want super powers? Learn how to be an invisible DBA!  Read more...
By Jason Givens 2017/06/16 | Source: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 1,476 reads

Use T-SQL to Find Folders Using the Most Disk Space

Your SQL Server drives are running out of disk space and you want a way to quickly tell which sub-directories are taking the most space - here's how to do it with T-SQL.  Read more...
By Additional Articles 2017/06/16 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,008 reads

How to implement a SQL formatting standard using SQL Prompt v8

With ten programmers working on the same project, how do you agree on a standard style for formatting SQL code, and then implement it consistently? One way is through draconian rules, meeting after meeting, and the occasional sacrifice of a programmer to put the fear in those who remain. Another way is using SQL Prompt, Louis Davidson shows how.  Read more...
By 2017/06/16 | Source: Redgate | Category: formatting
Rating: (not yet rated)  Rate this |   Briefcase | 4,020 reads

Setting up R in SQL 2016 – Avoiding Pitfalls

Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.  Read more...
By Paulo de Jesus 2017/06/15 | Source: SQLServerCentral.com | Category: r services
Rating: |  Discuss |   Briefcase | 796 reads

Securing the Things

The Internet of Things is coming, and bringing lots of data, but security needs to be included as well.  Read more...
By Steve Jones 2017/06/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 29 reads

Questions About SQL Server Collations You Were Too Shy to Ask

Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.  Read more...
By Additional Articles 2017/06/15 | Source: SimpleTalk | Category: collation
Rating: (not yet rated)  Rate this |   Briefcase | 3,333 reads

Data classification: understanding and protecting your data

What is data classification? Why go to the effort of classifying your data? Jonny Roberts explains.  Read more...
By 2017/06/15 | Source: Redgate | Category: classification
Rating: (not yet rated)  Rate this |   Briefcase | 2,604 reads

Stairway to U-SQL Level 15: U-SQL Global Scalar Functions With C#

In this article, see how to created shared functions using C# assemblies in U-SQL.  Read more...
By Mike McQuillan 2017/06/14 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 382 reads

A Bad First Day

A bad first day, as a developer crashes a production database.  Read more...
By Steve Jones 2017/06/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2017/06/14 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 83,571 reads

Setting Variables in Calling T-SQL Code While Using sp_executesql

In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.  Read more...
By Additional Articles 2017/06/14 | Source: Database Journal | Category: variables
Rating: (not yet rated)  Rate this |   Briefcase | 3,204 reads
<< Newer    Items 21 to 40 of 15850    Older >>