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

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

Create, Protect and manage non-production databases with SQL Provision

SQL Provision allows teams to create a secure, scalable and repeatable process for managing data as it moves through your SQL Server estate, without causing administrative burdens. Tony Davis explains how SQL Provision can work alongside your existing database DevOps practices.  Read more...
By 2019/02/11 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 1,688 reads

DR Prep Can Miss the Little Things

A minor disaster for Steve reveals some cracks in his pre-DR planning.  Read more...
By Steve Jones 2019/02/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 28 reads

A Capital Error

It's not the zero'th time Phil Factor has complained about the madness of a binary collation.  Read more...
By Phil Factor 2019/02/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Using SQL Server and R Services for analyzing Sales data (Part 3)

Using R integration for analyzing sales data in WideWorldImporters database  Read more...
By Tomaž Kaštrun 2019/02/08 (first published: 2017/01/17) | Source: SQLServerCentral.com | Category: r services
Rating: |  Discuss |   Briefcase | 2,144 reads

Learn More than Technology

There is more to our lives than work, and Steve asks that we learn more about other parts of life.  Read more...
By Steve Jones 2019/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

Which Version of SQL Server Should You Use?

Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?  Read more...
By Additional Articles 2019/02/08 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,546 reads

Automatic Provisioning of Developer Databases with SQL Provision

Microsoft MVP Steve Jones provides a simple proof-of-concept workflow that allows organizations to provision full sized databases for developers, using production like data that has been masked automatically as a part of the provisioning process.   Read more...
By 2019/02/08 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,379 reads

Forgiveness

Learning active forgiveness can be a challenge, but it may help you build a better team.  Read more...
By Steve Jones 2019/02/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 52 reads

Microsoft SQL Server Utilities and Tools

Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 275 Utilities  Read more...
By Konstantin Taranov 2019/02/07 (first published: 2017/06/23) | Source: SQLServerCentral.com | Category: tools
Rating: |  Discuss |   Briefcase | 4,631 reads

Protecting SQL Server Data Using Static Data Masking

In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and testers must not contain private and sensitive data from production databases. To help DBAs protect data, Microsoft have released a new feature as part of SSMS called Static Data Masking. In this article, Greg Larsen demonstrates how to use this new feature.  Read more...
By Additional Articles 2019/02/07 | Source: SimpleTalk | Category: static
Rating: (not yet rated)  Rate this |   Briefcase | 2,482 reads

Keeping sensitive Data secure outside of Production

Part of the complication of implementing DevOps into database development is the involvement of data. Microsoft MVP Grant Fritchey explores the use of dynamic data masking and the strategies that can protect the data when it moves into less secure environments like development and test.   Read more...
By 2019/02/07 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,334 reads

Complex Constrained Security

Setting up your authorization and security can be fairly easy, but perhaps we ought to consider more complex scenarios.  Read more...
By Steve Jones 2019/02/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 33 reads

Stairway to Data, Level 1: The Basics

A great deal of the confusion that occurs when a database application is developed comes from a poor understanding of the basics of data. Here, Joe Celko gives a broad coverage of the difficulties you're likely to meet when handling data in databases  Read more...
By Joe Celko 2019/02/06 (first published: 2011/05/12) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 18,541 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2019/02/06 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 104,766 reads

Import data dynamically using R and Python in Power BI Desktop

Learn how to import data into Power BI using either R or Python scripts.  Read more...
By Additional Articles 2019/02/06 | Source: MSSQLTips.com | Category: importing data
Rating: (not yet rated)  Rate this |   Briefcase | 1,988 reads

How SQL Provision completes the Database DevOps story

Database DevOps is not without its challenges. When SQL Provision is introduced into the tool chain it can enable organizations to reduce the burden on network resources, minimize administrative tasks and accelerative database delivery updates. Tony Davis explains how..   Read more...
By 2019/02/06 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,496 reads

DR Planning

Disaster recovery planning can be hard, and we often forget about some of the non technical issues.  Read more...
By Steve Jones 2019/02/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 35 reads

A Tiny Trauma

Unexpected issue with a hidden calculation on TinyInt  Read more...
By Mike Tanner 2019/02/05 | Source: SQLServerCentral.com | Category: data type
Rating: |  Discuss |   Briefcase | 892 reads

Better Code Reviews with GIT

As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.  Read more...
By Additional Articles 2019/02/05 | Source: SimpleTalk | Category: git
Rating: (not yet rated)  Rate this |   Briefcase | 3,034 reads

Complimentary access to Gartner’s 2018 Market Guide for Data Masking from Redgate

According to Gartner, "security and risk management leaders should use data masking to desensitize or protect sensitive data to address threats and compliance requirements." Gartner further adds, "by 2021, the global enterprise use of data masking (DM) or similar de-identification techniques will increase to 40%, an increase from 15% in 2017." Redgate is acknowledged as a representative vendor for data masking. Redgate are offering complimentary access to the report.   Read more...
By 2019/02/05 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,761 reads
<< Newer    Items 21 to 40 of 17633    Older >>