Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,634,133 DBAs, developers and SQL Server users
Headlines today
May 24, 2013
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
|
17,210 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
|
1,854 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
|
60 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,124 reads
Show more
Previous headlines
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,370 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,144 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
|
879 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
|
3,885 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
|
2,968 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,677 reads
From the SQLServerCentral Blogs
Per Member Per Month Per 1000 Calculations in MDX
In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the...
Read more...
By
MikeDavis
2013/05/24
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
477 reads
Browse all
Question of the Day
Temp Tables
By
Sergiy
2013/05/24
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
827 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
761
934
SSC Eights!
2.
Aadhar Joshi
520
1143
Ten Centuries
3.
Guy Drouin
425
989
SSC Eights!
4.
karthicksurendran
408
408
SSC-Addicted
5.
Sean Lange
333
8632
SSCrazy Eights
Show more
Latest forum posts
Copy SQL .bak file to other server using FTP/SFTP and restor...
By
patrickmcginnis59 10839
|
May 24, 2013
Posted to
SQL Server 2008 - General
Are the posted questions getting worse?
By
Steve Jones - SSC Editor
|
May 24, 2013
Posted to
Anything that is NOT about SQL!
No catalog entry found for partition ID
By
Ok Ek
|
May 24, 2013
Posted to
Development
calculate average time results
By
jsteinbeck-618119
|
May 24, 2013
Posted to
T-SQL (SS2K8)
Combining AlwaysOn Groups With Failover Cluster Instances
By
salkasalka
|
May 24, 2013
Posted to
Discuss content posted by Perry Whittle
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.