SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines |
SQLServerCentral.com Headlines from 2019/03/05 to 2019/03/12

Using Azure Resource Manager Templates To Provision Azure SQL Databases

Azure provides a number of different methods that can be used in order to implement and configure its resources. Each of the methods differs to some extent in regard to functionality and intended use cases.  Read more...
By Additional Articles 2019/03/12 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,626 reads

Isolation Levels in SQL Server

Details discussion on the different isolation levels available in SQL Server  Read more...
By Sucharita Das 2019/03/12 | Source: SQLServerCentral.com | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 848 reads

A Re-Introduction to HIPAA and SOX

SQL Provision can help organizations ensure compliance with regulations such as HIPAA and SOX. But what exactly are these legislations asking of DBAs and how does this impact the work you do? Robert Sheldon provides an overview of the two US regulations in this four-part series.  Read more...
By Additional Articles 2019/03/12 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,078 reads

The BI Journey: The Expert’s Advice – Part 1

Creating a quick dashboard with a few reports may be the beginning of a BI solution, but unless time is spent on the underlying model, it won't be adaptable enough to grow. In this article by Gogula Aryalingam, you'll see how the advice of a mentor helped a newbie understand how to create a flexible model that will lead to a valuable BI solution.  Read more...
By Additional Articles 2019/03/11 | Source: SimpleTalk | Category: bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,767 reads

SQL Server DevOps with Production Databases and Git

Learn how to start using DevOps techniques to upgrade your database containers with the latest version of your code from a git repository.  Read more...
By Paul Stanton 2019/03/11 | Source: SQLServerCentral.com | Category: devops
Rating: |  Discuss |   Briefcase | 608 reads

Calling all Oracle Database users

We’re excited to announce that Redgate is doubling its efforts on Oracle and committed to aligning its DevOps solution across both SQL Server and Oracle. Please take a few minutes to complete this short survey to stay up-to-date on our Oracle developments.  Read more...
By Additional Articles 2019/03/11 | Source: Redgate | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 1,948 reads

What does Azure SQL DB Automatic Index Tuning actually do, and when?

Azure SQL DB’s Automatic Tuning will create and drop indexes based on your workloads. Brent's latest blog post shows how to enable it and explains what it actually does.   Read more...
By Additional Articles 2019/03/08 | Source: Brent Ozar Unlimited Blog | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,324 reads

Benefits of Data Masking highlighted in Gartner’s 2018 Market Guide

Gartner released their 2018 Market Guide for Data Masking, providing an in-depth analysis of the market with recommendations and representative vendors – including Redgate. Gartner says that "Test data (or copy data) virtualization is a technology that is increasingly popular, when used in combination with SDM (Static Data Masking), to speed up the provisioning of and updates to target environments, in addition to significantly reducing the amount of storage required by these environments.”   Read more...
By Additional Articles 2019/03/08 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,627 reads

The OUTPUT Clause for the MERGE Statements

In this article, I will provide a set of examples to showcase the use of OUTPUT clause within the MERGE statement and how to capture the OUTPUT clause results into an archive table.  Read more...
By Amarendra Reddy Thummeti 2019/03/08 (first published: 2017/06/08) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,486 reads

The Performance of Window Aggregates Revisited with SQL Server 2019

T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations available in SQL Server 2019 can improve the performance of these functions.  Read more...
By Additional Articles 2019/03/07 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,642 reads

Introducing SQL+ Dot Net

SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.  Read more...
By Alan Hyneman 2019/03/07 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,868 reads

Back to Basics; Masking Address Data

Protecting Personable Identifiable Information is central to the compliance of numerous regulations which your organization may be subject to. In this article Grant Fritchey starts with the basics of obfuscating address data with the data masking technology in SQL Provision.  Read more...
By Additional Articles 2019/03/07 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,999 reads

Transform your SQL Server permissions

SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective rights in a more controllable structure. Download and use SQL Census (in preview) for free.  Read more...
By Additional Articles 2019/03/06 (first published: 2019/03/04) | Source: Redgate | Category: sql census
Rating: (not yet rated)  Rate this |   Briefcase | 4,734 reads

One-way and Two-way Tabulation Example in SQL Server - Part 2

In this tip we demonstrate how to use dynamic SQL and stored procedures to simplify the computation with SQL of one-way and two-way tabulations.  Read more...
By Additional Articles 2019/03/06 | Source: MSSQLTips.com | Category: tabular
Rating: (not yet rated)  Rate this |   Briefcase | 2,368 reads

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more...
By David Durant 2019/03/06 (first published: 2019/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,027 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 2019/03/06 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 105,802 reads

New Truncation Error Message in SQL Server 2019

A new error message in SQL Server 2019 will make your life much easier!? Learn more...  Read more...
By Additional Articles 2019/03/05 | Source: Database Journal | Category: truncate
Rating: (not yet rated)  Rate this |   Briefcase | 3,218 reads

SSIS: Read Event viewer with WMI Data reader

Access OS event viewer and read it from a SSIS package using WMI Data reader task  Read more...
By Eduardo Pivaral 2019/03/05 | Source: SQLServerCentral.com | Category: integration services
Rating: |  Discuss |   Briefcase | 394 reads

Protecting Credit Card Data when Testing

Privacy regulations, ranging from GDPR to HIPAA, among many others, put strict compliance requirements on the storage and use of personal and sensitive data. In this article Grant Fritchey explains how the data masking technology in SQL Provision can help you protect credit card data while maintaining characteristics and distribution of the real thing.   Read more...
By Additional Articles 2019/03/05 | Source: Redgate | Category: sql provision
Rating:  Rate this |   Briefcase | 2,783 reads