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

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

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,119 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,010 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,636 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,424 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,167 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,104 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,492 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,431 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,481 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,918 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 | 287 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,475 reads

The Last Service Pack

Is SQL Server 2016 Service Pack 2 going to be the last service pack?  Read more...
By Steve Jones 2018/04/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 54 reads

Hash Join Memory Grant Factors

Remember when that old DBA told you not to SELECT *? Erik Darling explains why.  Read more...
By Additional Articles 2018/04/26 | Source: Brent Ozar Unlimited Blog | Category: hash join
Rating: (not yet rated)  Rate this |   Briefcase | 2,530 reads

Detecting Problems on Databases that use Snapshot-based Transaction Isolation

If you’re using SQL Server’s Read Committed Snapshot Isolation level (RCSI) to avoid long waits for a blocked resource, then you’ll want to monitor for possible side effects. This article describes one way to monitor for such problems, using an alert on version_ghost_record_count, to warn us when the number of row versions in tempdb is getting very high.  Read more...
By 2018/04/26 | Source: Redgate | Category: read committed snapshot isolation
Rating: (not yet rated)  Rate this |   Briefcase | 2,177 reads

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.  Read more...
By Ben Miller 2018/04/25 (first published: 2015/12/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,738 reads
<< Newer    Items 61 to 80 of 16816    Older >>