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

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 | 14,642 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,272 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/27 | Source: Redgate | Category: microsoft data platform
Rating: (not yet rated)  Rate this |   Briefcase | 1,749 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 | 790 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 | 266 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,210 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,074 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,841 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 | 13,084 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,775 reads
Ask SQL Server Central

Question of the Day

DDL Trigger Execution

By Steve Jones 2015/11/27 | Category: ddl triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 544 reads

Can I write a DDL Trigger that reacts to the creation of a temporary table?

Top Members (last 30 days)
# Name Score Level
30 days All-time
841 1474 Ten Centuries  
330 521 Mr or Mrs. 500  
Iwas Bornready
304 5921 SSCertifiable  
261 5864 SSCertifiable  
Jeff Moden
257 38978 SSC-Dedicated  
Latest forum posts