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

Previous headlines

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,321 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,464 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,454 reads

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 | 497 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,906 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,693 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,044 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,618 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,980 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,710 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 | 380 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
40734 631580 SSC Guru  
Jeff Moden
36983 580932 SSC Guru  
Steve Jones - SSC Editor
23512 375438 SSC Guru  
Grant Fritchey
18069 257092 SSC Guru  
Lynn Pettis
16271 256436 SSC Guru  
Latest forum posts