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

<< Newer    Items 61 to 80 of 16820    Older >>
 

The future of database DevOps

In this post, Redgate's Foundry team reflect on their assessment of the status of DevOps for the database. As well as giving you a behind-the-scenes look at how they've arrived at this thinking and setting out their future direction, they also invite you to shape the future of database DevOps by getting involved.  Read more...
By 2018/05/03 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,872 reads

Installing Machine Learning Services – Level 1 of the Stairway to ML Services

This first installment of the Stairway to Machine Learning Services explains the installation process for this subsystem in SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 974 reads

Would You Move to Linux for Price?

There's a sale on the price of SQL Server for Linux and Steve wonders if people will move.  Read more...
By Steve Jones 2018/05/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 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 2018/05/02 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 96,043 reads

Preventing Invalid Data Early In An ETL Flow

In this post, Tim Smith will look at some of the considerations for both data rules and logic to prevent invalid data early in the ETRL process.  Read more...
By Additional Articles 2018/05/02 | Source: MSSQLTips.com | Category: etl
Rating: (not yet rated)  Rate this |   Briefcase | 3,121 reads

Random Word Generation for Data Scrubbing

With HIPAA and GDPR requiring your careful scrubbing of data for lower environments, random word generation promises to be a huge helper. Read here how to do it.  Read more...
By John F. Tamburo 2018/05/01 | Source: SQLServerCentral.com | Category: rand()
Rating: |  Discuss |   Briefcase | 1,019 reads

Auto-Deleting Data

Steve likes that idea of auto deleting data, especially with legislation increasing.  Read more...
By Steve Jones 2018/05/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Introduction to Azure SQL Managed Instance

Microsoft currently offers two built-in methods of running production SQL Server databases in Azure. The first relies on the ability of Infrastructure-as-a-Service (IaaS) Azure virtual machines to host a variety of on-premises workloads, including SQL Server instances. The second one leverages Platform-as-a-Service (PaaS)-based Azure SQL Database. With the introduction of the Azure SQL Managed Instance service, you have a third option, which combines the benefits of its two predecessors.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,641 reads

Self SQL Injection

Based on a real fact, this article demonstrates how a bad use of sp_executesql can lead to unpleasant surprises  Read more...
By Alessandro Mortola 2018/04/30 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,430 reads

Replication Gets Some Love

Replication gets some improvements.  Read more...
By Steve Jones 2018/04/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 47 reads

Taking Shortcuts

We don't mean to introduce security issues, but sometimes we do because we give in to pressure.  Read more...
By Steve Jones 2018/04/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 36 reads

Execution Plans and Data Protection

One of the most important tools for query tuning is ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection.  Read more...
By Additional Articles 2018/04/30 | Source: SimpleTalk | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 3,169 reads

Masking Data in Practice

This article describes the practicalities of data masking, the various methods we can use, and the potential pitfalls.  Read more...
By 2018/04/30 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,106 reads

The CDO

Does your company have a Chief Data Officer? Steve Jones doesn't think you need one to use data wisely.  Read more...
By Steve Jones 2018/04/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 40 reads

Powershell To Get Active Directory Users And Groups into SQL

Use Powershell to query AD for Users, Groups and GroupMembers  Read more...
By Lowell Izaguirre 2018/04/27 (first published: 2016/03/31) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 5,497 reads

SQL Server Closure Tables

SQL Server has a couple of different ways to represent hierarchies, but they do not allow storing any additional information that is important to the relationship between objects. In this article, Phil Factor explains how to use closure tables to overcome this deficiency.  Read more...
By Additional Articles 2018/04/27 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,437 reads

Deliver GDPR-compliant data to SQL Server teams

The GDPR makes it essential for SQL Server teams to maintain a living data catalog and to put in place controls and processes up front to protect personal data. But this doesn’t mean you need to lock your data away or slow down your development processes.   Read more...
By 2018/04/27 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,484 reads

A strategy for implementing database source control

Much has been written on the benefits of having a database under source control, though many articles are clear on “why” but conspicuously vague on “how”. In this ahis article, David Poole describes what was required of his organization's database source control solution, how they approached the challenges, and how using Redgate SQL Source Control as a template helped.   Read more...
By 2018/04/27 | Source: Redgate | Category: source control
Rating: (not yet rated)  Rate this |   Briefcase | 2,926 reads

SQL Server From .Net: Building a DataSet with Code

A basic introduction for developers about working with the DataSet object in ADO.Net to represent objects in a SQL Server database, and some of the options available.  Read more...
By Tim Wellman 2018/04/26 | Source: SQLServerCentral.com | Category: ado.net
Rating: (not yet rated) |  Discuss |   Briefcase | 290 reads

Missing Index Impact and Join Type

Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.  Read more...
By Additional Articles 2018/04/26 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 6,484 reads
<< Newer    Items 61 to 80 of 16820    Older >>