Additional Articles

All authors

External 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.

2007-05-21

5,228 reads

External 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

2007-05-15

2,831 reads

External 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.

2007-05-09

3,525 reads

All authors

Blogs

New Pluralsight Course - Certified Kubernetes Administrator - Working With Your Cluster

By

We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...

Friday Basics: the CIA Triad

By

In information security (INFOSEC), there several foundational concepts and principles. One of the ones...

A New Word: the standard blues

By

the standard blues– n. the dispiriting awareness that the twists and turns of your...

Read the latest Blogs

Forums

More fun with Recursive CTEs

By pietlinden

Instead of dealing with courses this time, I'm trying to sort out how to...

Reporting Services Editions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reporting Services Editions

Exporting and Importing Registered Servers in SSMS

By Frank Dolan

Comments posted to this topic are about the item Exporting and Importing Registered Servers...

Visit the forum

Question of the Day

Reporting Services Editions

In which editions of SQL Server 2022 can you run Reporting Services?

See possible answers