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

Rss
Headlines today   September 18, 2014

Data Mining Part 17: Working with Reports

In this chapter, we will learn how to create Data Mining Reports using Reporting Services.  Read more...
By Daniel Calbimonte 2014/09/18 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 1,955 reads

Azure Virtual Machines Part 0: A VM Primer

Mike Martin kicks off his series on Azure Virtual Machines with a primer, full of background and terms. To fully understand the Azure Virtual Machines offering, Mike explains how everything is connected and co-existing.   Read more...
By Additional Articles 2014/09/18 | Source: Just Azure | Category: azure
Rating:  Rate this |   Briefcase | 3,209 reads
Previous headlines

Stairway to PowerPivot and DAX - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating arithmetic means within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/09/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,417 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2014/09/17 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating:  Rate this |   Briefcase | 31,706 reads

The Mindset of the Enterprise DBA: Harnessing the Power of Automation

After you have done the necessary groundwork of standardising and centralising your database adminstration processes, you are now in a position to implement some effective automation of some of these processes. Which ones do you choose, and how do you set about automating these tasks?  Read more...
By Additional Articles 2014/09/17 | Source: SimpleTalk | Category: dba skills
Rating: (not yet rated)  Rate this |   Briefcase | 4,588 reads

The Ins and outs of In-Memory OLTP

As you may know, SQL Server is a very robust database, but SQL server has its performance bottlenecks. With the introduction of In-Line memory OLTP, there is a chance to get rid of the performance bottlenecks   Read more...
By Roy Ernest 2014/09/16 | Source: SQLServerCentral.com | Category: microsoft sql server
Rating: |  Discuss |   Briefcase | 4,285 reads

Comparing SQL Server Datatypes, Size and Performance for Storing Numbers

When more than one numeric SQL Server data type may be suitable for a field in a project, which data type should you choose and what are the implications for SQL Server performance?  Read more...
By Additional Articles 2014/09/16 | Source: MSSQLTips.com | Category: datatypes
Rating: (not yet rated)  Rate this |   Briefcase | 5,574 reads

SQL Monitor Custom Metric: Last backup size

Backups are at the heart of the activities of any DBA. You have to restore the backup to know it is good, but you can get an early alert that something is wrong if your backup size changes rapidly or unexpectedly in a short period of time.  Read more...
By 2014/09/16 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 4,077 reads

Another Way to Look at Trees

An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.  Read more...
By Larry Schmidt 2014/09/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 5,039 reads

Who Broke the Build?

Continuous Integration and automatic builds are fantastic tools for software teams, but only if developers take responsibility for their code. Karsten Kempe explains how to use Team Foundation Server to drive better continuous integration, and walks through a simple open-source tool he built to make nightly builds more transparent, and more valuable.  Read more...
By Additional Articles 2014/09/15 | Source: SimpleTalk | Category: continuous integration
Rating: (not yet rated)  Rate this |   Briefcase | 4,772 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

SQL Saturday #315 - Pittsburgh

SQLSaturday is a full day FREE training event for SQL Server professionals and those wanting to learn more about SQL Server and network with the SQL Server...  Read more...
By SQLSandwiches 2014/09/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,485 reads

What are trace flags?

Trace flags are one of those things that I’ve heard about more and more over the last five or six...  Read more...
By Kenneth Fisher 2014/09/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,070 reads
Question of the Day

Parameters may improve SQL Backup Performance in SQL Server 2008

By Sourav Mukherjee 2014/09/18 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 874 reads

As a DBA I'm asked to improve the SQL Server backup performance by decreasing the duration of the backup. The SQL Server version is 2008 and it's the 64 bit...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
ketaki25
612 612 SSChasing Mays  
2.
cruice
535 1223 Ten Centuries  
3.
crussell-931424
489 2935 SSCrazy  
4.
Eirikur Eiriksson
454 1978 SSCommitted  
5.
don1 76084
360 361 Old Hand  
Latest forum posts