A Good Case For Reference
Steve Jones is looking for some interesting application ideas using SQL Server that can help teach people how to take advantage of features.
2008-07-14
66 reads
Articles
SQL Server Function to Determine a Leap Year
I need to write a function to determine if particular year is a leap year (i.e. February contains 29 days rather than 28 days). I know that there are various rules for calculating leap years. Is there an easy way to figure this out? Can you provide an example or two to validate various years?
2008-07-14
5,755 reads
Where is the Query in XQuery?
Michael David discusses how XQuery was designed from the ground up to process hierarchical XML data, but it is still missing capabilities that a hierarchical query processor product should have and did have originally.
2008-07-14
2,422 reads
Software for Profit
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-13
58 reads
Software for Profit
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-13
86 reads
Software for Profit
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-13
63 reads
SQL Server 2005 Service Accounts
Are you aware that SQL Server 2005 can have up to ten services running? Working with that many service accounts can be a challenge. Steve Jones takes a look at these services and a few of the things that you will want to know before setting up SQL Server 2005.
2008-07-11 (first published: 2006-03-23)
50,617 reads
VBscript hacks for DTS packages
This article is about using VBscript hacks to overcome two limitations of DTS packages.
2008-07-11
9,687 reads
Intrinsic Member Properties: The MEMBER_KEY Property
Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
2008-07-11
2,077 reads
Microsoft Jet 4.0 Sorting APIs: DBCompareStringW and DBLCMapStringW
The Microsoft Jet 4.0 relational database engine utilizes character sorting tables when creating and querying field indexes made up of character data. Two Microsoft Windows APIs are generally utilized for this functionality:
2008-07-11
3,944 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers