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

Headlines today   December 17, 2014

Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.  Read more...
By Gregory Larsen 2014/12/17 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,616 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2014/12/17 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 42,141 reads

Introduction to Azure SQL Database Scalability

One of the primary advantages of Platform-as-a-Service solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,431 reads
Previous headlines

What To Do When the Import and Export Wizard Fails - Part II Exports

This article will discuss a case study of utilizing a SSIS package to export a table that has columns with data type varchar(mx) and text to an Excel file.   Read more...
Rating: |  Discuss |   Briefcase | 2,156 reads

Tribal Awards Finalists

Voting is now open for the Tribal Awards. Vote for one of the 5 finalists in each category to win a fabulous* prize.   Read more...
By Press Release 2014/12/16 | Source: | Category: awards
Rating: |  Discuss |   Briefcase | 933 reads

SQL Server Reporting Services Basics: The Visual Controls

Kathi Kellenberger demonstrates how to start adding visual flair to your SSRS reports, using its impressive set of visual controls, ranging from basic charts to gauges, indicators, sparklines, and maps.  Read more...
By Additional Articles 2014/12/16 | Source: SimpleTalk | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 3,837 reads

Adding a Query Governor to Dynamic-Search Stored Procedures

When undisciplined users access your search forms, you can control their behavior and limit the results they're presented with in various ways.  Read more...
By Dwain Camps 2014/12/15 | Source: | Category: dynamic search
Rating: |  Discuss |   Briefcase | 3,361 reads

Debugging Natively-Compiled Stored Procedures Statements

Considering that SQL Server 2014 Natively Compiled Stored Procedures are compiled into binary code, you may have asked yourself if it's possible to monitor statement execution. In this tip Daniel Farina explains how you can monitor SQL Server Natively Compiled Stored Procedures.  Read more...
By Additional Articles 2014/12/15 | Source: | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 4,472 reads

What, when and who? Auditing 101 - Part 2

In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.   Read more...
By Roy Ernest 2014/12/12 (first published: 2012/01/16) | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 11,505 reads

Finding SQL Server views with (or without) a certain property

In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.  Read more...
By Additional Articles 2014/12/12 | Source: | Category: views
Rating: (not yet rated)  Rate this |   Briefcase | 3,998 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Server Database Corruption Reasons and Recovery Solution

When database corruption occurs and found to have happened, there is a specific order in which operations are performed to...  Read more...
By zorastalin 2014/12/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,059 reads

Exam Prep 70-463: SSIS Connection Managers

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...  Read more...
By Colleen M. Morrow 2014/12/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,102 reads
Question of the Day

Execution Plan reuse

By Steve Jones 2014/12/17 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 907 reads

Which of these invalidate a query plan and case a query to be recompiled? (choose 3)

Top Members (last 30 days)
# Name Score Level
30 days All-time
Shiva N
482 902 SSC Eights!  
332 1378 Ten Centuries  
318 981 SSC Eights!  
282 725 Right there with Babe  
Jeff Moden
258 35768 SSC-Dedicated  
Latest forum posts