<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,303 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:
|
Discuss
|
Briefcase
|
2,163 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
|
463 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
|
517 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
|
814 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,985 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,463 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,226 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,482 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,154 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,421 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
|
437 reads
Browse all
Question of the Day
EXCEPT - 1
By
bitbucket
2013/05/20
|
Category:
except
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
772 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
684
753
Right there with Babe
2.
Aadhar Joshi
421
1044
Ten Centuries
3.
karthicksurendran
408
408
SSC-Addicted
4.
Guy Drouin
389
942
SSC Eights!
5.
Lynn Pettis
328
21592
SSChampion
Show more
Latest forum posts
Are the posted questions getting worse?
By
Brandie Tarvin
|
May 20, 2013
Posted to
Anything that is NOT about SQL!
Finding the total count of ACTIVE Customers and their remain...
By
sql1411
|
May 20, 2013
Posted to
T-SQL (SS2K8)
Speed up updates by disabling indices
By
terry999
|
May 20, 2013
Posted to
SQL Server 2008 Administration
no matter how large the destination column eg. nvarchar(max)...
By
Lynn Pettis
|
May 20, 2013
Posted to
SQL Server 2005 Integration Services
Database data files
By
GilaMonster
|
May 20, 2013
Posted to
SQL Server 2005 General Discussion
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
