Visual Studio Team System for Database Professionals CTP 5 Out
If you aren't aware, the Visual Studio Team System for Database
Professionals CTP 5 is available for download. It's a significantly
larger...
2006-08-23
1,429 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
The Importance of Database Coding Standards
I was working with a developer the other day and the question came up
of how to return status from a...
2006-08-17
1,825 reads
Presentation slides and sql scripts up
I have posted the slides for the presentation I gave to the DotNet Columbia User Group.
The talk was called, "Something...
2006-08-09
715 reads
Visual Studio Team System - Database Professionals: Database Connection Error
If you're like me, you don't have SQL Server 2005 sitting on the
default instance because SQL Server 2000 is sitting...
2006-08-06
660 reads
Excellent article on SQL Server 2005 Common Table Expressions
SQL Server MVP Nigel Rivett has written an excellent article on Common Table Expressions on Red Gate Software's Simple Talk...
2006-08-02
754 reads
Identifying NTLM vs. Kerberos authentication using Fiddler
I saw this post on using Fiddler to tell the difference between an NTLM and a Kerberos connection to a...
2006-08-02
4,556 reads
Does your organization need a DBA? (part 2)
This is a follow-on to Does your organization need a DBA? and Andy Leonard's Database Professionals: An Enterprise Requirement.
I was...
2006-08-01
693 reads
Does your organization need a DBA?
Andy Leonard pens the following blog entry:
Database Professionals: An Enterprise Requirement
There are quite a few organizations that feel they can...
2006-07-30
1,536 reads
Succint Article on Encypting File System (EFS)
Encrypting File System, or EFS, first debuted in Windows 2000 and gave
users to encrypt files without a 3rd party tool....
2006-07-30
1,587 reads
Detecting SQL Server 2005 Properly
There is a new post in the SQL Server Express blog which indicates the
right way to detect SQL Server 2005:...
2006-07-29
1,474 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers