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

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

Who should have Sysadmin rights?

The point of this article is that only service accounts and/or specific network sql admin accounts should have sysadmin rights.  Read more...
By Ben Kubicek 2019/03/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 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 | 606 reads

Microservice Reality

Phil Factor argues that very few processes, even in well-established businesses, mimic the dreamy clarity and autonomy of a microservice.  Read more...
By Phil Factor 2019/03/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 47 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,930 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,730 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,484 reads

Databasee Brainstorming

We sometimes need to think differently about different situations. Steve notes that we might approach the way we solve problems in new ways.  Read more...
By Steve Jones 2019/03/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 60 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,600 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,290 reads

Common Data Challenges

Steve wonders about the common challenges you may face.  Read more...
By Steve Jones 2019/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 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,866 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,980 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,601 reads

The Data Incident

Google and Microsoft have plans for dealing with data incidents. Steve thinks you should as well.  Read more...
By Steve Jones 2019/03/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 35 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,791 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,334 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,695 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,745 reads
<< Newer    Items 21 to 40 of 17725    Older >>