To Get Certified or Not Get Certified
I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think...
2010-03-29
930 reads
Glenn Berry
Recovery Models and Backup Strategies for SQL Server 2008
I had a question via e-mail from one of my new students at University of Denver, University College this morning,...
2010-03-25
3,061 reads
Creating SQL Server 2008 Databases with T-SQL
Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file...
2010-03-24
1,397 reads
Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-22
9,330 reads
SSWUG Ultimate vConference Discount Code
The SSWUG Ultimate Virtual Conference is coming up on April 7, 8, and 9th. This is three days of very...
2010-03-22
833 reads
The Coming Upgrade Tidal Wave
Microsoft is poised to release new versions of several different products and technologies that have the potential to have a...
2010-03-18
722 reads
Intel Xeon 56xx Series Westmere-EP Review
AnandTech IT has a quick review of the upcoming six-core, 32nm Intel Xeon 56xx processor, which includes several different database...
2010-03-16
1,946 reads
SQL Server 2008 SP1 CU7 is Released
Microsoft has released SQL Server 2008 SP1 Cumulative Update 7 (CU7). It is Build 2766. There are 31 fixes listed,...
2010-03-16
1,528 reads
How to Enroll a Managed Instance into SQL Server Utility in SQL Server 2008 R2
After creating a Utility Control Point (UCP) you will want to enroll some managed instances (up to 25 with SQL...
2010-03-16
1,299 reads
Denver SQL Server User’s Group Meeting on March 18
The Denver SQL Server User’s Group will be having their March meeting on Thursday, March 18. Bulent Gucuk will discuss...
2010-03-15
761 reads
Blogs
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
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...
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