DBEzze is a freeware product that can look into a database and generate XML structural or data output. It can also generate INSERT statements from a table, view or stored procedure. This freeware product is available for download from SQLServerCentral.com members only.
2002-03-06
101 reads
Microsoft Corp. is considering bundling in the next version of Windows a pared-down version of its next-generation SQL Server database and the relational file system that goes with it.
2002-03-04
3,283 reads
Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.
2002-03-01
2,857 reads
This stored procedure shows you the growth patterns of your SQL Server database files and enables you to plan ahead for your future storage needs!
2002-02-28
105 reads
Please join Jim Gray, Distinguished Engineer at Microsoft Research, for this Q&A Session. Jim, the father of Structured Query Language, has been looking at LARGE databases like Google, Hotmail, BarBar, CERN, EOS/DIS, Internet Archive, and others that are either at a Petabyte or will grow to a petabyte scale in the next year or so.
2002-02-28
3,353 reads
Adept SQL Tools has released AdeptSQL Workshop, an IDE for SQL-based database schema creation and management. Includes fast drag'n'drop SQL decompiler, editor, preprocessor, SQL analyzer and difference engine, "revision history" scripts with a separate player utility for remote db deployment, integration with MS Visual SourceSafe. Pricing starts at $130,
$199 with VSS support.
2002-02-25
3,342 reads
Use this free stored procedure to compare two different SQL Server databases in order to discover how they differ. Sp_CompareDB can compare both table structures and the data stored in them. Also learn how the stored procedure was written.
2002-02-22
1,214 reads
myLittleAdmin For SQL Server is a web-based SQL Server Database administration tool. It is intended to handle the administration of SQL Server databases over the WWW using ASP. It allows you to fully manage your databases even when you don't want or cannot use MS Enterprise Manager.
2002-02-18
3,217 reads
A series of web presenatations from Microsoft about tuning SQL Server 2000.
2002-02-15
1,362 reads
SQL Server is releasing two Beta products this month, a 64-bit version of SQL Server 2000 and service pack 4 for SQL Server 7.0! Note: Liberty requires that customers have access to 64-bit machines. Participating in a SQL Server Beta program can be a lot of fun, with contests, promotions, newsgroup support with members of the SQL team at Microsoft, etc. Come sign up today!
2002-02-11
3,269 reads
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Comments posted to this topic are about the item Where Your Value Separates You...
Comments posted to this topic are about the item Fixing the Error
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers