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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,900,190 DBAs, developers and SQL Server users

Headlines today   April 26, 2018

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: indexes
Rating: (not yet rated)  Rate this |   Briefcase | 285 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 | 7 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 | 195 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 | 192 reads
Previous headlines

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,501 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 2018/04/25 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 46,543 reads

SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database

Modifying data in Graph Database tables is similar to working with traditional tables, but there are several things to consider. Robert Sheldon explains how to insert, update, and delete rows of Graph Database tables and explains how to use several new helper functions.  Read more...
By Additional Articles 2018/04/25 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 1,346 reads

Shift LEFT magazine: Issue 3

The latest issue of Redgate’s Database DevOps magazine explores the benefits of DevOps for CEOs, CIOs, and IT Managers, and takes a comprehensive look at the new General Data Protection Regulation, providing a valuable insight into how organizations can meet its demands.  Read more...
By 2018/04/25 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,316 reads

Packaged-Application Database Nightmares - A Horror Story

The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?  Read more...
By John F. Tamburo 2018/04/24 (first published: 2015/12/22) | Source: SQLServerCentral.com | Category: packaged applications
Rating: |  Discuss |   Briefcase | 5,097 reads

Approaches to masking email addresses

There are several ways to to anonymize / pseudonymize email addresses. This post discusses a few frequently used approaches, as well as how you can use Redgate Data Masker for SQL Server to achieve realistic masking of email columns.  Read more...
By 2018/04/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,927 reads

From the SQLServerCentral Blogs

Execution Plan Shortcoming in Extended Events

I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for...  Read more...
By Grant Fritchey 2018/04/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 176 reads

RDS encryption vs TDE

If you’re starting to use cloud services, the number of options available can be confusing. Particularly when they may seem...  Read more...
By Matthew McGiffen 2018/04/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 172 reads
Question of the Day

Machine Learning Users

By Steve Jones 2018/04/26 | Category: machine learning services (mls)
Rating: (not yet rated) |  Discuss |   Briefcase | 84 reads

When you install SQL Server 2017 Machine Learning Services with R and Python, how many new users are added to SQL Server by default?

Latest forum posts