Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,882,291 DBAs, developers and SQL Server users

Headlines today   March 22, 2017

Continuous Delivery and the Development DBA

How to do database development with trunk based development and Continuous Delivery  Read more...
By Pedro Lopez 2017/03/22 | Source: | Category: continuous delivery
Rating: |  Discuss |   Briefcase | 741 reads

Follow-up #1 on leading wildcard seeks

Aaron Bertrand shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.  Read more...
By Additional Articles 2017/03/22 | Source: | Category: wildcard
Rating: (not yet rated)  Rate this |   Briefcase | 1,676 reads

Webinar: how to get started with DevOps

More and more teams are turning to DevOps as way to improve the efficiency and quality of software delivery but it’s not always clear what's the best way to get started. Redgate have invited Steve Thair, CTO of the DevOpsGuys, to share some practical tips on how you can start implementing DevOps in your organization. Register for the free webinar.  Read more...
By 2017/03/22 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,040 reads
Previous headlines

Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query

This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.  Read more...
By Stan Kulp 2017/03/21 | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 1,319 reads

TODAY: extending DevOps practices to SQL Server databases

In this free webinar later today, Steve Jones and Arneh Eskandari show how to use migration scripts as part of an automated database deployment. For the demo, they’ll be plugging Redgate’s Database DevOps solution into Git, TeamCity and Octopus Deploy.  Read more...
By 2017/03/21 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,139 reads

Core Database Source Control Concepts

Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.  Read more...
By Additional Articles 2017/03/21 | Source: SimpleTalk | Category: source control
Rating: (not yet rated)  Rate this |   Briefcase | 2,222 reads

Backups in Azure SQL Data Warehouse

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.  Read more...
By Daniel Calbimonte 2017/03/20 | Source: | Category: azure
Rating: |  Discuss |   Briefcase | 317 reads

Using Power BI in a Hybrid Environment

Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources.  Read more...
By Additional Articles 2017/03/20 | Source: Microsoft MSDN
Rating: (not yet rated)  Rate this |   Briefcase | 2,464 reads

Windowing Functions: Tell me when that changes

Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource  Read more...
By Michael Morin 2017/03/17 (first published: 2016/02/17) | Source: | Category: windows functions
Rating: |  Discuss |   Briefcase | 6,891 reads

SQL Server Bulk Insert Row Terminator Issues

We often need to import data into SQL Server from a file. Sometimes unwanted end of line characters are part of the source file and these can create issues when importing the data. One of the ways to avoid this issue is to use SQL Server Integration Services (SSIS), but it doesn't always make sense to use SSIS for simple operations. Rahul Mehta explains that he uses BULK INSERT sometimes faces issues with Line Feeds and Carriage Returns. In this post, Rahul shows some examples and explains how to fix the issue.  Read more...
By Additional Articles 2017/03/17 | Source: | Category: bulk insert
Rating: (not yet rated)  Rate this |   Briefcase | 1,984 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Using dbatools for automated restore and CHECKDB

OK, so if you haven’t heard of the project run by Chrissy LeMaire and company…you’ve likely been living under a...  Read more...
By Anthony Nocentino 2017/03/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,154 reads

Embrace The Missing Index DMVs - But Proceed with Caution!

One of the performance tools I use all of the time is the set of Missing Index DMVs: ·         sys.dm_db_missing_index_details– Detailed...  Read more...
By Andy Galbraith 2017/03/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,127 reads
Question of the Day

Start Running R Scripts

By Steve Jones 2017/03/22 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 484 reads

I want to start running R scripts in my SQL Server 2016 instance. What do I need to do in order to execute an R script after I've installed the...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
15170 69506 SSC Guru  
Jeff Moden
13765 65468 SSC Guru  
Steve Jones - SSC Editor
8172 48646 SSC-Forever  
5596 23190 SSC-Insane  
Lynn Pettis
5190 31690 SSC-Dedicated  
Latest forum posts