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
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
70 reads
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
53 reads
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
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
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
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,666 reads
VBscript hacks for DTS packages
This article is about using VBscript hacks to overcome two limitations of DTS packages.
2008-07-11
9,728 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers