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

SQL SERVER – Difference Between Candidate Keys and Primary Key

May 30, 2009

SQL Constraint and Keys, SQL Function, SQL Scripts

Let us first try to grasp the definition of the two keys. Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as…

SQL SERVER – Fix : Error : SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer

May 28, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I often receive emails from reader requesting solution to following error: “SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem.” in a modal dialog with the title “SQL Writer” While searching online there are…

SQL SERVER – Find Hostname and Current Logged In User Name

May 26, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL Server Security

I work in an environment wherein I connect to multiple servers across the world. Time and again, my SSMS is connected to a myriad of servers that kindles a lot of confusion. I frequently use the following trick to separate different connections, which I mentioned in my blog sometime back…

SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (May 2009)

May 25, 2009

Pinal Dave

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

Database, SQL Download

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. Books Online includes the following types of information: Setup and upgrade instructions. Information about new features and backward compatibility. Conceptual descriptions of the technologies and…

SQL SERVER – Introduction to Business Intelligence – Important Terms and Definitions

May 24, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, Database

What is Business Intelligence Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data from various data sources, thus providing enterprise users with reliable and timely information and analysis for improved decision making. To put it simply, BI is…

SQLAuthority News – SQL Server Energy Event with Rushabh Mehta – May 20, 2009

May 23, 2009

Pinal Dave

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

DigiCorp, MVP, SQL User Group, SQLAuthority Author Visit

The much-awaited SQL Server Energy Event was successfully held on May 20, 2009 in Ahmedabad. It was jointly organized by Gandhinagar SQL Server User Group (President Pinal Dave – SQL MVP) and Ahmedabad SQL Server User Group (President Jacob Sebastian – SQL MVP). This vibrant event was one of the…

SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )

May 21, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Management Studio

Regular readers of my blog are aware of the fact that I have written about this subject umpteen times earlier, and every time I have spoken about a new issue related to it. Few days ago, I had redone my local home network. I have LAN setup with wireless router…