Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,841,855 DBAs, developers and SQL Server users

Headlines today   November 26, 2015

Data Mining Part 33: The Performance counters

In this new article, we will explain how to use the Performance Counter to measure performance and activity in Microsoft Data Mining  Read more...
By Daniel Calbimonte 2015/11/26 | Source: | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 339 reads

SQL Server Luxembourg - SQL Azure

The SQL Server Luxembourg User Group invites you to join us at our next event, where Pieter Vanhove from Microsoft will be presenting a double bill: Microsoft Azure SQL Database at Your Service and Run Your DBA Morning Checklist with Policy-Based Management.  Read more...
By Press Release 2015/11/26 | Source: | Category: azure
Rating: |  Discuss |   Briefcase | 138 reads

Routine SQL DML Testing for the Unenthusiastic Tester

There are more exciting things in life than unit testing SQL Statements, checking the results, timings, and execution plans. Phil Factor demonstrates a PowerShell-based technique taking the tedium out of testing SQL DML.  Read more...
By Additional Articles 2015/11/26 | Source: SimpleTalk | Category: dml
Rating: (not yet rated)  Rate this |   Briefcase | 546 reads
Previous headlines

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.  Read more...
By Gregory Larsen 2015/11/25 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,770 reads

SQL Prompt Tips #7 - Begin End Highlighting

This SQL Prompt tip shows you how code highlighting makes it easier to find which items match up with each other.  Read more...
By Steve Jones 2015/11/25 (first published: 2015/01/26) | Source: | Category: sql prompt
Rating: |  Discuss |   Briefcase | 2,772 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2015/11/25 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 12,770 reads


Sandeep Mittal provides an introduction to the COALESCE function and shows how to use it.  Read more...
By Additional Articles 2015/11/25 | Source: | Category: coalesce
Rating: (not yet rated)  Rate this |   Briefcase | 2,338 reads

Hadoop many flavors of SQL

What are the most popular SQL implementations for Hadoop? How different are they from T-SQL?  Read more...
By Daniel Klionsky 2015/11/24 | Source: | Category: big data
Rating: |  Discuss |   Briefcase | 3,606 reads

Azure SQL Database - Transparent Data Encryption

Transparent Data Encryption offers the ability to encrypt content of the database, its transaction logs, as well as backups while at rest. Encryption and decryption are performed in real-time, at the individual page level, as the database is being written to and read from storage, without necessitating changes to applications accessing their data. Marcin Policht reviews the feature.  Read more...
By Additional Articles 2015/11/24 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,129 reads

Getting ready for Hadoop

Before adopting Hadoop into your organisation there are a number of factors to consider. This article highlights some of the key points.  Read more...
By David Poole 2015/11/23 | Source: | Category: hadoop
Rating: |  Discuss |   Briefcase | 4,604 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Print Long String

Quite often, I output information through PRINT command. It works well only when message is shorter than 8000 bytes. When...  Read more...
By john_wong_ca 2015/11/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 488 reads
Question of the Day

Happy Thanksgiving 2015

By Steve Jones 2015/11/26 | Category: humor
Rating: (not yet rated) |  Discuss |   Briefcase | 317 reads

Which of these queries will calculate Thanksgiving in the US for any date in the last 100 years? Assume you have US region settings for your instance.

SELECT... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
1138 1450 Ten Centuries  
351 521 Mr or Mrs. 500  
327 5860 SSCertifiable  
Iwas Bornready
323 5921 SSCertifiable  
Luis Cazares
279 5977 SSCertifiable  
Latest forum posts