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

<< Newer    Items 61 to 80 of 15936    Older >>
 

How to Generate a Restore Script

There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?  Read more...
By Additional Articles 2017/07/06 | Source: Database Journal | Category: restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,528 reads

You’re not delivering DevOps to the database

"There have been, and, in our increasingly connected and interconnected world, will continue to be, a large number of spectacular failures with technology. I want to point the finger at all of us for these failures. It’s not Development. It’s not Operations. It’s us. We’re in it together. If we don’t communicate with each other, share our knowledge, we’re going to mess up horribly."  Read more...
By Grant Fritchey 2017/07/06 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,793 reads

Byte Me: Paranormal Presence

By Bob Lang 2017/07/05 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Machine Learning for Outlier Detection in R

A look into clustering to detect outliers in R. An extension on univariate statistical tests to include multivariate data.  Read more...
By Nick Burns 2017/07/05 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 579 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2017/07/05 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 65,950 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 | 5,266 reads

Independence Day 2017

A holiday in the US has Steve Jones thinking about compromise and communication.  Read more...
By Steve Jones 2017/07/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

SQL Server Memory

SQL Server Memory in Task Manager - Should I be Worried?  Read more...
By Ginger Keys 2017/07/04 (first published: 2015/12/14) | Source: SQLServerCentral.com | Category: memory
Rating: |  Discuss |   Briefcase | 9,276 reads

3 Solutions For Auditing Long SQL Server Extracts or Loads

In this post, Tim Smith looks at the different options you can use to audit your SQL Server extracts and loads during the ETL process.  Read more...
By Additional Articles 2017/07/04 | Source: MSSQLTips.com | Category: etl
Rating: (not yet rated)  Rate this |   Briefcase | 3,206 reads

Download SQL patch Info

This article shows how to download sqlserverbuilds.blogspot.com to build your own automated sql patch level check.  Read more...
By Theo Ekelmans 2017/07/03 | Source: SQLServerCentral.com | Category: sqlserverbuilds
Rating: |  Discuss |   Briefcase | 1,241 reads

The 43rd Birthday for SQL

Today we look at SQL, celebrating its 43rd birthday today.  Read more...
By Steve Jones 2017/07/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 70 reads

Visual Checks on How Data is Distributed in SQL Server

There are many reasons for wanting to know how data is distributed. Sometimes you just want a rough idea of the way that data is distributed in a column. You may think, wouldn't it be nice to have a SQL function that just showed you roughly what the distribution was, graphically, in the results pane. Phil Factor thought that was well and turned the vague wish into reality.  Read more...
By 2017/07/03 | Source: SimpleTalk | Category: sql server
Rating:  Rate this |   Briefcase | 3,811 reads

Backup Preparations

This week Steve asks you to make sure you practice your restore skills periodically.  Read more...
By Steve Jones 2017/07/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 27 reads

Where’s the Ops in DevOps? Part 2

What does the future of IT Operations look like in a DevOps world? As more businesses rely on virtualisation, containers, cloud, Infrastructure as a Service, and Microservices, is there still a place for it? How do these teams change to continue to deliver value when supporting Agile Operations techniques?  Read more...
By 2017/07/03 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,487 reads

A Database Design Test

Steve Jones saw a database design test for developers, but he's never been given one.  Read more...
By Steve Jones 2017/06/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 173 reads

A General Way to Maintain History Tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.  Read more...
By Jefferson Elias 2017/06/30 (first published: 2015/09/28) | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 9,371 reads

Export data from SQL Server to Excel

What native SQL Server options are available to export to Excel? Jeremy Kadlec explains.  Read more...
By Additional Articles 2017/06/30 | Source: MSSQLTips.com | Category: excel
Rating:  Rate this |   Briefcase | 4,924 reads

The Louis Davidson custom style for SQL Prompt

In this article, Louis Davidson sticks his neck out, and offers what he believes is a sensible code formatting style, based on twenty-plus years of writing SQL. The result is the Louis Davidson custom SQL Prompt style that you can download using the link at the end of the post, try out, and adapt as required.  Read more...
By 2017/06/30 | Source: Redgate | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,384 reads

Scoring Outliers in Non-Normal Data with R

Using R to detect outliers is relatively easy, but most methods assume your data is normally distributed. How do you handle skewed datasets?  Read more...
By Nick Burns 2017/06/29 | Source: SQLServerCentral.com | Category: outlier detection
Rating: |  Discuss |   Briefcase | 534 reads

Handling Data Corruption

This week Steve Jones wonders what you might do if you discovered data corruption.  Read more...
By Steve Jones 2017/06/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 41 reads
<< Newer    Items 61 to 80 of 15936    Older >>