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
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,438 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,829 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,194 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,873 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,313 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,756 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,785 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,759 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,482 reads
Browse all
Question of the Day
INSERT
By
Kapil Singh
2013/05/17
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,032 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
Assigning categories to values 1
By
Alex Fekken
|
May 18, 2013
Posted to
Discuss content posted by Hugo Kornelis
no matter how large the destination column eg. nvarchar(max)...
By
opc.three
|
May 18, 2013
Posted to
SQL Server 2005 Integration Services
Help with next date in SQL query
By
alezar
|
May 18, 2013
Posted to
SQL Server 2008 - General
Counting duplicates
By
phc
|
May 18, 2013
Posted to
SQL Server Newbies
70-462: Can the Hyper-V environment be downloaded somewhere?
By
netmikem
|
May 18, 2013
Posted to
Certification
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.