<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,633,731 DBAs, developers and SQL Server users
Headlines today
May 23, 2013
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
|
2,873 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
|
957 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
|
762 reads
Show more
Previous headlines
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,624 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,751 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,563 reads
Centralizing SQL Server Express Job Scheduling
I'm interested in monitoring all my SQL Server backups, but for SQL Server Express we're currently using scheduled backups using Windows Task scheduler on each SQL Server Express since SQL Agent does not come installed on Express Editions. Is there an alternative where I can utilize my existing SQL Server infrastructure?
Read more...
By
Additional Articles
2013/05/21
|
Source:
MSSQLTips.com
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,583 reads
How Maintenance Plans are a Big Plus for SQL Server Administration
SQL Server 2012 makes your database maintenance jobs easy by proving an effective Maintenance Plan Wizard. This wizard does a fair job of creating core maintenance plans for your database.
Read more...
By
Prett Sons
2013/05/20
|
Source:
SQLServerCentral.com
|
Category:
maintenance plans
Rating:
|
Discuss
|
Briefcase
|
3,727 reads
SQLServerCentral Hosts AdventureWorks on Azure
SQLServerCentral and Red Gate software have agreed to host the AdventureWorks database on the Azure platform and give free access to anyone that wants to practice querying it.
Read more...
By
Press Release
2013/05/20
|
Source:
SQLServerCentral.com
|
Category:
adventureworks
Rating:
|
Discuss
|
Briefcase
|
947 reads
Connecting to AdventureWorks on Azure
A quick guide for connecting to our free copy of AdventureWorks on the Azure platform.
Read more...
By
Steve Jones
2013/05/20
|
Source:
SQLServerCentral.com
|
Category:
adventureworks
Rating:
|
Discuss
|
Briefcase
|
1,010 reads
From the SQLServerCentral Blogs
Azure does Powershell too
Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...
Read more...
By
Grant Fritchey
2013/05/23
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
296 reads
The many uses of CROSS APPLY
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the first...
Read more...
By
Kenneth Fisher
2013/05/23
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,033 reads
Browse all
Question of the Day
REPLICATE
By
Mike Bova
2013/05/23
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
900 reads
What is returned from this query?
SELECT
REPLICATE('12',1)
, REPLICATE('12',0)
, REPLICATE('12',-1)
, REPLICATE('12',1.5)
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
chihaia_ciprian
815
908
SSC Eights!
2.
Aadhar Joshi
520
1143
Ten Centuries
3.
Guy Drouin
414
977
SSC Eights!
4.
karthicksurendran
408
408
SSC-Addicted
5.
GilaMonster
338
37730
SSChampion
Show more
Latest forum posts
For your amusement
By
patrickmcginnis59 10839
|
May 23, 2013
Posted to
SQL Server 2008 - General
Better Coding, More Savings
By
patrickmcginnis59 10839
|
May 23, 2013
Posted to
Editorials
How to make a solution real-time replicate from oracle and m...
By
Jeff Moden
|
May 23, 2013
Posted to
Working with Oracle
BCP Utility to output contents into CSV
By
Jeff Moden
|
May 23, 2013
Posted to
SQL Server 2005 General Discussion
TempDB requests capture
By
foxxo
|
May 23, 2013
Posted to
SQL Server 2008 Administration
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
