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,726 reads
Should you use this book to prepare for the 70-100 exam? Read the review and find out!
2001-12-26
3,726 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,300 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
277 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,212 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,802 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,671 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,507 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,472 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,114 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,299 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers