Latest Articles in the Category SQL
Andrew Siemer, Oct 28, 2009
Views: 3608 Avg Rating: 4/5 Votes: 2 Comments: 3
In this article we will take a look at how SQL Server performs with one million records in a table. We will create a quick data pumper program to fill up a table with a million dynamically created rows of data. From there we will take a look at querying the data without any special optimizations. Then we will create a Full-text index and see how that helps our searching capability.
Jayaram Krishnaswamy, Oct 05, 2009
Views: 2689 Avg Rating: 0/5 Votes: 0 Comments: 0
This article shows how you may visualize data on your SQL Server 2008 with Pivot tables and Pivot Charts.
Pinal Dave, Aug 17, 2009
Views: 6818 Avg Rating: 0/5 Votes: 0 Comments: 0
Pinal Kumar Dave introduces the SQL Azure platform.
Pinal Dave, Jul 27, 2009
Views: 1289 Avg Rating: 0/5 Votes: 0 Comments: 0
One of the key aspects of proper Business Intelligence deployment is the alignment of metrics from top to bottom across functional areas, which can go a long way in ensuring business success.
Pinal Dave, Jun 28, 2009
Views: 4270 Avg Rating: 0/5 Votes: 0 Comments: 0
Pinal Kumar Dave discusses the future of Business Intelligence.
Pinal Dave, Jun 26, 2009
Views: 3746 Avg Rating: 0/5 Votes: 0 Comments: 0
This article will cover the most spectacular feature of SQL 2008 - Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference.
Pinal Dave, Jun 19, 2009
Views: 6926 Avg Rating: 5/5 Votes: 1 Comments: 0
A look at the different types of hints that are available in SQL Server and how they may be useful to you.
Jayaram Krishnaswamy, Jun 17, 2009
Views: 9305 Avg Rating: 1/5 Votes: 2 Comments: 0
In this article you will see how to use the SQL Server Import and Export wizard to import an MS Excel file on your computer to a database on your SQL Server.
Jayaram Krishnaswamy, Jun 11, 2009
Views: 3612 Avg Rating: 1/5 Votes: 1 Comments: 0
Jayaram Krishnaswamy writes about authoring a SQL Server Report using an ad-hoc query.
Pinal Dave, May 25, 2009
Views: 16428 Avg Rating: 4/5 Votes: 2 Comments: 0
Pinal Kumar Dave illustrates the difference between a candidate key and a primary key in SQL Server.
Pinal Dave, May 22, 2009
Views: 3978 Avg Rating: 5/5 Votes: 1 Comments: 0
Pinal Kumar Dave overviews important terms and definitions related to Business Intelligence.
Jayaram Krishnaswamy, May 21, 2009
Views: 3916 Avg Rating: 0/5 Votes: 0 Comments: 0
This article explains how to set up a Postgres linked server on SQL Server 2008.
Pinal Dave, May 05, 2009
Views: 23473 Avg Rating: 5/5 Votes: 1 Comments: 1
In this article, Author Pinal Dave clarifies the basic concepts of SQL JOINs.
Pinal Dave, Apr 28, 2009
Views: 3551 Avg Rating: 5/5 Votes: 2 Comments: 2
Pinal Kumar Dave discusses backup and restore operations in SQL Server.
Pinal Dave, Apr 22, 2009
Views: 5108 Avg Rating: 5/5 Votes: 1 Comments: 0
Introduction to the SQL Server 2008 Profiler
Pinal Dave, Apr 10, 2009
Views: 9882 Avg Rating: 5/5 Votes: 1 Comments: 1
Pinal Kumar Dave does an overview of Cloud Computing.
Pinal Dave, Mar 23, 2009
Views: 9025 Avg Rating: 0/5 Votes: 0 Comments: 1
Pinalkumar Dave describes the top 5 features of SQL Server Management Studio 2008.
Scott Mitchell, Feb 02, 2009
Views: 5469 Avg Rating: 0/5 Votes: 0 Comments: 0
Monthly tip #3: Scott Mitchell reveals some SQL tips.
Pinal Dave, Nov 27, 2008
Views: 4571 Avg Rating: 0/5 Votes: 0 Comments: 0
Pinal Dave talks about Microsoft SQL Server Certifications.
Rupesh kumar Nayak, Sep 03, 2008
Views: 5594 Avg Rating: 5/5 Votes: 1 Comments: 1
An introduction to CLR Database Objects.
Rich Dudley, May 02, 2008
Views: 9745 Avg Rating: 0/5 Votes: 0 Comments: 0
Review of the book “Beginners Guide to SQL Server Integration Services Using Visual Studio 2005”.
Pinal Dave, Feb 26, 2008
Views: 36111 Avg Rating: 5/5 Votes: 1 Comments: 7
Pinal Dave talks about encryption in SQL Server 2005.
Pinal Dave, Nov 30, 2007
Views: 4219 Avg Rating: 0/5 Votes: 0 Comments: 10
Pinal Dave shares his notes about Q&A with Database Administrators.
Pinal Dave, Oct 11, 2007
Views: 9500 Avg Rating: 0/5 Votes: 0 Comments: 2
A list of tips for enforcing coding standards in SQL.
Luke Stratman, Jun 04, 2007
Views: 14722 Avg Rating: 0/5 Votes: 0 Comments: 0
Luke Stratman shows how and why to use the SqlCacheDependency class.
Product Spotlight
