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

   Items 1 to 20 of 15154    Older >>

Database Nonsense - Unstructured Data

Sloppy terminology leads to big misunderstandings. Terms don't get much sloppier than "Unstructured data".  Read more...
By Don Peterson 2016/10/25 | Source: | Category: unstructured data
Rating: |  Discuss |   Briefcase | 47 reads

Managing Registered servers with SQL Powershell

Learn how to generate Registered Servers with PowerShell in this article.  Read more...
By Arco Scheepen 2016/10/25 | Source: | Category: registered servers
Rating: (not yet rated) |  Discuss |   Briefcase | 577 reads

Master Data Services – The Basics

Master Data Services (MDS) is Microsoft's platform for supporting Master Data Management (MDM). A system like MDS, if properly maintained, gives organisations a powerful alternative to increasingly having to centralize databases as a way of preventing data from getting out sync or become inconsistent, and a reliable way of managing the flow of data through corporate IT systems. It makes microservice architectures realistic. Hari Yadav shows you how to get up and running with MDS.  Read more...
By Additional Articles 2016/10/25 | Source: SimpleTalk | Category: master data services (mds)
Rating: (not yet rated)  Rate this |   Briefcase | 1,970 reads

EzAdo - Part 1

EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.  Read more...
By Alan Hyneman 2016/10/24 | Source: | Category:
Rating: |  Discuss |   Briefcase | 1,175 reads

Clownpocalypse and DR

Today we have a guest editorial as Steve is out of town at the PASS Summit. Grant looks at disasters and being prepared.  Read more...
By Grant Fritchey 2016/10/24 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

Who is that masked man anyway?

By William Brewer 2016/10/24 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

The Sort that Spills to Level 15,000

Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations.  Read more...
By Additional Articles 2016/10/24 | Source: | Category: sort
Rating:  Rate this |   Briefcase | 1,651 reads

Redgate DLM Demo Webinar

Watch the recording of our latest DLM Demo webinar and learn how to improve your database change management process. See how Redgate DLM plugs into Git, Jenkins & Octopus Deploy so that you can automate your database changes alongside your application code.  Read more...
By 2016/10/24 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,385 reads

Your Technology Budget

How much do you love technology? Is this reflected in a budget? Let us know this week.  Read more...
By Steve Jones 2016/10/21 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 reads

JSON Select - Easily query values from JSON

Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+  Read more...
By Joshua Healy 2016/10/21 (first published: 2015/08/31) | Source: | Category: json
Rating: |  Discuss |   Briefcase | 11,847 reads

SQL Server 2014 Build List

A list of builds for SQL Server 2014, through CU9 for SP1.  Read more...
By Steve Jones 2016/10/21 (first published: 2015/02/23) | Source: | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 5,789 reads

Memory/Storage Technology Hierarchy and SQL Server

Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.  Read more...
By Additional Articles 2016/10/21 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 3,482 reads

Where Do You Run Your R Scripts?

Executing R scripts can be a heavy load. Today Steve Jones wonders if SQL Server is the best place to execute these.  Read more...
By Steve Jones 2016/10/20 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 56 reads

Basic Data Manipulation for Relational Data in R

In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.   Read more...
By Mala Mahadevan 2016/10/20 | Source: | Category: r programming
Rating: |  Discuss |   Briefcase | 1,003 reads

SQLServerCentral team in Seattle

The team behind will be in Seattle at the PASS Summit next week, and we’d like to hear from you. If you’re heading to the event, we’d love to get feedback on how you use the site, and hear about any changes you’d like to see. If you’d be willing to have a quick chat, please email us, and we’ll set up some time with Steve and the team.  Read more...
By 2016/10/20 | Source: | Category: pass summit
Rating: (not yet rated) |  Discuss |   Briefcase | 1,711 reads

Getting started with Query Store feature in SQL Server 2016 – Part 3

Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS.  Read more...
By Additional Articles 2016/10/20 | Source: Database Journal | Category: query store
Rating: (not yet rated)  Rate this |   Briefcase | 3,128 reads

One Million

The number one million has special meaning to many people. And it's a heck of a metric to achieve in a measurement on a database system.  Read more...
By Steve Jones 2016/10/19 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 58 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 2016/10/19 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 77,926 reads

Join Redgate at PASS Summit 2016

This year Redgate have a breakout session featuring SQL Clone, as well as a booth in the exhibit hall. They'll be giving away all sorts of prizes including SQL-themed playing cards, flying sheep, and a year's worth of the world's strongest coffee! To find out the details of what they'll be up to between October 25 - 28, and to find out how you can attend the exclusive #RedgateRocks party, read this blog post.  Read more...
By 2016/10/19 | Source: Redgate | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 1,372 reads
   Items 1 to 20 of 15154    Older >>