MCSD's who certified using Visual Studio 6 are eligible to receive a free exam voucher for the 70-300 exam. You must register for the voucher and take the exam before Sep 30, 2003. Follow the link or visit the MCP secure site directly to register. It takes about a minute and you'll receive a code to prevent to your test vendor when you schedule the exam. Thanks, Microsoft!
Brian Knight recently had the basic need to retrieve a record from the database at random. What seemed to be an easy task quickly became a complex one. This case showed an interesting quirk with T-SQL that was resolved in an equally quirky way. This quick article shows you a method to retrieve random data or randomize the display of data.
Chris Kempster (frequent contributor to the site) has released an ebook titled SQL Server 2000 for the Oracle DBA. The press release contains a brief overview of the book plus links to several reviews. Priced at $20 per copy, not bad at all!
What should SQL Server Central provide to the community in a review? Read on and give us some feedback so we can make this site better.
Several months ago Andy posted a 'Review of Developing Windows Based Applications for VB.Net and C#.Net' and mentioned that his company was requiring all developers to achieve the MCAD within 12 months. Read this to find out how the first exam went, how they studied, what they achieved, and their plans for taking the rest of the exams.
Lockwood Tech continues to grow it's product line! This link points to an info page provided by the vendor that highlights the capabilities of this reporting product.
This article looks at change management from the perspective of the DBA, including how to use source control to your advantage and planning for 'self-healing' apps.
This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexes
In this quick article by Jon Reade, he shows you how to correct an unusual error in SQL Server that may occur when you create a database.
This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't.
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers