Business Intelligence in SQL Server 2005, Part 1
This article takes a look at SQL Server 2005 Reporting Solutions as applied to Business Intelligence systems.
Beauty is in the Eye of the Beholder
Is dynamic SQL good or bad? We've had lots of arguments over the years in the forums and articles on both sides of the coin, though with most of the opinions being that dynamic SQL is bad. Stephen Hirsch brings us his own view that beauty is in the eye of the beholder.
Demo of Visual Studio Team Edition for Database Professionals
In this video by the product's Program Manager, Sachin shows you a "whistle-stop" tour of the features of Visual Studio Team Edition for Database Professionals. This is the first part in a large series all on Microsoft's new development and administration platform for SQL Server.
Data Quality
What is data quality? How do you measure it and how does it affect your data warehouse? SQL Server warehousing expert Janet Wong brings us a look at what data quality is and what it means to you.
SQL Server 2005 – DML Usage on an untyped XML column
Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.
Using and Monitoring SQL 2005 Query Notification
The aim of this article is to show you how to make full use of SQL 2005 query notification with ASP.NET 2.0. It tackles the implementation details largely from SQL Server's perspective and includes many DBA tips and tricks for troubleshooting query notification.
SQL Server Spotlight on Steve Schmidt
Steve Schmidt, the backup guy for SQL Server, spent a few minutes talking about his work on SQL Server and life. A look at another very interesting member of the SQL Server development team.
Clustering SSIS
By default, SSIS is not an easily cluster-aware product. In this video, Brian shows you how to cluster the service and make it highly available.
Time for Training
Keeping up with your professional development is tough. In the first part of his series, Andy Warren talked about the challenges of keeping current. This article takes a look at how you can effectively find time to grow your career.
Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Se
This article discusses: Extensibility in SQL Server 2005 Reporting Services, Creating and debugging custom report items, The ProgressTracker CRI sample.
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