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

Rss
Headlines today   April 16, 2014

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,083 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,695 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,496 reads
Previous headlines

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,335 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,460 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 | 617 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 | 8,983 reads

SQL Server Reporting Services Embedding .NET Code for Report Formatting and Error Handling

I want to embed code into my SQL Server Reporting Servers (SSRS) to allow special formatting for report output. How do I implement and deploy this code and what functionality can use this embedded code?  Read more...
By Additional Articles 2014/04/14 | Source: MSSQLTips.com | Category: error handling
Rating: (not yet rated)  Rate this |   Briefcase | 2,415 reads

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 11,300 reads

The DBA Detective: Disturbing Developments

Originally one of the articles in the first DBA Team series, Grant wonders what Raymond Chandler or Dashiell Hammett would have done if asked to write technical articles for Simple-Talk. He came up with the DBA detective, hard-boiled Joe Dee Beay.  Read more...
By Additional Articles 2014/04/11 | Source: SimpleTalk | Category: database administrator
Rating:  Rate this |   Briefcase | 2,506 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

SSIS Performance Testing

I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I...  Read more...
By Koen Verbeeck 2014/04/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,166 reads
Question of the Day

Memory-Optimized Table editions

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

In what editions of SQL Server 2014 are memory-optimized tables available? 

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
MyDoggieJessie
511 3729 Hall of Fame  
2.
mgsbalaji
474 474 SSC-Addicted  
3.
jcb
377 2599 SSCrazy  
4.
gstarsaini
373 401 SSC-Addicted  
5.
scssekar
373 387 Old Hand  
Latest forum posts