SQL Archives - Page 425 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008

November 29, 2008

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, Openday, SQL Backup and Restore, SQL User Group, SQLAuthority Author Visit

Today is special day for SQL Server enthusiastic as we will have SQL Server User Group Meeting today in Ahmedabad. Today in User Group we will have UG President Jacob Sebastian (MVP) participating from New York and UG Vice President Pinal Dave (MVP) will talk about “How to become MVP?”…

SQLAuthority News – Download Tools and Documentation for SQL SERVER

November 27, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download

SQL Server 2008 Report Definition Language Specification The goal of Report Definition Language (RDL) is to promote the interoperability of commercial reporting products by defining a common schema that allows interchange of report definitions. An important aspect to understand is that RDL is a schema definition, not a programmatic interface…

SQLAuthority News – Help to Find Recession Proof Job

November 26, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Jobs

Recently I have been receiving a lot of emails from employees asking where they can find good employee. I was under impression that due to global recession job market is down but from looking at recent increase in emails for looking for right candidate I have to say that there…

SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008

November 25, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, MVP, Openday, SQL User Group, SQLAuthority Author Visit

It is time again to announce SQL Hour – SQL Server User Group Meeting for November 2008. This time it is going to be one really interesting event. Our User Group is growing and getting more interesting. Lots of new SQL Server enthusiastic have contacted me recently for User Group…

SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY

November 24, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

Today I observed very interesting little thing about SQL Server and I felt that I should share this with my readers. I ran following two queries and found that I am getting different result-set. When I carefully observed I found that actually the result was same but order of the…

SQL SERVER – 2008 – Download and Install Sample Database AdventureWorks 2008

November 23, 2008

Pinal Dave

SQL

SQL Download, SQL Sample Database, SQL Server

The following sample database is currently available for Microsoft SQL Server 2005 and Microsoft SQL Server 2008:

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema

November 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL Stored Procedure

I love active participation from my readers. Just a day ago I wrote article about SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database. I just received comment from Jerry Hung who have improved on previously written article of generating text of Stored Procedure. DECLARE…