Author: Jimmy Nilsson – Excerpt from chapter 5 “Architecture” – In this chapter, we’ll look at several different architectural styles – a database-independent and pure object-oriented architecture, a database-centric architecture, and the classic Windows DNA architecture. We’ll also spend time looki

If you are working with databases in MS Visual Basic then this is a tool for you! CLASSter supports MS Access, Sybase ASE Server, MS SQL Server and Oracle Server database brands. Forget forever about annoying database access coding, all these endless manipulations with ADO objects! It will take CLAS

By Michael D. Reilly – If you’re a network administrator who has recently become a database administrator, too, the task of creating and maintaining database files for your company’s developers might seem daunting. Fortunately, this task is much easier with Microsoft SQL Server 2000 and SQL Server 7

by Roger Jennings – The emergence of XML as the lingua franca of data interchange has caused an increasing demand for storing hierarchical XML documents in relational databases. Inserting XML documents in [n]varchar or [n]text columns of SQL Server tables is easy, but retrieving rows containing rele

By Alexander Chigrik – When SQL Server is installed the setup program creates tempdb database. Tempdb is a system database used by SQL Server to store temporary tables and temporary stored procedures, for sorting, subqueries, and aggregates with GROUP BY, ORDER BY, for cursors and so on. Tempdb data

I have seen information about how sort order affects performance in SQL Server 6.5, but I can not find similar information about sort-order performance in SQL Server 2000 or SQL Server 7.0. I am trying to decide if using binary sort makes sense for my SQL Server 2000 application. What is the perform

By Brian Moran – Microsoft announced a new SQL Server quality assurance program last year called the SQL Server Playback Program, and the company is now actively seeking a new round of SQL Server Playback customers to get ready for the Yukon rollout in 2003.

by Brad M. McGehee – Over the last five years that I have been a SQL Server DBA, I have put together a mental checklist that I use when it comes to performance tuning SQL Servers. I use this checklist as a guide when I perform a “performance audit” a (new to me) SQL Server for the first time. I […]

Since it’s introduction in ADO 2.0, data shaping has remained largely on the fringes of Visual Basic arcanum. Relegated to the back pages of musty manuals, you may have overlooked this useful aspect of ADO. If you’re not familiar with data-shaping, in essence, it lets you create recordsets within

by Walter Myers III and David Byres – The best cure is prevention. That’s why user authentication is the cornerstone of any software security system. And it seems easy: You can authenticate users with SQL Server’s own security mechanism, typically by passing a set of security credentials in ADO code