SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2018/07/03 to 2018/07/10

Building Better Test Data with SQL Provision

Steve Jones discusses building Better Test Data with SQL Provision  Read more...
By 2018/07/10 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,466 reads

Automatic Query Performance Tuning in SQL Server Database

In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.  Read more...
By Additional Articles 2018/07/10 | Source: Database Journal | Category: performance and tuning
Rating: (not yet rated)  Rate this |   Briefcase | 4,151 reads

Ensuring Each Client has a Full Set of Key-Value Pairs

In this piece, we find out about a business issue that can occur when using key value pairs in your database to describe information about other entities.  Read more...
By Steve Jones 2018/07/10 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 565 reads

Help Redgate do a better job (and win a $250 Amazon voucher)

Could you spare a few minutes to help Redgate improve its products and services? They’re running a survey of their users and the wider SQL Server community and they’d appreciate your insights. As a thank you for taking part, you’ll also be entered in a prize draw for a $250 Amazon Voucher.   Read more...
By 2018/07/17 (first published: 2018/07/09) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 5,093 reads

Azure and Windows PowerShell: Getting Information

In the second part of his series, Nicolas Prigent describes in detail how to automate the login process using PowerShell and Azure CLI. Nicolas also explains how to retrieve information about your Azure subscription.  Read more...
By Additional Articles 2018/07/09 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,436 reads

Installing SSDT and creating your first SSIS Package

SQL Server Data Tools (SSDT) is a toolset which provides an environment for you to carry out all your database design work in SQL Server. It can be used to build to build SQL Server relational databases.   Read more...
Rating: |  Discuss |   Briefcase | 1,007 reads

Traditional database security doesn’t protect data

Alex Yates proposes that the features we think of as traditional database security are not sufficient to protect your data.  Read more...
By 2018/07/06 | Source: Redgate | Category: data security
Rating: (not yet rated)  Rate this |   Briefcase | 2,745 reads

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

Either you've got too many indexes, or not enough. Here's how to tell.  Read more...
By Additional Articles 2018/07/06 | Source: Brent Ozar Unlimited Blog | Category: sp_blitz
Rating: (not yet rated)  Rate this |   Briefcase | 2,861 reads

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.  Read more...
By David Poole 2018/07/06 (first published: 2016/01/26) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,563 reads

Using Parameters for SQL Server Queries and Stored Procedures

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.  Read more...
By Additional Articles 2018/07/05 | Source: MSSQLTips.com | Category: parameters
Rating: (not yet rated)  Rate this |   Briefcase | 3,774 reads

Creating Compound Interest Calculations in SQL

This is the first article in a short series of SQL Server query challenges to test and expand your SQL Server querying skills  Read more...
By Adam Aspin 2018/07/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,298 reads

Moving from application automation to true DevOps by including the database

There is a growing motivation, in many organizations, to integrate database changes into a DevOps process. In this article Tom Austin explains the different methods of getting the database under source control, either by storing per-object state, or migration scripts, or usually both.   Read more...
By 2018/07/05 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,670 reads

Missing Data

Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data.  Read more...
By Additional Articles 2018/07/04 | Source: SimpleTalk | Category: null
Rating: (not yet rated)  Rate this |   Briefcase | 2,449 reads

Stairway to Columnstore Indexes Level 9: Batch Mode Execution

In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.  Read more...
By Hugo Kornelis 2018/07/04 (first published: 2016/08/31) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,769 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2019/01/30 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 55,403 reads

Azure SQL Database and GDPR Compliance

In recent years, technology landscape has undergone dramatic changes, driven primarily by cloud computing and a continuously increasing level of attention dedicated to security, privacy, and compliance. One of the more significant initiatives that attempts to address these challenges is General Data Protection Regulation (GDPR. In this article, we will explore how Azure SQL Database could help with addressing the GDPR requirements.  Read more...
By Additional Articles 2018/07/03 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,292 reads

What is SQL Change Automation?

William Brewer explores the features of Redgate's SQL Change Automation  Read more...
By 2018/07/03 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 3,401 reads

Importing Tricky CSV Files with PowerShell

A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell  Read more...
By Stewart Campbell 2018/07/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,342 reads