XML Workshop IV - FOR XML EXPLICIT
Continuing on with his series and quest to educate us DBAs on the capabilities of SQL Server 2005 with regards to XML, Jacob Sebastian looks at the FOR XML EXPLICIT clause.
Analysis Services 2005 defines for peak performance
Analysis Services 2005 in SQL Server improves cube design and performance. Learn how attribute relationships advise Analysis Services how data should be rolled up.
SQL Server 2005 Express Edition - Part 3 - Installation
Part 3 of this series describes the installation process of different versions of SQL Server 2005 Express Edition in more detail, including changes introduced in its Service Pack 2.
Katie's Raffle
We've had more prizes donated for the raffle to raise money for Katie. See what you can win and support an IT family in need.
Professional Development Plans
Ensuring that our careers grow is something that each of us must take charge of and Andy Warren brings us one of the ways in which you can do this: create a plan. Andy talks about how you can structure a plan at different stages of your career.
Custom reports in Management Studio, using the Performance Dashboard
If you are using SSMS and SQL Server 2005 SP2, You've probably tried out the database reports that are available in the Performance Dashboard, and decided how useful they are, but did you know that you can create your own dashboard reports?
Reporting@Home: Delivering Dynamic Graphical Feedback to Participants
A new generation of computationally intensive scientific research projects relies on volunteers from around the world contributing idle computer time to calculate mathematical models. Many of these projects utilize a common architecture to manage the scheduling and distribution of calculations and collection of results from participants. User engagement is critical to the success of these projects, and feedback to participants illustrating their role in the project’s progress is known to increase interest and strengthen the community.
Server Farm Reporting - Part 2
Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process.
Case Study: Denver International Airport Keeps Operations/IT (and Pass
AlarmPoint Enterprise automates alerting process and protects airport's massive information and communications network from business-impacting outages.
Compatibility of SQL Server 2005 and 2000 coexisting
When installing a SQL Server 2005 instance on your SQL 2000 machine, there are upgrade and compability issues such as linked servers, multi-server administration and log shipping.
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers