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

Rss
Headlines today   March 29, 2017

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 | 212 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,487 reads
Previous headlines

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,287 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,810 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 | 527 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,278 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,389 reads

Encrypting SQL Server: Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,982 reads

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 660 reads

Getting Started with Azure SQL Data Warehouse - Part 2

Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,657 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

SQL Server Query Store

Query Store was, probably without doubt, the most anticipated and talked out new feature in SQL 2016. Certainly by the...  Read more...
By matthew.mcgiffen 73574 2017/03/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,360 reads

Restoring an entire SQL Server user databases with PowerShell using dbatools

All the good DBAs backup their databases. A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so. This...  Read more...
By Rob Sewell 2017/03/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,078 reads
Question of the Day

Basic R language mathematics

By Steve Jones 2017/03/29 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 515 reads

I am learning to work with the R language and want to calculate the product of 6 * 7. How do I do this at an R language prompt?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
16596 75355 SSC Guru  
2.
Jeff Moden
15942 71596 SSC Guru  
3.
Steve Jones - SSC Editor
9694 52252 SSC Guru  
4.
Grant Fritchey
9218 30007 SSC-Dedicated  
5.
Lynn Pettis
6346 34146 SSC-Dedicated  
Latest forum posts