Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
Coping with No Column Names in the SSIS OLEDB Data Source Editor
Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.
New Isolation Levels Available in SQL Server 2005
One of the more mysterious features of SQL Server is isolation levels. Whenever a statement is executed, or a data modification is made, it runs under the influence of an isolation level. Traditionally, SQL Server has supported four isolation levels. In SQL Server 2005, two new isolation levels are introduced.
SQL Server 2008 - Table Valued Parameters
In this screencast, we look at Table Valued Parameters from both the server side and client side perspectives.
Writing Outer Joins in T-SQL
Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.
Ideas for SQLServerCentral.com
We're embarking upon a rebuild of the site and we're looking for input from those of you that use the site.
Snapshots - Part 1
Longtime replication expert Andy Warren takes a look at the initial snapshots involved with replication and dives into an explanation of what's involved.
Using the ReportViewer Control in a WebForm with Parameters
A short article by Darren Herbold, reporting services trainer and consultant that shows how you can easily use a Report Viewer on a web page.
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers