Latest Articles in the Category SQL
Sort by:
|
Avg Rating |
Most Ratings |
Cancel Sort
Dhananjay Kumar, Sep 26, 2011
Views: 5,571 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.
Chris Siermacheski, Aug 31, 2011
Views: 9,863 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.
Manning Publications, May 12, 2010
Views: 9,592 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.
Manning Publications, May 10, 2010
Views: 30,310 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.
Andrew Siemer, Oct 28, 2009
Views: 43,916 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.
Jayaram Krishnaswamy, Oct 05, 2009
Views: 28,617 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: 36,437 Avg Rating: 0/5 Votes: 0 Comments: 1
Pinal Kumar Dave introduces the SQL Azure platform.
Pinal Dave, Jul 27, 2009
Views: 7,225 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: 17,274 Avg Rating: 0/5 Votes: 0 Comments: 1
Pinal Kumar Dave discusses the future of Business Intelligence.
Pinal Dave, Jun 26, 2009
Views: 20,180 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: 45,826 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: 188,502 Avg Rating: 2/5 Votes: 3 Comments: 3
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: 17,142 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: 79,967 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: 19,076 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: 45,062 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: 374,130 Avg Rating: 5/5 Votes: 1 Comments: 3
In this article, Author Pinal Dave clarifies the basic concepts of SQL JOINs.
Pinal Dave, Apr 28, 2009
Views: 14,574 Avg Rating: 5/5 Votes: 2 Comments: 4
Pinal Kumar Dave discusses backup and restore operations in SQL Server.
Pinal Dave, Apr 22, 2009
Views: 33,199 Avg Rating: 5/5 Votes: 1 Comments: 0
Introduction to the SQL Server 2008 Profiler
Pinal Dave, Apr 10, 2009
Views: 38,350 Avg Rating: 5/5 Votes: 1 Comments: 3
Pinal Kumar Dave does an overview of Cloud Computing.
Pinal Dave, Mar 23, 2009
Views: 35,500 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: 15,686 Avg Rating: 0/5 Votes: 0 Comments: 0
Monthly tip #3: Scott Mitchell reveals some SQL tips.
Pinal Dave, Nov 27, 2008
Views: 13,007 Avg Rating: 0/5 Votes: 0 Comments: 0
Pinal Dave talks about Microsoft SQL Server Certifications.
Rupesh kumar Nayak, Sep 03, 2008
Views: 25,204 Avg Rating: 5/5 Votes: 1 Comments: 1
An introduction to CLR Database Objects.
Rich Dudley, May 02, 2008
Views: 17,100 Avg Rating: 0/5 Votes: 0 Comments: 0
Review of the book “Beginners Guide to SQL Server Integration Services Using Visual Studio 2005”.