Latest Articles in the Category SQL

Sort by: Most Comments | Avg Rating | Most Ratings | Cancel Sort

SQL Azure to Developers: Part 1

Dhananjay Kumar, Sep 26, 2011
Views: 2,951 Avg Rating: 0/5 Votes: 0 Comments: 0

In this part we will focus on overview of SQL Azure along with a first look on SQL Azure Management Portal.

Easy Insert, Update and Retrieve Values for Microsoft SQL Database with C#, Visual Studio

Chris Siermacheski, Aug 31, 2011
Views: 7,295 Avg Rating: 0/5 Votes: 0 Comments: 0

This article will provide you with the small amount of code required to insert, update and retrieve values with up to date methods in Visual Studio.

What's blocking my running SQL?

Manning Publications, May 12, 2010
Views: 7,639 Avg Rating: 0/5 Votes: 0 Comments: 0

This article is taken from the book SQL Server DMVs in Action. The author discusses a routine that identifies the SQL queries that are blocked as a result of competing for resources.

Identifying currently running SQL queries

Manning Publications, May 10, 2010
Views: 20,086 Avg Rating: 0/5 Votes: 0 Comments: 0

This article is taken from the book SQL Server DMVs in Action. The author discusses a routine that identifies the SQL queries that are currently running, which is useful for debugging.

Lucene.NET vs SQL Server Full-text – Generating a million records and a full-text index

Andrew Siemer, Oct 28, 2009
Views: 35,718 Avg Rating: 2/5 Votes: 4 Comments: 14

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.

Creating Pivot Table and Pivot Chart with data from SQL Server 2008

Jayaram Krishnaswamy, Oct 05, 2009
Views: 23,262 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.

Introduction to SQL Azure

Pinal Dave, Aug 17, 2009
Views: 31,375 Avg Rating: 0/5 Votes: 0 Comments: 1

Pinal Kumar Dave introduces the SQL Azure platform.

Business Intelligence - Aligning Business Metrics

Pinal Dave, Jul 27, 2009
Views: 6,012 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.

Future of Business Intelligence

Pinal Dave, Jun 28, 2009
Views: 15,940 Avg Rating: 0/5 Votes: 0 Comments: 1

Pinal Kumar Dave discusses the future of Business Intelligence.

Policy-Based Management – Create, Evaluate and Fix Policies

Pinal Dave, Jun 26, 2009
Views: 17,746 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.

SQL Server –Understanding Table Hints with examples

Pinal Dave, Jun 19, 2009
Views: 33,910 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.

Importing MS Excel data to SQL Server 2008

Jayaram Krishnaswamy, Jun 17, 2009
Views: 172,261 Avg Rating: 2/5 Votes: 3 Comments: 2

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.

Authoring a SQL Server Report Using an Ad hoc query

Jayaram Krishnaswamy, Jun 11, 2009
Views: 14,515 Avg Rating: 1/5 Votes: 1 Comments: 0

Jayaram Krishnaswamy writes about authoring a SQL Server Report using an ad-hoc query.

SQL SERVER - Difference Between Candidate Keys and Primary Key

Pinal Dave, May 25, 2009
Views: 75,182 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.

Introduction to Business Intelligence - Important Terms & Definitions

Pinal Dave, May 22, 2009
Views: 16,334 Avg Rating: 5/5 Votes: 1 Comments: 0

Pinal Kumar Dave overviews important terms and definitions related to Business Intelligence.

Creating a linked Postgres Server on SQL Server 2008

Jayaram Krishnaswamy, May 21, 2009
Views: 35,379 Avg Rating: 0/5 Votes: 0 Comments: 0

This article explains how to set up a Postgres linked server on SQL Server 2008.

SQL SERVER JOINs

Pinal Dave, May 05, 2009
Views: 360,716 Avg Rating: 5/5 Votes: 1 Comments: 3

In this article, Author Pinal Dave clarifies the basic concepts of SQL JOINs.

Mirrored Backup and Restore and Split File Backup

Pinal Dave, Apr 28, 2009
Views: 12,657 Avg Rating: 5/5 Votes: 2 Comments: 4

Pinal Kumar Dave discusses backup and restore operations in SQL Server.

Introduction to SQL Server 2008 Profiler

Pinal Dave, Apr 22, 2009
Views: 30,764 Avg Rating: 5/5 Votes: 1 Comments: 0

Introduction to the SQL Server 2008 Profiler

Introduction to Cloud Computing

Pinal Dave, Apr 10, 2009
Views: 34,895 Avg Rating: 5/5 Votes: 1 Comments: 3

Pinal Kumar Dave does an overview of Cloud Computing.

SQL Server 2008 Management Studio New Features

Pinal Dave, Mar 23, 2009
Views: 33,275 Avg Rating: 0/5 Votes: 0 Comments: 1

Pinalkumar Dave describes the top 5 features of SQL Server Management Studio 2008.

More Concise T-SQL with SQL Server 2008

Scott Mitchell, Feb 02, 2009
Views: 13,956 Avg Rating: 0/5 Votes: 0 Comments: 0

Monthly tip #3: Scott Mitchell reveals some SQL tips.

Roadmap of Microsoft Certifications - SQL Server Certifications

Pinal Dave, Nov 27, 2008
Views: 10,862 Avg Rating: 0/5 Votes: 0 Comments: 0

Pinal Dave talks about Microsoft SQL Server Certifications.

Introduction to CLR Database Objects

Rupesh kumar Nayak, Sep 03, 2008
Views: 21,947 Avg Rating: 5/5 Votes: 1 Comments: 1

An introduction to CLR Database Objects.

Review: SQL Server Integration Services Using Visual Studio 2005 – A Beginners Guide

Rich Dudley, May 02, 2008
Views: 15,964 Avg Rating: 0/5 Votes: 0 Comments: 0

Review of the book “Beginners Guide to SQL Server Integration Services Using Visual Studio 2005”.