SSQA.net

In this blog post, I explained different uses of GO command Here is a Fun when you use GO as object name CREATE PROCEDURE GO(    @I INT)AS    SELECT @I AS number Well. The procedure is created and let us try to execute GO 2What we see is Command(s) completed successfullyBecuase it becomes a syntax to execute a ...

En français Get a 300$ early bird discount by registering before September 13th. We are offering an early bird of 300$ CAD for attendees that are registering before September 13th, 2008. Registered attendees have access to the DevTeach Archive sessions material for download. Early registration (3 Days) Cost CAN Cost ...

Recently we had a discussion at work place about setting up the PAGE_VERIFY option to CHECKSUM for few databases on one of the SQL Server 2005 instance (dedicated) that is being used extensively by an application that has very limited maintenance window in terms of 24/7 usage. By default you can enable of disable this PAGE_VERIFY option by ...

TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300)  Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change Data Capture and MERGE SQL statement, in addition to scalability improvements in SQL ...

Here is the list of information which is a Technical Rollup email we receive from TRM team. The list is ongoing and I have outlined the important ones that I feel and fits for 'generic' SQL Server environment. Make sure to review, download, test and apply to your production environment.  SQL Server 2008 Report Builder 2.0 ...

Often newbies use empty string and consider it as NULL. But when an empty string is passed, it may not be stored as empty string or NULL. It actually depends on the datatype of the column Consider this exampleDECLARE @t TINYINT,@s SMALLINT,@i INT,@big BIGINT,@f FLOAT,@bit BIT, @sm SMALLMONEY,@m MONEY,@d DATETIME SELECT @t='', ...

You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage.  No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present? issues to resolve. Just to talk in list of documentation, SQL Server Express makes ...

In continuation to the CumulativeUpdate package posts here for SQL Server 2005 SP2 we have another set of cumulative update package no.9 ready for testing. TO obtain this read the notes from Microsoft: .... Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. ...

Refer a SharePoint Colleague!   Forward To A Friend ___________________ Want to receive Idera's monthly newsletter?       Sign-up here   Database maintenance is an important, yet often neglected, aspect of ensuring SharePoint ...

The question on the subject was asked by one of the Data Integration project developers, which is initiated to migrate a database from Oracle to SQL Server. The process of transactions should be handled from Application and when it comes to the data migration you have the tools such as SQL Server Migration Assistant (SSMA) for all other ...