Additional Articles

All authors

Technical Article

SQLChess - A tutorial on thinking in sets

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-05-21

5,228 reads

Technical Article

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

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-05-15

2,831 reads

Technical Article

XML Restructuring and Reshaping Should Not be Considered the Same

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-05-14

1,954 reads

Technical Article

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

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-05-09

3,525 reads

Technical Article

SSIS Configurations

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-05-04

2,582 reads

All authors

Blogs

Getting the SQL Server MCP Server Running

By

If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

By

Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...

Rambling about Data on Wheels – origins, branding, expansion

By

I have been asked many times about how the name “Data on Wheels” came...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU Wahid Hasyim Telp:0817825533

By layanan_Bca88

Hub Via Wa:62817825533 Alamat: Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan...

Alamat Kantor BCA KCU Thamrin Telp:0817825533

By m4rt1n4

Hub Via Wa:62817825533 Alamat: Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng,...

Alamat Kantor BCA KCU Scbd Telp:0817825533

By R4nt4u

Hub Via Wa:62817825533 Alamat: Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...

Visit the forum

Question of the Day

DBCC CHECKDB Limits III

On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?

See possible answers