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

Rss Show more
Previous headlines

The Job Posting - Do I really have to be the SQL God?

Looking for a job in the SQL Server industry can be a challenge for many people. Craig Farrell examines part of this process in his look at job postings and how you can interpret them.  Read more...
By Craig Farrell 2013/05/24 (first published: 2011/04/14) | Source: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 18,038 reads

SQL Server Sample Databases

This is a landing page for the sample SQL Server databases we are aware of.  Read more...
By Site Owners 2013/05/24 | Source: SQLServerCentral.com | Category: adventureworks
Rating: |  Discuss |   Briefcase | 2,133 reads

Red Gate Software Brings Free SQL Server Training Back to US Due to Popular Demand

Red Gate Software is bringing SQL in the City, the popular free training event, back to the US in three new cities. This October, the events will take place in Pasadena, Atlanta and Charlotte.  Read more...
By Press Release 2013/05/24 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated) |  Discuss |   Briefcase | 135 reads

Using source data from an SSRS report in PowerPivot for Excel

In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.  Read more...
By Additional Articles 2013/05/24 | Source: MSSQLTips.com | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 1,549 reads

Automating SQL Traces

Capturing the activity on a server when a problem occurs can be a challenge for many DBAs. This article shows how you can automate the capture of information when a CPU spike occurs.  Read more...
By Clark Froebe 2013/05/23 | Source: SQLServerCentral.com | Category: sql trace
Rating: |  Discuss |   Briefcase | 3,534 reads

Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets

There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen White demonstrates.  Read more...
By Additional Articles 2013/05/23 | Source: SimpleTalk | Category: sql server 2012
Rating:  Rate this |   Briefcase | 1,321 reads

Transaction Log Stairway Series available as a book

Red Gate Books has released SQL Server Transaction Log Management, a free eBook on maintaining and troubleshooting the enigmatic transaction log based on the Stairway Series.  Read more...
By Press Release 2013/05/23 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 940 reads

Data Mining Introduction Part 5: the Neural Network Algorithm

This is the 5th article about Data Mining with SQL Server. This chapter is about Neural Networks.  Read more...
By Daniel Calbimonte 2013/05/22 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 4,015 reads

Paging Data with T-SQL

Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.  Read more...
By Additional Articles 2013/05/22 | Source: Database Journal | Category: paging data
Rating:  Rate this |   Briefcase | 3,174 reads

Power View for Cubes

This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models[1], this SQL Server 2012 CTP release allows connections between Power View and Multidimensional Models ( cubes) and not just Tabular Models.  Read more...
By Ivan Paniagua 2013/05/21 | Source: SQLServerCentral.com | Category: power view
Rating: |  Discuss |   Briefcase | 4,756 reads
 
Ask SQL Server Central



Browse all
Question of the Day

Temp Tables

By Sergiy 2013/05/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 967 reads

You are trying to execute the following code:


DECLARE @MoreColumns bit;
SET @MoreColumns = 1

IF @MoreColumns = 0
CREATE TABLE #Table (
id int,
name varchar(50)
)
ELSE
CREATE TABLE #Table (
id int,
name varchar(50),
Description varchar(8000),
USER...  Read more...
Show more
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
chihaia_ciprian
 696 934 SSC Eights!  
2.
Aadhar Joshi
 520 1143 Ten Centuries  
3.
Guy Drouin
 434 1004 Ten Centuries  
4.
karthicksurendran
 408 408 SSC-Addicted  
5.
Oleg Kryzhanovsky
 351 351 Old Hand  
Show more
Latest forum posts

Help with next date in SQL query

By Jeff Moden | May 25, 2013
Posted to SQL Server 2008 - General

DBAs and the Fear of Time Off

By herbaltea001-winter | May 25, 2013
Posted to Discuss content posted by Rodney Landrum

SQL server 2012 - MCSA certification

By jnesbit 63151 | May 25, 2013
Posted to SQL Server 2012 - T-SQL

Reporting grouping design- while invoking Sub report.

By Saintmount.Sql | May 25, 2013
Posted to Reporting Services 2008 Development

Having backup problems, and unable to change service account...

By Joie Andrew | May 25, 2013
Posted to SQL Server 2008 Administration
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.