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

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

“But I don’t need to back up that database.”

Brent Ozar shares four stories of people who thought they could avoid backups - and got burned.  Read more...
By Additional Articles 2018/05/04 | Source: Brent Ozar Unlimited Blog | Category: backups
Rating:  Rate this |   Briefcase | 4,003 reads

Avoid use of the MONEY and SMALLMONEY datatypes

One of SQL Prompt's code analysis recommendations is that you avoid using the MONEY and SMALLMONEY datatypes - this article from Phil Factor explains why.  Read more...
By 2018/05/04 | Source: Redgate | Category: code analysis
Rating:  Rate this |   Briefcase | 4,313 reads

Scripting Objects with PowerShell

In the third installment of this series, Steve Jones uses PowerShell to source control code.  Read more...
By Steve Jones 2018/05/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 813 reads

150 SQL Code Smells

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. SQL Prompt is committed to cover as many as possible of them. Phil has also updated his book, which is free to download.  Read more...
By Additional Articles 2018/05/03 | Source: SimpleTalk | Category: code smells
Rating: (not yet rated)  Rate this |   Briefcase | 5,687 reads

Reasons to Upgrade

There are always reasons to upgrade or avoid upgrading to a new version. Steve Jones has a few thoughts.  Read more...
By Steve Jones 2018/05/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

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 | 985 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,046 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,123 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,022 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,645 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,432 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,170 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,108 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,500 reads
<< Newer    Items 61 to 80 of 16825    Older >>