SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2018/10/30 to 2018/11/06

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,642 reads

Caution about Restoring via SSMS v17

A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe.  Read more...
Rating: |  Discuss |   Briefcase | 1,517 reads

How Big is Your Transaction Log?

If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.  Read more...
By Additional Articles 2018/11/06 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 3,555 reads

Import flat files to SQL Server on Linux using Azure Data Studio

Have you ever wonder how to import flat files to SQL Server on Linux? In this article, I will share my experience loading data to a Linux SQL Server instance using the new Azure Data Studio data import extension from macOS.  Read more...
By Carlos Robles 2018/11/05 | Source: SQLServerCentral.com | Category: linux
Rating: |  Discuss |   Briefcase | 260 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,118 reads

Azure and Windows PowerShell: Using VM Extensions

In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process.  Read more...
By Additional Articles 2018/11/05 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,793 reads

5th annual “Seattle Freecon”

On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE.  Read more...
By Additional Articles 2018/11/02 (first published: 2018/10/29) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,084 reads

Checking for Database Drift using Extended Events and SQL Monitor

You need to make sure that nobody makes unauthorized changes to the metadata of your production databases. Any drift in the state of the database, from the one that was deployed, is a security issue and must be investigated. How do you make sure that the schema of the database, in the sense of the metadata, hasn’t been changed surreptitiously?  Read more...
By 2018/11/02 | Source: Redgate | Category: database drift
Rating: (not yet rated)  Rate this |   Briefcase | 2,065 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 | 3,399 reads

The Configured Data Masks for Dynamic Data Masking

Continuing with his look at Dynamic Data Masking, Steve Jones looks at the masking patterns available besides the default mask.  Read more...
By Steve Jones 2018/11/02 (first published: 2016/04/06) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,767 reads

Your SQL Servers Are Misconfigured...

It's probably not your fault, but relying on the defaults of a SQL Server installation might be impacting the performance of your instance.  Read more...
By Kevin3NF 2018/11/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,281 reads

HIPAA and Database Administration – Part 2

HIPAA was signed into law in the United States in 1996. In this article, Robert Sheldon discusses how the act affects the day-to-day responsibilities of database administrators.  Read more...
By Additional Articles 2018/11/01 | Source: SimpleTalk | Category: hipaa
Rating: (not yet rated)  Rate this |   Briefcase | 2,351 reads

The 4 pillars of SQL Server Monitoring

In this new whitepaper, 5 SQL Server experts; Grant Fritchey, Rodney Landrum, Kathi Kellenberger, Phil Factor and Tony Davis, use their many years of experience working and maintaining data systems to explain the 4 key strategies required for a successful, estate-wide monitoring solution.   Read more...
By 2018/11/01 (first published: 2018/10/19) | Source: Redgate | Category: sql monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 6,071 reads

What is ADF? Level 1 of the Stairway to Azure Data Factory

Azure Data Factory is a new way of moving data around, and this first level gives you a good overview of what the service can do.  Read more...
By Andy Leonard 2018/10/31 | Source: SQLServerCentral.com | Category: azure data factory
Rating: |  Discuss |   Briefcase | 642 reads

Managing the SQL Server Estate

Everyone has their own ideas for what makes for an ideal monitoring solution for their SQL Server estates. Here Rodney Landrum outlines some of his ideas for how a monitoring tool can help monitor, analyze and predict resource usage, across a growing and diversifying estate, and to help the organization to connect server resource usage and error conditions directly to their impact on business processes.  Read more...
By 2018/10/31 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,004 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2018/10/31 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 50,584 reads

SSIS Basics: Data cleansing using derived columns

On this article I will show you how to perform a basic data cleansing using the derived column data transformation  Read more...
By Eduardo Pivaral 2018/10/30 | Source: SQLServerCentral.com | Category: integration services
Rating: |  Discuss |   Briefcase | 731 reads

SQL Server 2019 is Here

On Monday, Sep 24, 2018, at the Ignite 2018 conference, Microsoft announced the first public preview of SQL Server 2019 (community technical preview (CTP) release of SQL Server 2.0).This new release of SQL Server is packed with many new features to improve performance, integrate your increasing volumes of corporate data, beef up security, and more.   Read more...
By Additional Articles 2018/10/30 | Source: Database Journal | Category: sql server 2019
Rating:  Rate this |   Briefcase | 4,270 reads

Redgate acknowledged as a representative vendor in Gartner’s 2018 Market Guide for Data Masking

Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from 15% in 2017. And Redgate is acknowledged in the Guide as a representative vendor for Data Masking.  Read more...
By Press Release 2018/11/13 (first published: 2018/10/30) | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,126 reads