An Interesting Article on Unicode and Character Sets
This may well be more than you want to know about Unicode (and no, it's not a SQL article), but it's a pretty useful discussion to have.
2003-10-21
70 reads
Additional Articles
xSQL Object Public Beta
xSQL Object for Microsoft SQL Server has been designed with the DataBase Administrator in mind. Scripting, Comparing and even Synchronizing different objects like tables, views, stored procedures etc. is fast and easy.
2003-10-07
514 reads
SQL DMO Poster in PDF!
Last year we did a project with Lumigent to create a DMO poster. Part of the agreement allows us to now distribute the PDF version to our readers. It's about a 400k file, print size is 24x36. We hope you DMO users will find it useful.
2003-10-03
1,901 reads
Database Workbench 2.3.1 released
Database Workbench is a powerfull developer tool that includes support for Microsoft SQL Server, version 7, 2000, MSDE 1 & 2. It let's you create schema objects from a convenient interface, transfer data or profile your database by displaying query plans or creating thousands of rows of test-data.
2003-10-02
214 reads
New Table Structure Compare Tool in Beta
Aladdin is an "alter table" script generation tool for SQL Server 7/2000.
Aladdin is currently in BETA. They are currently looking for for 25 people willing to use the beta product and report their experiences. Users who fully participate in the beta will get a free, single user license when the product is released. To participate in the Aladdin BETA program, please download the software and send an email to Ken Otto: ottosoft@hotmail.com - Subject: Aladdin Beta Test.
2003-10-01
1,065 reads
Storage Performance Council
The Storage Performance Council (SPC) is a non-profit corporation founded to define, standardize, and promote storage subsystem benchmarks as well as to disseminate objective, verifiable performance data to the computer industry and its customers.
2003-09-30
290 reads
Log Navigator Database Auditor Released
Log Navigator 1.0, a passive SQL auditing system that uses the SQL Server transaction log, instead of triggers, to audit data changes has been released.
2003-09-29
1,076 reads
Office Design - This is the way to do it!
Another article by Joel Spolsky, this one discusses how and why he designed new office space for his development team. Maybe a little over the top, but we think he has the right idea.
2003-09-26
1,592 reads
Upgrading from Erwin to Embarcadero?
Embarcadero is offering a 40% discount off the retail price if you upgrade from Erwin before Sep 30, 2003. Follow the link for details (subject to change!).
2003-09-26
645 reads
Free SQL Functions & Stuff!
Wingenious is offering a free download of some add-in code you may find very useful! It's a subset of their DBAction product (which they you'll look at as well), but the free code is worth a look.
2003-09-24
48 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Performance
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers