Articles

Technical Article

Visual Studio 6 MCSD's Eligible to Take 70-300 Free

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!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-03-27

1,330 reads

SQLServerCentral Article

Gathering Random Data

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2003-03-26

9,485 reads

SQLServerCentral Article

We Studied, We Passed, Was It Worth It?

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-03-21

7,791 reads

Blogs

Word to the wise: don’t turn on SQL vulnerability checks on a blog about SQL

By

Recently, in an attempt to thwart leechers (1990s kids will know), I added some...

Dazzling Stuff in Databricks (SQL) – Qualify

By

Once upon a time I had a series about some cool stuff in Snowflake:...

Advice I Like: Overnight Success

By

“Most overnight successes – in fact any significant successes – take at least 5...

Read the latest Blogs

Forums

Why Successful SQL Server Backups Are Not Enough

By Almighty

Comments posted to this topic are about the item Why Successful SQL Server Backups...

Adding Bits II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Bits II

An Unlimited Token Budget

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Unlimited Token Budget

Visit the forum

Question of the Day

Adding Bits II

I have a table, dbo.bittest, where I am testing an application response. This has this structure:

CREATE TABLE [dbo].[BitTest]
(
[insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()),
[a] [bit] NULL
) ON [PRIMARY]
GO
My application runs this code:
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, true)
GO

See possible answers