Beware to the System Generated Constraint Name
New columnist Gregory Larsen used to not care what his objects were called until recently when he began to become concerned with the system generated constraint names. This short article tells you why.
Interact with SQL Server's Data and Procedure Cache
This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.
Try SQL Server 2000 Service Pack 3 Early!
Microsoft is now accepting nominations for beta testers for SQL Server 2000 (64-bit), SQL Server 2000 Windows® CE Edition (SQL Server CE) version 2.0, and SQL Server 2000 Service Pack 3 (SP3). Any SQL Server customer can participate.
DDL Archive Utility 2.0 Released as Freeware
Bill Wunder has done it again with his newest release of his DDL Archive Utility, which can pull entire schemas into Source Safe automatically.
Sort of Unique
Recently Steve Jones noticed that someone wanted to use a UDF to enforce uniqueness. No big deal, right? Well this person wanted to enforce uniqueness based on some other column value. A bit of a challenge, but this article presents a couple ways to handle this.
Creating Stored Procedure Documentation with XML, SQL-DMO and XSLT
This article introduces TSQLDoc, a Windows Script Host script that extracts procedure metadata and embedded documentation comments from Transact-SQL stored procedures, generates XML documentation for every stored procedure in a database and optionally transforms the XML document into HTML or other format using XSLT.
Converting Shaped Recordsets into XML
This article shows you how to take a shaped recordset and convert the results into XML all while preserving the shaped recordset hierarchy.
Ansi Options Part 3 - ANSI_NULL_DFLT_ON
The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.
Sneak Preview: Start to Finish Guide to SQL Server Performance Monitor
Get a sneak peak of some of the sections from Start to Finish Guide to SQL Server Performance Monitor. Find out what counters to watch and what their thresholds are.
How to troubleshoot orphan users in SQL Server databases?
This article explains how orphan users get created, and provides you with troubleshooting information. A bonus stored procedure called ShowOrphanUsers is included, that goes and searches all the databases and generates a complete list of orphan users.
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Alamat BCA KCU Rawamangun Telp:0821-815-4374
Telp/WA +62 821-815-4374 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Alamat BCA KCP Permata Ujung Menteng Tlp:0817-825-533
Telp/WA +62 817-825-533 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil,...
Alamat BCA KCP Matraman Telp:0821-755-5651
Telp/WA +62 821-755-5651 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers