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

Headlines today   December 1, 2015

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...
Rating: |  Discuss |   Briefcase | 2,366 reads

Doing a SQL Server Healthcheck via PowerShell

PowerShell is an ideal tool for doing health-checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed to suit circumstances. Omid Afzalalghom's Healthcheck allows tests to be SQL or PowerShell and requires only adding, altering or deleting files in directories.  Read more...
By Additional Articles 2015/12/01 | Source: SimpleTalk | Category: healthcheck
Rating:  Rate this |   Briefcase | 1,532 reads
Previous headlines

Add new disks to a SQL Server Failover Cluster on Windows 2008

This article shows the procedure to Add new disks to SQL Server failover cluster in windows 2008/2008R2. This article also covers how to add dependencies to a SQL Server cluster resource.  Read more...
By Ganapathi varma 2015/11/30 | Source: | Category: cluster
Rating: |  Discuss |   Briefcase | 920 reads

Introduction to Storage Spaces Direct for SQL Server

Glenn Berry introduces the exciting new feature in Windows Server 2016 called Storage Spaces Direct (S2D), which enables organizations to use multiple, clustered commodity file server nodes to build highly available, scalable storage systems with local storage, using SATA, SAS, or PCIe NVMe devices.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,362 reads

Your Usage of the Microsoft Data Platform

Microsoft has been rapidly extending its data offering to what is now a comprehensive “data platform” intended to provide the building blocks for customers to build and extend more complex and “intelligent” applications. Redgate are conducting research on the use and adoption of the data platform and have put together a short two-page survey. They're interested in your feedback even if you haven’t started using the data platform just yet, but have some interest in moving in that direction.  Read more...
By 2015/11/30 (first published: 2015/11/27) | Source: Redgate | Category: microsoft data platform
Rating: (not yet rated)  Rate this |   Briefcase | 2,654 reads

Stairway to SQLCLR Level 1: What is SQLCLR?

The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance.  Read more...
By Solomon Rutzky 2015/11/27 (first published: 2014/01/09) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,623 reads

Programmatically changing SQL Server linked tables in Microsoft Access

Tim Wise explains how Microsoft Access provides a quick and easy way to create a simple front end for a SQL Server database by pointing linked tables to the SQL Server.  Read more...
By Additional Articles 2015/11/27 | Source: | Category: microsoft access
Rating: (not yet rated)  Rate this |   Briefcase | 1,606 reads

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: |  Discuss |   Briefcase | 1,021 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 | 305 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Master Data Services Configuration Woes

Installing and configuring SQL Server Master Data Services (MDS) is like a box of chocolates: you never know what you’re...  Read more...
By Koen Verbeeck 2015/12/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 424 reads

Changing case of T-SQL Keywords

Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is...  Read more...
By Ed Elliott 2015/12/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,388 reads
Question of the Day

Fun with qualifiers

By Shane Estelle 2015/12/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 657 reads

What happens when you run the following? (choose 3)



"." Int IDENTITY(1,1),

"*" Int DEFAULT(2),

"%" Int DEFAULT(3),

["] Int DEFAULT(4),

"[]" Int DEFAULT(5)



SELECT [.], "*", [%], """", [[]]] FROM [[] 
Top Members (last 30 days)
# Name Score Level
30 days All-time
898 1531 SSCommitted  
Iwas Bornready
339 5956 SSCertifiable  
295 521 Mr or Mrs. 500  
Luis Cazares
267 6003 SSCertifiable  
Ed Wagner
265 7176 SSCertifiable  
Latest forum posts