Review of SQL2K Resource Kit
Good enough for your bookshelf? This one meets that requirement for Brian, click the link to find out why.
SQL Server VP Gord Mangione Moves to Security Team
According to this article Mangione will be working on security products. Paul Flessner and several other managers will take over the SQL team.
Review of SQL Sentry (Lite)
Leo reviews a new product as a follow up to his recent article about Monitoring Failed Job Steps.
Speed up Development on Backend and Middle Tier with SQL Scripts
This article shows some options to retrieve all the metadata you'll need to write scripts that write scripts. No, that's not a goof, this article is about code generation.
Restore a DTS package from a DTS Store
Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!
Review of Guru's Guide to SQL Server Architecture and Internals
If you are (or want to be) a power user, this book should be on your shelf. How many books have you read that have you using a debugger to step into the sql server process? James gives it a thumbs up!
Beginning ADO.NET
One of the strengths of Visual Studio .NET is its features for rapid application development, or prototyping. If, for example, you want to develop a Windows form that lets you maintain the data in one table of a database, you can usually do that in 20 minutes or less. This article will show you how.
The Need For Speed - Upgrading Your Servers
Do you have the need for more speed on your servers? How do you go about squeezing more speed out of the database when faced with an upgrade? Steve Jones walks through some of his thought process when looking at ugprade for one of his servers.
SQL Server Auditing and Notification
As Jeff says, "There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment". Well, now we have one that shows you how to do it!
Review of Review of SQL Server 2000 Administrators' Companion
Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.
Blogs
AI Experiments: Parsing Payment Memos
By Steve Jones
As part of my running the SQL Saturday charitable foundation, I get sponsorship money...
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers