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,749 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,679 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,272 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,512 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,165 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 | 937 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,854 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,372 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,490 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,510 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 | 4,024 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,132 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,172 reads
Question of the Day

Execution Plan reuse

By Steve Jones 2014/12/17 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 934 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.
DonlSimpson
332 1378 Ten Centuries  
3.
SQLexplorer
318 981 SSC Eights!  
4.
sebmr2
282 725 Right there with Babe  
5.
Jeff Moden
259 35769 SSC-Dedicated  
Latest forum posts