Yukon News
This article on CNET has some info about how Yukon affects the MS strategy in other areas.
2003-12-29
3,447 reads
Articles
Review of MySQL/PHP Database Applications
We haven't had a book review in a while and this one may not be of interest to all of you, but we decided to take a chance and post it anyway! As Andy notes in the review, odds are that you'll deal with one or both of these applications sooner or later, might be worth thinking about taking a look at what they can do. (Reviewed)
2003-12-26
3,371 reads
Automatically Gathering Server Information Part 2
The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-25
13,202 reads
Automatically Gathering Server Information Part 1
The first part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-24
16,066 reads
Using WMI
Get started with using WMI (Windows Mgmt Instrumentation) by seeing two good scripts to start with, one to reboot the server, another to list all the services.
2003-12-23
10,024 reads
Date Time Values and Time Zones
Dinesh looks at the date functions, how to work with time zones (or not), and does a brief comparison to see how you do similar tasks in Oracle.
2003-12-22
15,267 reads
Dealing With Changing Data
As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.
2003-12-19
9,492 reads
Finding Real Dependencies
Sysdepends is a neat idea, but in practice it's not always accurate. This article talks about why it's not always reliable and presents some code (recursive even!) that will let you find all the dependencies by querying the system tables.
2003-12-18
9,468 reads
Two Best Practices!
This article presents two best practices. One is about how to construct good table aliases, the other is about using ANSI join syntax. Good stuff!
2003-12-17
10,859 reads
Best Practices in an Adhoc Environment
This short article looks at some mistakes developers should avoid when they also have the task of designing the database, database objects, or TSQL used to access it.
2003-12-16
7,945 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers