Additional Articles

SQLChess - A tutorial on thinking in sets

by Additional Articles

SQLTeam.com

Advanced Querying

Chess makes a fantastic game for programming examples. You will find hundreds of examples on the internet. Some dedicated to OO patterns, others to algorithms and so forth. Unfortunately, most of these examples do not use a database or if they do, treat the database as nothing more than a storage repository. In this series of articles we will use SQL Server and T-SQL to implement the game of chess with an emphasis on thinking in sets.

2007-05-21

5,228 reads

Discuss

SQL Server Grouping Workbench

by Additional Articles

SimpleTalk

Advanced Querying

Robyn Page and Phil Factor take on GROUP BY queries in SQL server, starting on the nursery slopes but finishing with a wild ride off-piste.

2007-05-18

2,426 reads

Discuss

SQL Server 2005 Integration Services - Part 48

by Additional Articles

Database Journal

Integration Services (SSIS)

Maintenance Plan Designer gives you access to 11 tasks, which allow you to perform a variety of database management activities. This article provides a brief overview of each of them, focusing on their recent improvements.

2007-05-17

2,903 reads

Discuss

Returning a week number for any given date and starting fiscal month

by Additional Articles

SQLTeam.com

Advanced Querying

Sql Server comes with a host of built in functions such as ISNULL, CONVERT and CAST. Now if that wasn't enough rope to hang ourselves with, as of Sql Server 2000 we gained the ability to create our own user defined functions. In this article I will be looking at the three main date functions DATEADD, DATEPART and DATEDIFF (there is a fourth called DATENAME but I want to get to the end of this article before you fall asleep so I decided to leave it for another date and time! And no it doesn't foretell the name of your future blind date so it's not as interesting as it sounds anyway) Then I will be combining all three in a user defined function of our own by which time our necks will be well and truly stretched

2007-05-15

2,831 reads

Discuss

XML Restructuring and Reshaping Should Not be Considered the Same

by Additional Articles

SQL Summit

Miscellaneous

Michael M. David returns to SQLSummit.com to explore two approaches to XML hierarchical structure transformations. He explains the difference between restructuring and reshaping XML data, with the latter driven by the semantics of the data structure.

2007-05-14

1,954 reads

Discuss

Fired With Enthusiasm

by Additional Articles

SimpleTalk

Miscellaneous

Phil Factor's describes his first encounter with the "light arms" (low calibre, small bore, needed to be fired).

2007-05-11

3,478 reads

Discuss

Using SQL 2005 with Expression Web

by Additional Articles

Database Journal

Miscellaneous

his article will explore various methods of accessing SQL Server from inside Microsoft Expression Web. Microsoft Expression Web is a graphical development tool for creating web pages and is part of the new Expression Studio.

2007-05-10

2,274 reads

Discuss

Use SqlBulkCopy to Quickly Load Data from your Client to SQL Server

by Additional Articles

SQLTeam.com

.Net

The .NET Framework 2.0 introduces a very handy new class in the System.Data.SqlClient namespace called SqlBulkCopy that makes it very easy and efficient to copy large amounts of data from your .NET applications to a SQL Server database. You can even use this class to write a short .NET application that can serve as a "middleman" to move data between database servers.

2007-05-09

3,525 reads

Discuss

Alert-based Transaction Log Backups using SMO

by Additional Articles

SimpleTalk

Allen White provides an SMO script for automating database log backups, using either native backup or Red Gate's SQL Backup tool.

2007-05-07

2,426 reads

Discuss

SSIS Configurations

by Additional Articles

JumpStartTV

Integration Services (SSIS)

In this session, Brian shows you how to use configuration files or a configuration file to dynamically configure your packages. With configuration files, you can seamlessly migrate an SSIS package from QA to production without worry and without having to reconfigure the package.

2007-05-04

2,582 reads

Discuss

All authors

Additional Articles

SQLChess - A tutorial on thinking in sets

SQL Server Grouping Workbench

SQL Server 2005 Integration Services - Part 48

Returning a week number for any given date and starting fiscal month

XML Restructuring and Reshaping Should Not be Considered the Same

Fired With Enthusiasm

Using SQL 2005 with Expression Web

Use SqlBulkCopy to Quickly Load Data from your Client to SQL Server

Alert-based Transaction Log Backups using SMO

SSIS Configurations

Blogs

Enterprise AI Operating Rhythm – Top 5 practices for 2026

Stop Being Surprised by Your Azure Bill: Use Budgets

Resetting on the AI hype train

Forums

Celebrating Tomorrow

SQL Art: I Made a Christmas Card In SSMS

lookup error

Question of the Day

Celebrating Tomorrow