Blog Detail

Sql Server 2005 Tips and Tricks

http://www.sqlservercurry.com

Get some unique tips tricks and articles on SQL Server 2005. The blogs also cover Sql Server Reporting Services along with SQL Server Administration

• Added on: Mar 10th, 2008
• Country: United States
• Language: English

• Author: loveblog
• Listed in: Programming
• Tags: tips and tricks sql server 2005 ssrs sql server administration t-sql programming

Recent Posts

• SQL Server 2008 R2 November CTP Now Available

  Posted on Sunday November 15th, 2009 at 06:45 in sql server general

  The latest Community Technology Preview (CTP) for SQL Server 2008 R2 is now availableSome of the new capabilities added to SQL Server in this release are:- improved support for virtualization through Hyper-V with Live Migration in Windows Server 2008...

• Executing a Stored Procedure using SQLCMD

  Posted on Friday November 13th, 2009 at 22:06 in sql server administration, transact sql t-sql

  Here’s how to execute a SQL Server Stored Procedure using SQLCMD. For demonstration purposes, I will be executing the ‘CustOrderHist’ Stored Procedure in the Northwind database. This procedure accepts the CustomerID and returns a list of orders...

• Programmatically Change the default path for SQL Server Database creation

  Posted on Wednesday November 11th, 2009 at 10:53 in sql server administration

  The extended stored procedure "xp_instance_regwrite" helps you read/write from the registry. You can use this stored procedure to programmatically change the path where the data files for a new SQL Server database gets created by default. Here’s ho...

• Some Changes in the latest CTP of SQL Azure Service

  Posted on Monday November 9th, 2009 at 11:00 in sql data services

  Some new features have been introduced to the latest October CTP 2 of SQL Azure Service. The updated CTP still uses previous accounts, so you do not need the new invitation code again. Following are some changes made to the new CTP:With SQL Azure Ser...

• Insert Rows in between a SQL Server Table with Identity Column

  Posted on Saturday November 7th, 2009 at 06:55 in transact sql t-sql

  I have seen a lot of users asking this question – “I have accidentally deleted a row in a Table with Identity Column. How do I insert that row again?”Let us assume that we have a table with ‘CustId’ as the Identity Column. The row for CustI...

• Create a SSRS Report based on a Cube and Deploy it

  Posted on Thursday November 5th, 2009 at 06:55 in reporting services ssrs

  In our previous article, we took an overview and need of SSRS and various kinds of report delivery. In this article, we will discuss how to create a report and deploy it. We will create a report based on the cube we created in the article Creating a ...

Comments & Reviews

There is no rating for this blog because there are no comments yet.

Post A Comment/Review

* Your IP is being logged.
* Your e-mail address is used only for verification purposes only and will not be sold, or shown publicly.
* No HTML tags allowed
* DO NOT use the Comments/Reviews to promote your own site.