Joins Clarified
Sometimes its good to get back to basics - or to make sure you really know all the basics. This is a very good intro to all the different join types.
2004-04-16
15,473 reads
Articles
Beginning SQL Server 2000 Administration Part 1
Are you a new SQL Server administrator? A network admin or developer who got the responsibility for a SQL Server dropped on your head? Steve Jones starts a new series looking at a few of the things that you might want to know if you've never worked with SQL Server before.
2004-04-15
19,735 reads
Review of SQL2K Resource Kit
Good enough for your bookshelf? This one meets that requirement for Brian, click the link to find out why.
2004-04-13
8,904 reads
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.
2004-04-13
69 reads
Review of SQL Sentry (Lite)
Leo reviews a new product as a follow up to his recent article about Monitoring Failed Job Steps.
2004-04-12
4,440 reads
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.
2004-04-09
8,667 reads
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!
2004-04-08
9,871 reads
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!
2004-04-07
6,635 reads
Tame Those Strings - Using SUBSTRING
In this article by Steve Jones, he shows you how to manipulate strings.
2004-04-05
17,691 reads
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.
2004-04-01
289 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Distributed Availability Group Issue / Misunderstanding.
Not sure if this is a tech mistake I've made or a lack of...
Large posts full of code not allowed anymore?
Several times now, I've seen a post asking for a solution. I've replied, and...
Data > Hype
Comments posted to this topic are about the item Data > Hype
Question of the Day
Slipstream parameters
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers