Articles

The challenge is to write a query that returns the articles to be displayed in the home page of the website. N number of articles from each category is to be selected where N is configured in the Categories table. Each category should select the most recent N articles. ArticleID can be used to identify the most recent articles. An article with a higher number indicates a more recent article.

2010-04-19

2,022 reads

Clustered instance will not start after removing builtin admins

by Perry Whittle

SQLServerCentral.com

Clustering

After removing the builtin administrators group the clustered services do not start. Perry Whittle walks through the issue and what you can do to correct things.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(10)

You rated this post out of 5. Change rating

2010-04-16

1,486 reads

Discuss

Microsoft Access: Business Intelligence on a Shoestring

by Additional Articles

Database Journal

Access

Learn how to deliver dynamic content by building a meaningful Business Intelligence Application, utilizing only what is available on the client's desktop, when a Data Warehouse BI Application, SQL Server and SSIS/SSRS aren't an option.

2010-04-16

3,743 reads

How to find unused Stored Procedures in SQL Server 2005/2008

by Ronny Dahl

SQLServerCentral.com

SQL Server

Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(49)

You rated this post out of 5. Change rating

2010-04-15

28,606 reads

Discuss

Adding Actions to a Cube in SQL Server Analysis Services 2008

by Additional Articles

SimpleTalk

Analysis Services (SSAS)

Actions are powerful way of extending the value of SSAS cubes for the end user. They can click on a cube or portion of a cube to start an application with the selected item as a parameter, or to retrieve information about the selected item. Actions haven't been well-documented until now; Robert Sheldon once more makes everything clear.

2010-04-15

3,114 reads

HASHBYTES can help quickly load a Data Warehouse

by Magarity Kerns

SQLServerCentral.com

Data Warehousing

Data warehouse loads can be time consuming - this method can be used in some instances to help speed things up.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(35)

You rated this post out of 5. Change rating

2010-04-14

16,961 reads

Discuss

Intro to Entity Framework with SQL Server

by Additional Articles

MSSQLTips.com

Entity Framework

I'm a DBA and the developers in my organization are starting to use something called the Entity Framework (EF) in their applications. The developers are telling me that with EF you don't use stored procedures, you simply write .NET code to perform all of your data access. When I use the SQL Server Profiler to take a look at what they're doing, all I see is a bunch of dynamic SQL being executed. Naturally I'm a little skeptical of this, so can you help me to understand what is this Entity Framework?

2010-04-14

5,701 reads

SQL Saturday #39 - New York City

by Press Release

SQLServerCentral.com

SQLSaturday

Come to this great one day training event in New York, New York. SQL Saturday comes to the Big Apple and is a great way to get free training on all aspects of SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2010-04-14 (first published: 2010-02-11)

4,017 reads

Hello SSIS World, From XML!

by Stan Kulp

SQLServerCentral.com

Integration Services (SSIS)

This article brings us an SSIS package that reads an XML file and sequentially displays each XML record in a MessageBox before inserting it into a staging table. You can use this to get XML data into your SQL Server database for further processing.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(25)

You rated this post out of 5. Change rating

2010-04-13

10,113 reads

Discuss

Proactive Database Index Creation

by Additional Articles

Database Journal

Indexing

Indexes help your application find your data quickly and provide users with a well performing application, while minimizing server resources. This article discusses indexing guidelines related to join tables and covering indexes.

2010-04-13

3,989 reads

Articles

TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database

Clustered instance will not start after removing builtin admins

Microsoft Access: Business Intelligence on a Shoestring

How to find unused Stored Procedures in SQL Server 2005/2008

Adding Actions to a Cube in SQL Server Analysis Services 2008

HASHBYTES can help quickly load a Data Warehouse

Intro to Entity Framework with SQL Server

SQL Saturday #39 - New York City

Hello SSIS World, From XML!

Proactive Database Index Creation

Blogs

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

A Spread of Vacation

How AgentDBA Identifies Backup Failures

Forums

Calculating Geometric Mean in Power BI

TempDB Facts I

Have you done a Mid year check in?

Question of the Day

TempDB Facts I