70-100 MCSD Architectures Exam Cram
Should you use this book to prepare for the 70-100 exam? Read the review and find out!
2001-12-26
3,725 reads
Should you use this book to prepare for the 70-100 exam? Read the review and find out!
2001-12-26
3,725 reads
In three previous articles Andy has done a very basic introduction to the ADO connection, command, and recordset objects. In this wrap up article he talks about how to use the power of ADO client side filtering and disconnected recordsets, then adds some code which shows how to combine all the objects. ADO is not simple, but Andy has done a good job in limiting his dicussion to the things you REALLY need to know about ADO to get started.
2001-12-07
10,292 reads
Andy Warren thinks certifications are worthless. That's opinion came after he obtained his MCDBA and MCSE certification. Find out why he thinks you should not be certified in this debate with Steve Jones.
2001-11-13
276 reads
In this article, Andy Warren presents his views on why obtaining certification is not a good idea. Read this one and the one by Steve Jones that supports certification - which has the more compelling argument
2001-11-04
6,208 reads
In this product review Andy takes a look at Data Compare, the second of three products in the SQL Bundle available from Red-Gate software. It's a very handy program that lets you compare data between two tables and optionally generate sql statements to syncronize the data. An interesting alternative to replication!
2001-10-31
8,801 reads
Early in September Andy posted an article that explained how to use DMO to reattach a lot of MDF's in a hurry AND challenged our readers to accomplish the same task in T-SQL. Today we announce the winning solution!
2001-10-02
5,670 reads
Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.
2001-09-17
11,505 reads
Attaching and detaching databases isn't rocket science, but if you have a lot of databases to attach it's pretty boring. Andy has written some VB code that uses SQL-DMO to speed up the process. But DMO isn't the only way - can you write a TSQL script to do the same thing? Fame and fortune await!
2001-09-04
6,471 reads
The SQLParser object - mostly undocumented - gives you an easy way to convert a TSQL string into a colorized RTF string. Andy started with that and wrote some code to change it to HTML. Useful? Never know! Code and demo program included with the article.
2001-08-31
8,113 reads
Sometimes as hard as you look you just can't find the answer or idea you're looking for - that's when a good discussion forum comes in handy! Read this article for some tips and tricks on using our discussion forums successfully. Then when you have time, browse our current discussions and see if they work.
2001-08-07
2,298 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Not sure if this is really a relational theory question but it seems about...
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
Hi all, I recently moved to a new employer who have their HA setup...
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers