<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,169 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,609 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,339 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,010 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,287 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,010 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,344 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,949 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,839 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,782 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,634 reads
Browse all
Question of the Day
INSERT
By
Kapil Singh
2013/05/17
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,094 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
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
327
21589
SSChampion
Show more
Latest forum posts
70-462: Can the Hyper-V environment be downloaded somewhere?
By
netmikem
|
May 19, 2013
Posted to
Certification
UDF Function to search files in SQL Server
By
mister.magoo
|
May 19, 2013
Posted to
SQL Server 2012 - T-SQL
Conversion varchar value overflowed an int column in sql ser...
By
mister.magoo
|
May 19, 2013
Posted to
SQL Server 2008 - General
Order of joins - Which one is better?
By
GilaMonster
|
May 19, 2013
Posted to
Administering
no matter how large the destination column eg. nvarchar(max)...
By
Lynn Pettis
|
May 19, 2013
Posted to
SQL Server 2005 Integration Services
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
