Guide To MCITP: SQL Server 2008 Administration
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
8,813 reads
MCTS
Guide to MCITP: SQL Server 2008 Developer
An overview of what's involved in the two exams you need to pass to become a Microsoft IT Professional in SQL Server 2008.
2009-08-21
10,430 reads
70-433 Or Bust: Working toward MCTS Microsoft SQL Server 2008 Database Development
The 70-433 will be my first Microsoft certification test. There are two main reasons why I've decided to take on this quest. The first reason is to "fill in the cracks." Even on fundamental topics I've found myself saying "oh
2009-07-31
4,391 reads
RE: data entry best practice
cheers Andy, I was previously unaware about 'scope_identity' thanks, yogi
2003-08-14
RE: Dynamic Index Creation
Hi Tim, quote: I'm trying to create an index dynamically on a temp table in an sp. I can build the statement happily but the index MUST by desc. SQL seems to have a problem with DESC. If I create an identical physical table and run the statement the sp builds, it's fine (either asc […]
2003-08-14
1 reads
RE: Does Your SP Choke on Errors
I haven't run the procs as described in the article but the most troubling error handling I've had to deal with are errors like PK violations that abrubtly halt the entire batch that was sent by the client, in this case no matter how far you've nested the procs, the entire process is aborted and […]
2003-06-26
1 reads
RE: Is there a way to tell who dropped a table?
There are transaction log viewer utility applications out there that allow you to see thi ssort of information. Lumigent's Log Explorer is one such tool.
2003-06-20
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers