SQL Server Needs Revision
What's wrong with SQL Server? Lots of things to some people, but here's a look at where this product is positioned in the marketplace against the other RDBMSes.
Users From Hell
A little off topic (or is it?), David needed to vent a little - something we can all appreciate. Meant to be light hearted fun, please don't take too seriously.
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.
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.
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!
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Altira Sunter Tlpn/Wa 0853.7373.7551
Altira Bussiness Park, Jl. Yos Sudarso Kav 85 Blok B No.1-2, Sunter Jaya, Kec....
BCA KCP Soepomo Telpon/WA:08137887595
BCA KCP Soepomo Telpon/WA:08137887595.Alun Graha, Jl. Prof. DR. Soepomo SH No.233 Lt. Dasar, RT.007/RW.1,...
BCA KCP Teluk Mas Tlpn/Wa 0853.7373.7551
Komplek Ruko, Jl. Soka 1 Jl. Terusan Bandengan Utara No. 95 G-H, Pejagalan, Kecamatan...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers