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

Rss
Headlines today   April 17, 2014

XML Schema validation in SQL Server

An introduction to the XML Schema Collection and XML validation.  Read more...
By Eirikur Eiriksson 2014/04/17 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 1,324 reads

Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS

The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.  Read more...
By Additional Articles 2014/04/17 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 630 reads

Call for participants in deployment process research

The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.  Read more...
By Press Release 2014/04/17 | Source: SimpleTalk | Category: research
Rating: (not yet rated)  Rate this |   Briefcase | 697 reads
Previous headlines

Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

Security is a confusing topic to many, especially when it comes to understanding what rights are needed to monitor and use SQL Server Agent. This article will examine the rights and roles used for SQL Server Agent, as well as the security context requirements for jobs.  Read more...
By Richard Waymire 2014/04/16 (first published: 2012/01/11) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,341 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/04/16 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 13,896 reads

SQL Server 2014 In-Memory OLTP Dynamic Management Views

Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables.  Read more...
By Additional Articles 2014/04/16 | Source: Database Journal | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 1,722 reads

Why every SQL Server installation should be a cluster

In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).  Read more...
By Francis Apel 2014/04/15 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 7,551 reads

SQL Server Backup Crib Sheet

Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. It returns, newly revised for SQL Server 2014.  Read more...
By Additional Articles 2014/04/15 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 3,637 reads

SQL Monitor Custom Metric: Table size (MB)

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes. If a database is growing quickly within a short time and you suspect a certain table is responsible, you can monitor its actual size, or the rate at which it is increasing.  Read more...
By Press Release 2014/04/15 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 671 reads

SQL Server 2014 Key Features and Enhancements

SQL Server 2014 comes with a set of enhancements as compared to its processors that brings a lot of business benefits to the applications in OLTP and OLAP environments. This articles highlights a few key enhancements that are built into the product.  Read more...
By Suresh Yaram 2014/04/14 | Source: SQLServerCentral.com | Category: in-memory option
Rating: |  Discuss |   Briefcase | 9,172 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

The One Million Row T-SQL Test Harness

So far in our blogs, we have talked a bit about performance, but today we’re going to show you a...  Read more...
By Dwain Camps 2014/04/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 866 reads
Question of the Day

Buffer Pool Extensions

By Steve Jones 2014/04/17 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 500 reads

What is the buffer pool extension in SQL Server 2014?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
MyDoggieJessie
510 3729 Hall of Fame  
2.
mgsbalaji
474 474 SSC-Addicted  
3.
jcb
414 2636 SSCrazy  
4.
scssekar
388 402 SSC-Addicted  
5.
gstarsaini
373 401 SSC-Addicted  
Latest forum posts