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

Headlines today   November 30, 2015

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 | 774 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,164 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,488 reads
Previous headlines

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,465 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,521 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 | 952 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 | 294 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 | 1,431 reads

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 | 3,332 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Calculating Table Partition Sizes in Advance

Continuing on with my Partitioning post series, this is part 7. The partitioning includes several major components of work (and can...  Read more...
By Rolf Tesmer (Mr. Fox SQL) 2015/11/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 537 reads

Why Should Data Professionals Automate?

Take a minute and look around you. Automation is all around you; whether you see it or not processes are...  Read more...
By CYates 2015/11/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 804 reads
Question of the Day

Join operators, part 2 - limitations

By Hugo Kornelis 2015/11/30 | Category: execution plans
Rating: (not yet rated) |  Discuss |   Briefcase | 649 reads

In SQL Server execution plans, three different physical operators can be used to perform join operations: Hash Match, Merge Join, and Nested Loops. They each have their own limitations. Let's...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
871 1504 SSCommitted  
Iwas Bornready
327 5944 SSCertifiable  
303 521 Mr or Mrs. 500  
Luis Cazares
264 6000 SSCertifiable  
261 5864 SSCertifiable  
Latest forum posts