<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,079 DBAs, developers and SQL Server users
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,431 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,299 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
|
1,821 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,190 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
|
2,867 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,311 reads
SQL Saturday #220 - Atlanta
A free day of training this weekend in Atlanta, GA.
Read more...
By
Press Release
2013/05/15
|
Source:
SQLServerCentral.com
|
Category:
sql saturday
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,745 reads
Forwarding Pointers in Heaps
When no clustered index is defined on a table, that table is said to be a Heap. Heaps are not ideal when it comes to performance but there are lots of instances where you have heaps.
Read more...
By
Additional Articles
2013/05/15
|
Source:
SQL Server Performance
|
Category:
heaps
Rating:
Rate this
|
Briefcase
|
1,780 reads
Converting Large Object Data Types
Eliminate pesky legacy TEXT, NTEXT and IMAGE data types with this handy script.
Read more...
By
Othman Hack
2013/05/14
|
Source:
SQLServerCentral.com
|
Category:
data types
Rating:
|
Discuss
|
Briefcase
|
3,758 reads
SQL Saturday #212 - Redmond
A free day of training in Redmond, WA this weekend on May 18, 2013.
Read more...
By
Press Release
2013/05/14
|
Source:
SQLServerCentral.com
|
Category:
sql saturday
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,468 reads
Browse all
Question of the Day
INSERT
By
Kapil Singh
2013/05/17
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,029 reads
CREATE TABLE [dbo].[test]
(
[ID] [int] IDENTITY(1,1) NOT NULL,
[PK_col] [int] PRIMARY KEY,
[Col1] [int] NULL,
[Col2] [int] NULL,
[Col3] AS ([col1]+[col2])
)
SELECT *
INTO TEST1
FROM TEST
---Statement1
INSERT INTO test
VALUES (1,2,3)
---Statement2
INSERT INTO TEST1
VALUES (1,2,3)
...
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
chihaia_ciprian
617
640
SSChasing Mays
2.
Aadhar Joshi
421
1044
Ten Centuries
3.
karthicksurendran
408
408
SSC-Addicted
4.
Guy Drouin
390
942
SSC Eights!
5.
Lynn Pettis
346
21588
SSChampion
Show more
Latest forum posts
Powershell for DBAs
By
william-700725
|
May 18, 2013
Posted to
Editorials
help with best practice for merging 2 sql databases
By
GilaMonster
|
May 18, 2013
Posted to
Backups
Settings of Windows Server for SQL
By
tony28
|
May 18, 2013
Posted to
SQL Server 2008 - General
Assigning categories to values 1
By
Hugo Kornelis
|
May 18, 2013
Posted to
Discuss content posted by Hugo Kornelis
Best code for generating sequence numbers
By
Jeff Moden
|
May 18, 2013
Posted to
Development
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
