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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,898,794 DBAs, developers and SQL Server users

Headlines today   March 23, 2018

Getting query text from SSMS into a CSV with PowerShell

You have times where you need to copy/paste something out of SSMS' grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers a tidbit of PowerShell code to help.  Read more...
By Shawn Melton 2018/03/23 (first published: 2015/09/07) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 5,290 reads

Thinking about microservices? You need DevOps first

With the rise of new virtualization technologies using containers, people are starting to think more and more about using microservices in their organizations. They’ve been getting a lot of attention and companies like Netflix, Amazon, Uber, and Spotify have attributed some of their recent success to using them.   Read more...
By 2018/03/23 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,267 reads

Scripting the Description of Database Tables Using Extended Properties

Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and a CREATE or ALTER script contains everything to reproduce the proc. SQL Server tables, however, are more difficult to document. You can use Extended Properties to document columns and constraints, but working with Extended Properties is difficult at best. Phil Factor demonstrates ways to easily add Extended Properties to your build scripts.  Read more...
By Additional Articles 2018/03/23 | Source: SimpleTalk | Category: extended properties
Rating: (not yet rated)  Rate this |   Briefcase | 1,306 reads
Previous headlines

The DefaultBufferMaxRows and DefaultBufferSize Properties in SSIS

This article shows how DefaultBufferMaxRows and DefaultBufferSize properties can be used to improve dataflow task performance.  Read more...
By SPT 2018/03/22 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 491 reads

How to Get a Random Row from a Large Table

Brent Ozar takes a look at four different ways to get a random row from a large SQL Server table.  Read more...
By Additional Articles 2018/03/22 | Source: Brent Ozar Unlimited Blog | Category: random data
Rating:  Rate this |   Briefcase | 2,824 reads

5 Minutes with Fritchey

For quick information on various aspects of the Microsoft Data Platform and Redgate software, look no further than Grant Fritchey's Youtube channel. In addition to all the technical content, he also editorializes on various aspects of data and all things IT.  Read more...
By 2018/03/22 | Category: video
Rating:  Rate this |   Briefcase | 1,614 reads

Registration is now open for Redgate's SQL Privacy Summit

The SQL Privacy Summit takes place on May 18, in London, and is an exclusive conference for senior IT data managers, responsible for data privacy and protection of SQL Server databases. You'll learn how Redgate's solutions help to ensure the ongoing protection of personally identifiable information (PII) in SQL Server, so that you can protect your business and comply with data privacy regulations such as the GDPR.   Read more...
By 2018/03/22 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 1,003 reads

Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.  Read more...
By 2018/03/21 (first published: 2015/03/18) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,608 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2018/03/21 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 92,945 reads

Charles Bachman and Pointer Chains

Joe Celko reminisces about the origins of databases and one of the early pioneers, Charles Bachman. He explains how pointer chains were used to traverse data in the NDL standard and referential integrity that we use today.  Read more...
By Additional Articles 2018/03/21 | Source: SimpleTalk | Category: history
Rating:  Rate this |   Briefcase | 1,648 reads

From the SQLServerCentral Blogs

Allowing Azure Service to Connect to your Azure SQL server.

Allowing Azure Service to Connect to your Azure SQL server. In this video David will look at the impact of allowing...  Read more...
By David Postlethwaite 2018/03/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,217 reads

T-SQL Tuesday #100: What’s New With Scalability Groups in SQL Server 2026

Welcome to T-SQL Tuesday #100. In a community filled with ADD people like the SQL community (myself included), who would...  Read more...
By Robert Davis 2018/03/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,549 reads
Question of the Day

CDC and Restores

By Steve Jones 2018/03/23 | Category: change data capture (cdc)
Rating: (not yet rated) |  Discuss |   Briefcase | 364 reads

I had someone delete all the data in a table of my Sales database. This database has CDC enabled inside of it. If I restore a full backup of this...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
40642 630728 SSC Guru  
Jeff Moden
36853 580136 SSC Guru  
Steve Jones - SSC Editor
23359 374907 SSC Guru  
Grant Fritchey
17901 256728 SSC Guru  
Lynn Pettis
16251 256112 SSC Guru  
Latest forum posts