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

Rss
Headlines today   November 20, 2014

Distribution Database Migration

This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.  Read more...
By Valerij Urban 2014/11/20 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 1,294 reads

Monitoring Azure SQL Database

Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.  Read more...
By Additional Articles 2014/11/20 | Source: Database Journal | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,803 reads
Previous headlines

Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.  Read more...
By Richard Waymire 2014/11/19 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 6,128 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/11/19 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating:  Rate this |   Briefcase | 42,477 reads

Where in the Application Should Data Validation be Done?

Whereabouts in the application should the business logic of data-validation checks be made? The advantages of a layered approach to validation that includes database constraints, would seem to outweigh the disadvantages.   Read more...
By Additional Articles 2014/11/19 | Source: SimpleTalk | Category: data validation
Rating: (not yet rated)  Rate this |   Briefcase | 6,341 reads

Data Mining Part 21: Excel and Data Mining,validation methods

This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.   Read more...
By Daniel Calbimonte 2014/11/18 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 2,093 reads

Removing Rows with the DELETE Statement in SQL Server

Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.  Read more...
By Additional Articles 2014/11/18 | Source: Database Journal | Category: delete rows
Rating: (not yet rated)  Rate this |   Briefcase | 7,826 reads

SQL Monitor Custom Metric: Possible Duplicate Indexes

When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.  Read more...
By Press Release 2014/11/18 | Source: Red-Gate | Category: index
Rating: (not yet rated)  Rate this |   Briefcase | 4,590 reads

SQL Overview VII - SSRS Reports and Subscriptions

In the next installment of his series on the SQL Overview toolkit, David Bird looks at the information collected about SSRS.  Read more...
By David Bird 2014/11/17 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,395 reads

SSIS 2012 Projects: Setup, Project Creation and Deployment

It used to be that SQL Server Integration Services (SSIS) packages had to be deployed individually. Now, they can be all deployed together from a single file by means of the Project Deployment Model introduced in SSIS 2012. Where there are tens or hundreds of SSIS packages to deploy, this system is essential.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,611 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

SQLCMD and SET QUOTED_IDENTIFIER

Let’s talk about something simple today. You might already be knowing this, but if you haven’t seen/noted this before then...  Read more...
By AnupWarrier 2014/11/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,537 reads

SQL Server Disaster Recovery Planning

While administrating SQL Server database, one of the important part is to prepare a plan to work against potential disasters....  Read more...
By zorastalin 2014/11/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,343 reads
Question of the Day

Odd Man Out

By Kshitij Satpute 2014/11/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,064 reads

Pick the odd one out from the given list.

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Michael J Clayton
686 742 Right there with Babe  
2.
RK Mandava
338 1871 SSCommitted  
3.
ksatpute123
283 849 SSC Eights!  
4.
ketaki25
270 1195 Ten Centuries  
5.
Koen Verbeeck
258 13511 SSChampion  
Latest forum posts