All Articles - SQL Authority with Pinal Dave

SQL SERVER – 2005 – White Paper – Integrating Visio 2007 and Microsoft SQL Server 2005

September 10, 2007

SQL Download, SQL Utility, SQL White Papers

This article focuses on integration techniques specific to Microsoft Office Visio 2007 and Microsoft SQL Server 2005. Using Visio 2007, you can connect Visio shapes to data that was generated outside Visio. A large amount of data can be captured in a SQL Analysis Services database. Being able to analyze…

SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide

September 10, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Download, SQL Jobs

If you have one or more years of experience in any web based programming language (.NET, ColdFusion, PHP) and interested in SQL Server as well willing to locate Ahmadabad, India. Please send me your resume, if selected you may get chance to work with one of the most progressing industry…

SQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt

September 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

Very frequently I use following command prompt script to start and stop default instance of SQL Server. Our network admin loves this commands as this is very easy. Click Start >> Run >> type cmd to start command prompt. Start default instance of SQL Server net start mssqlserver Stop default…

SQL SERVER – UDF – User Defined Function – Get Number of Days in Month

September 8, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

Following User Defined Function (UDF) returns the numbers of days in month. It is very simple yet very powerful and full proof UDF. CREATE FUNCTION [dbo].[udf_GetNumDaysInMonth] ( @myDateTime DATETIME ) RETURNS INT AS BEGIN DECLARE @rtDate INT SET @rtDate = CASE WHEN MONTH(@myDateTime) IN (1, 3, 5, 7, 8, 10,…

SQL SERVER – Correlated and Noncorrelated – SubQuery Introduction, Explanation and Example

September 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts, SQL Sub Query

A correlated subquery is an inner subquery which is referenced by the main outer query such that the inner query is considered as being executed repeatedly. Example: ----Example of Correlated Subqueries USE AdventureWorks; GO SELECT e.EmployeeID FROM HumanResources.Employee e WHERE e.ContactID IN ( SELECT c.ContactID FROM Person.Contact c WHERE MONTH(c.ModifiedDate)…

SQL SERVER – 2005 – Introduction and Explanation to sqlcmd

September 6, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility, sqlcmd

I decided to write this article to respond to request of one of usergroup, which requested that they would like to learn sqlcmd 101. SQL Server 2005 has introduced new utility sqlcmd to run ad hoc Transact-SQL statements and scripts from command prompt. T-SQL commands are entered in command prompt…

SQLAuthority News – SQL SERVER 2008 CTP 4 Released

September 6, 2007

Pinal Dave

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

Database, SQL Download, SQL Service Pack

SQL Server 2008 CTP 4 is released as a pre-configured VHD. This allows you to trial SQL Server 2008 CTP 4 in a virtual environment. Download SQL Server 2008 CTP 4 Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Valid SQL Error

September 5, 2007

Pinal Dave

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

DBA, SQL Error Messages, SQL Humor

Yesterday I had posted my 300th post and I missed the announcement. One of my reader sent me following Image in email congratulating SQLAuthority blog for completing 300th post and also informing me that it has been long time I have posted something funny. I have written few articles about…

SQLAuthority News – Interesting Read – Using A SQL JOIN In A SQL UPDATE/Delete Statement – Ben Nadel

September 5, 2007

Pinal Dave

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

SQL Joins, SQL Scripts, SQL Stored Procedure

As everybody know SQL is what I like most. Before I was into SQL Server, I was very much into ColdFusion. ColdFusion is still my most favorite programming language. I still program in ColdFusion, infect my personal website https://www.pinaldave.com/ is in ColdFusion. I regularly read ColdFusion blog and latest updates…

SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database

September 4, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL System Table

My article SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key has received following question many times. I have deleted similar questions and kept only latest comment there. In SQL Server 2005 How to Find Tables With Primary Key Constraint in Database? Script…