PASS Update #13
It’s been a busy few weeks since update #12. We announced guidelines for submitting content to sqlpass.org, an effort that...
2009-08-23
738 reads
Blog Posts
SOX in the City - Preparations for Audit
As I was going through some of my documentation at past clients, I found my summary of the general SOX...
2009-08-23
2,461 reads
The Netbook: 40 Days In
I wrote last month about purchasing a new Toshiba netbook to supplement my mobile computing arsenal. Forty days later, I’m...
2009-08-22
611 reads
Welcome Home !!
I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us...
2009-08-22
1,215 reads
A True Sense of Community
We have a thread in our forums that many of the participants refer to as "The THREAD." It's a long...
2009-08-21
723 reads
Cumulative Update 5 For SQL Server 2005 SP3
Microsoft has released the latest Cumulative Update for SQL Server 2005 SP3, which is Build 4230. They also released a...
2009-08-21
474 reads
Denver SSUG – AUG 2009
I attended the Denver SQL Server User Group meeting, wanting to get a chance to catch up with some friends...
2009-08-21
1,111 reads
Ideas are a work of art
When you think about it, most of us in the IT field are paid to solve problems. Sure there are...
2009-08-21
382 reads
Keeping SQL Server Client Tools Up-to-Date
In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...
2009-08-21
1,412 reads
SQL Down Under Code Camp to be Held in October
If you live in Australia, or are just looking for an excuse for a vacation in Australia, sign up for...
2009-08-21
662 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
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...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
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
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