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,729 DBAs, developers and SQL Server users

Headlines today   March 30, 2017

Performaing a Right and Comprehensive Age Calculation Part 2

Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.  Read more...
By Sergiy Floka 2017/03/30 | Source: | Category: age calculation
Rating: |  Discuss |   Briefcase | 202 reads

What's New in Master Data Services MDS 2016 - Part 1

SQL Server 2016 introduced many new features and improvements for all its products, and Master Data Services (MDS) is no exception. In this post, Koen Verbeeck gives a comprehensive overview of all the new MDS features.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 575 reads

Audit and compliance survey with prize draw

The Foundry team at Redgate have been investigating how different regulations impact work with SQL Server. They understand the many regulations, but need your help to get a better idea of all the related activities. How has your experience with auditing and compliance been in the past? Fill out this short survey to let the team know, and in return you'll be entered into a draw to win a $100 Amazon gift card.  Read more...
By 2017/03/30 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 313 reads
Previous headlines

Justify the Remote access requirement for Biztalk Log Shipping

This article will show why there is a need for remote access with a Biztalk server that uses log shipping.  Read more...
By Bilal Ayub 2017/03/29 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 217 reads

Handling Graphs in SQL

Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are graphs in which attributes can be associated with the nodes and edges. It is a natural way to study relationships within the data. SQL databases aren't the easiest way of doing it, but it makes sense where the scale permits it. Because of the range of graphs and techniques, some Graph theory is unavoidable before you get stuck into the code, and who better to introduce graph databases than Joe Celko?  Read more...
By Additional Articles 2017/03/29 | Source: SimpleTalk | Category: graphs
Rating: (not yet rated)  Rate this |   Briefcase | 2,621 reads

Performing a Right and Comprehensive Age Calculation

Age calculation based on the right method used in real life.   Read more...
By Sergiy Floka 2017/03/28 | Source: | Category: datetime conversions
Rating: |  Discuss |   Briefcase | 1,339 reads

Who Changed My Database Schema?

Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.  Read more...
By Additional Articles 2017/03/28 | Source: Database Journal | Category: schema
Rating:  Rate this |   Briefcase | 2,896 reads

Create reports in Azure SQL Data Warehouse using SSRSS

In this article, we will show how to create reports in ASDW using SSRS  Read more...
By Daniel Calbimonte 2017/03/27 | Source: | Category: azure
Rating: |  Discuss |   Briefcase | 530 reads

Using AT TIME ZONE to fix an old report

Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.  Read more...
By Additional Articles 2017/03/27 | Source: | Category: at time zone
Rating: (not yet rated)  Rate this |   Briefcase | 2,352 reads

The Mysterious Case of the Missing Default Value

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.  Read more...
By Raul Gonzalez @SQLDoubleG 2017/03/24 (first published: 2015/12/01) | Source: | Category: sql server internal storage
Rating: |  Discuss |   Briefcase | 5,392 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Basics of Probability

In this post am going to introduce into some of the basic principles of probability – and use it in other posts...  Read more...
By Mala Mahadevan 2017/03/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 409 reads

Check Those Settings

Recently, I was tasked with “enhancing” a third party application.  This third party application (TPA) outputs a bunch of files...  Read more...
By Angela Henry 2017/03/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 481 reads
Question of the Day

Stored procedure parameters

By Igor Micev 2017/03/30 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 240 reads

What is true about stored procedure parameters? (choose 2)

Top Members (last 30 days)
# Name Score Level
30 days All-time
16438 75421 SSC Guru  
Jeff Moden
15837 71691 SSC Guru  
Steve Jones - SSC Editor
9692 52356 SSC Guru  
Grant Fritchey
9166 30032 SSC-Dedicated  
Lynn Pettis
6300 34170 SSC-Dedicated  
Latest forum posts