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

Headlines today   November 27, 2015

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,187 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 | 987 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,217 reads
Previous headlines

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 | 722 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 | 250 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,034 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 | 2,979 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,820 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,975 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,614 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SSDT DevPack - Highlight expensive queries

When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...  Read more...
By Ed Elliott 2015/11/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 685 reads

Using multiple log files

The transaction log is made up of one or more files that are used sequentially. So in other words if...  Read more...
By Kenneth Fisher 2015/11/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 595 reads
Question of the Day

DDL Trigger Execution

By Steve Jones 2015/11/27 | Category: ddl triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 454 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
1162 1474 Ten Centuries  
351 521 Mr or Mrs. 500  
Iwas Bornready
315 5921 SSCertifiable  
313 5864 SSCertifiable  
Luis Cazares
269 5978 SSCertifiable  
Latest forum posts