<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,632,239 DBAs, developers and SQL Server users
Headlines today
May 20, 2013
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:
(not yet rated)
|
Discuss
|
Briefcase
|
143 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:
(not yet rated)
|
Discuss
|
Briefcase
|
20 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:
(not yet rated)
|
Discuss
|
Briefcase
|
20 reads
Azure SQL Database Maintenance
It is increasingly likely that DBAs are now given responsibility for maintaining Azure SQL databases as well as conventional SQL Server databases. What is likely to be required by way of maintenence? What are the differences? Grant Fritchey covers what you need to know.
Read more...
By
Additional Articles
2013/05/20
|
Source:
SimpleTalk
|
Category:
azure
Rating:
(not yet rated)
Rate this
|
Briefcase
|
31 reads
Show more
Previous headlines
Powershell Database Backup Script
Learn how to write a script for regular database backups using Powershell and SMO.
Read more...
By
Jimmy Atsaves
2013/05/17 (first published: 2011/01/05)
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
16,726 reads
Raw Materials - Beyond Global
There's more than one way to be green.
Read more...
By
Larry Gonick
2013/05/17 (first published: 2010/09/22)
|
Source:
SQLServerCentral.com
|
Category:
raw materials
Rating:
|
Discuss
|
Briefcase
|
10,370 reads
Getting Started Formatting SSRS Reports
Once you've prepared an SSRS report, it needs formatting to get it ready for the people who need to read it. This tip covers the basics of formatting SSRS Reports.
Read more...
By
Additional Articles
2013/05/17
|
Source:
SQL Server Performance
|
Category:
ssrs
Rating:
Rate this
|
Briefcase
|
2,070 reads
How to Change the SQL Server Name after Renaming the Windows Host
This article shows how to change a SQL Server name after changing the Windows machine name.
Read more...
By
Shashank Srivastava
2013/05/16
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
5,334 reads
Getting Started Testing Databases with tSQLt
There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is simple for a database developer to set up and use. It doesn't get in the way. Rob Sheldon shows you how to get started.
Read more...
By
Additional Articles
2013/05/16
|
Source:
SimpleTalk
|
Category:
tsqlt
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,059 reads
Using XML from data variable option in SSIS
Learn how you can manipulat XML documents solely in memory. No file required.
Read more...
By
Cindy Conway
2013/05/15
|
Source:
SQLServerCentral.com
|
Category:
sql server
Rating:
|
Discuss
|
Briefcase
|
3,357 reads
From the SQLServerCentral Blogs
Roll Logs – Backup Recovery
Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....
Read more...
By
SteveHood79
2013/05/20
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
129 reads
Browse all
Question of the Day
EXCEPT - 1
By
bitbucket
2013/05/20
|
Category:
except
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
86 reads
I create the following two (2) tables , and insert the data as shown.
CREATE TABLE t1(x INT,A INT IDENTITY(1,1));
INSERT INTO t1 VALUES (10),(20),(4),(20),(10);
CREATE TABLE t2(y INT,B INT IDENTITY(15,15) PRIMARY KEY);
INSERT...
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
chihaia_ciprian
571
640
SSChasing Mays
2.
Aadhar Joshi
421
1044
Ten Centuries
3.
karthicksurendran
408
408
SSC-Addicted
4.
Guy Drouin
389
942
SSC Eights!
5.
Lynn Pettis
325
21589
SSChampion
Show more
Latest forum posts
How to select this
By
surindersinghthakur
|
May 20, 2013
Posted to
SQL Server 2008 - General
Add User Mapping not working
By
durai nagarajan
|
May 19, 2013
Posted to
Administering
How to count active jobs at the end of each month across a p...
By
AndyAus
|
May 19, 2013
Posted to
T-SQL (SS2K5)
EXCEPT - 1
By
kapil_kk
|
May 19, 2013
Posted to
Discuss content posted by bitbucket
How many packages can be created in single SSIS Project ?
By
anandhaksc
|
May 19, 2013
Posted to
Integration Services
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
