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,632,447 DBAs, developers and SQL Server users

Rss
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,358 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 | 536 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 | 578 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 | 914 reads
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 | 17,041 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,481 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,257 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,517 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,184 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,432 reads
 
Ask SQL Server Central



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 | 475 reads
Question of the Day

EXCEPT - 1

By bitbucket 2013/05/20 | Category: except
Rating: (not yet rated) |  Discuss |   Briefcase | 824 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...
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
329 21593 SSChampion  
Latest forum posts