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

Welcome to SQLServerCentral.com

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

Rss
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: SQLServerCentral.com | Category: age calculation
Rating: |  Discuss |   Briefcase | 633 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 | 1,361 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 | 623 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: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 231 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,841 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: SQLServerCentral.com | Category: datetime conversions
Rating: |  Discuss |   Briefcase | 1,436 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 | 3,068 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: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 544 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: SQLPerformance.com | Category: at time zone
Rating: (not yet rated)  Rate this |   Briefcase | 2,498 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: SQLServerCentral.com | Category: sql server internal storage
Rating: |  Discuss |   Briefcase | 5,409 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 | 1,063 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 | 1,057 reads
Question of the Day

Stored procedure parameters

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

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

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
16065 75570 SSC Guru  
2.
Jeff Moden
15500 71845 SSC Guru  
3.
Steve Jones - SSC Editor
9633 52508 SSC Guru  
4.
Grant Fritchey
9061 30107 SSC-Dedicated  
5.
Lynn Pettis
6226 34241 SSC-Dedicated  
Latest forum posts