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

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

SQL Azure Reporting Automation

This article will talk about preparing a runbook in Azure to schedule the report of space usage of databases in Azure environment  Read more...
By Tushar Kanti 2017/06/21 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 408 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 2017/06/21 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 59,332 reads

Six reasons to version control your database

For most application developers, it's unthinkable to work without version control. What about the database? What's stopping you version controlling yours?   Read more...
By 2017/06/21 | Source: Redgate | Category: version control
Rating: (not yet rated)  Rate this |   Briefcase | 3,299 reads

Migrating Schema Between Platforms

The decision to change platforms isn't one Steve Jones takes lightly.  Read more...
By Steve Jones 2017/06/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

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,071 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,145 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,417 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 | 539 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 | 652 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 | 56 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,661 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,485 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,074 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,103 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 | 800 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,382 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,664 reads
<< Newer    Items 21 to 40 of 15854    Older >>