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

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 | 311 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,827 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 | 2,255 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,202 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,165 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 | 4,250 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,801 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,365 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,479 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,247 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 | 871 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,142 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 2019/01/09 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 52,735 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 | 795 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,425 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/27 (first published: 2018/10/30) | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 4,918 reads

Get the Error Column Name in SSIS

This article will show how you can get the column name for error rows in an SSIS 2016 Data Flow task.  Read more...
By Karthik K 2018/10/29 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 935 reads

Extended Events Workbench

The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to get started using it. In this article, Phil Factor demonstrates several useful Extended Event sessions that measure just one thing in each. He then provides the code necessary to parse the resulting XML into something you can use.  Read more...
By Additional Articles 2018/10/29 | Source: SimpleTalk | Category: extended events (xe)
Rating: (not yet rated)  Rate this |   Briefcase | 2,204 reads

The future of SQL Census

Find out what plans Redgate has for SQL Census and leave your comments to have your own input in the future of the tool.   Read more...
By 2018/10/29 | Source: Redgate | Category: sql census
Rating: (not yet rated)  Rate this |   Briefcase | 2,145 reads