SQL Archives - SQL Authority with Pinal Dave

SQLAuthority News – Microsoft SQL Server 2008 Books Online – BOL – English

August 12, 2008

Database, DBA, Software Development, SQL Download, SQL Utility

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. The Help viewer used by Books Online requires the Microsoft .NET Framework version 2.0. Books Online includes the following types of information: Setup and upgrade…

SQLAuthority News – SQL Server 2008 Downloads Availables

August 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

SQL Server Compact 3.5 SP1 for Windows Mobile SQL Server Compact 3.5 SP1 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP1 on the Windows mobile devices. SQL Server Compact 3.5 SP1 and Synchronization Services for ADO.NET v1.0 SP1…

SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server

August 9, 2008

Pinal Dave

SQL

Database, SQL Error Messages, SQL Server Security

If you are receiving the following error related to connection to SQL Server, this blog is for you.

SQLAuthority News – Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000

August 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download, SQL Server Security

If you are still using SQL Server 2000 (you should have upgraded to SQL Server 2005 by now), there is Security Upgrade for Service Pack 4 and MSDE. Download SQL Server 2000 Security Upgrade Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – 2008 – Released To Manufacturing Available

August 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

Microsoft has Released To Manufacturing available for SQL Server 2008. Released To Manufacturing (RTM) means that code of SQL Server 2008 has been approved by MS team and it is being send to manufacture. It will be while before it is available on distribute media on store shelves. Currently it…

SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle

August 7, 2008

Pinal Dave

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

SQL Joins, SQL Scripts

One of the JR. Developer asked me a day ago, does SQL Server has similar operation like MINUS clause in Oracle. Absolutely, EXCEPT clause in SQL Server is exactly similar to MINUS operation in Oracle. The EXCEPT query and MINUS query returns all rows in the first query that are…

SQL SERVER – Query to Find Column From All Tables of Database

August 6, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Scripts, SQL Stored Procedure, SQL System Table

One question came up just a day ago while I was writing SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN. How many tables in database AdventureWorks have column name like ‘EmployeeID’? It was quite an interesting question and I thought if there…