Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,769,661 DBAs, developers and SQL Server users

Rss
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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,174 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 | 41,351 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 | 2,815 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,100 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: SQLServerCentral.com | Category: awards
Rating: |  Discuss |   Briefcase | 913 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,669 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: SQLServerCentral.com | Category: dynamic search
Rating: |  Discuss |   Briefcase | 3,324 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: MSSQLTips.com | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 4,274 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: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 11,481 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: MSSQLTips.com | Category: views
Rating: (not yet rated)  Rate this |   Briefcase | 3,912 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 | 2,585 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 | 3,621 reads
Question of the Day

Execution Plan reuse

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

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

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Shiva N
482 902 SSC Eights!  
2.
SQLexplorer
318 981 SSC Eights!  
3.
DonlSimpson
296 1342 Ten Centuries  
4.
sebmr2
270 713 SSChasing Mays  
5.
Jeff Moden
263 35766 SSC-Dedicated  
Latest forum posts