Already a member? Log in

Sign up with your...

or

Sign Up with your email address

Add Tags

Duplicate Tags

Rename Tags

Share This URL With Others!

Save Link

Sign in

Sign Up with your email address

Sign up

By clicking the button, you agree to the Terms & Conditions.

Forgot Password?

Please enter your username below and press the send button.
A password reset link will be sent to you.

If you are unable to access the email address originally associated with your Delicious account, we recommend creating a new account.

Links 1 through 10 of 19 by Atif Aziz tagged sqlserver

Share It With Others!

Note about redistributing Microsoft.Data.Schema.ScriptDom.dll
and Microsoft.Data.Schema.ScriptDom.Sql.dll, which contain Microsoft's own parsing engine for T-SQL.

Share It With Others!

A tour of the tooling support for SQL Server Compact 4.0 in Visual Studio 2010 SP1 and Visual Web Developer Express 2010 SP1.

Share It With Others!

Jon Galloway discusses the pros and cons of an approach to implementing cache dependency on tables in a SQL Server database using CHECKSUM family of functions to detect changes.

Share It With Others!

Lists requirements that SELECT statements need to follow for query notifications.

Share It With Others!

This article explains how to give a user the minimum rights required for SqlDependency to work.

Share It With Others!

Mladen Prajdić demonstrates why SQL Server does not do short-circuiting like it is done in other programming languages and that it cannot be enforced except via CASE.

Share It With Others!

Open DBDiff is a open source database schema comparison tool for SQL Server 2005. It reports any differences between two database schemas and provides a synchronized script to upgrade a database from one to the other.

Share It With Others!

The express edition of MS SQL Server 2005 is free, but it does not provide any tools for profiling SQL queries like MS SQL Profiler. This project provides aims to fill that gap.

Share It With Others!

The (undocumented) system stored procedure, sp_MSforeachtable, will loop through all the tables in the database, performing a command or two on each table. It can come handy in a very of maintenance scenarios as Raymond outlines one.

Share It With Others!