PowerSMO at work part 2
Dan Sullivan continues his exploration of the versatile PowerSMO tool with coverage of how to control logins, monitor server activity and create standalone administrative scripts.
2007-04-02
2,261 reads
Additional Articles
Use SQLIOSIM to simulate SQL Server disk activity
I regularly use SQLIO.EXE to gauge the maximum throughput a disk subsystem can sustain. Recently Microsoft released SQLIOSIM.EXE to provide better results for this type of test. However they didn't release any documentation on the tool and I could never figure out what it was trying to tell me. It looks like they finally did release a Knowledge Base article on SQLIOSIM. Give it a spin. I'd be curious to hear what you think of the tool.
2007-03-30
2,768 reads
Black Belt Administration: Performance Dashboard for Microsoft SQL Ser
Diagnose performance problems in MSSQL Server 2005 with a powerful new administration tool. BI Architect Bill Pearson provides hands-on guidance in installing and using this powerful new dashboard / report pack, freely available to MSSQL Server 2005 users everywhere.
2007-03-29
3,678 reads
The SQL Server helper table workbench
Robyn Page and Phil Factor demonstrate some set-based techniques for string manipulation and time interval-based reporting, which use helper tables rather than iterative logic or the dreaded cursor.
2007-03-28
2,039 reads
How To Video: Creating a Proxy Account
In this session by Brian Knight, he shows you how to create a proxy account for SQL Server Agent to use. Proxy accounts and SQL Server 2005 credentials help you impersonate another Windows account in Agent.
2007-03-26
1,438 reads
SQL Server 2005 Integration Services - Part 44 - Bulk Insert Task
Recent installments of our series dedicated to SQL Server 2005 Integration Services have discussed individual Control Flow tasks. This installment covers one of the few remaining items in this category, the Bulk Insert task.
2007-03-22
2,943 reads
Introduction to Data Warehousing Part 1
In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.
2007-03-21
3,746 reads
Mastering Enterprise BI: Time Intelligence Pt. II
BI Architect Bill Pearson continues his introduction to enhanced features in Analysis Services 2005 for Time Intelligence support. In this session, we examine new, wizard-driven features that support the easy addition of Time Intelligence within our cube.
2007-03-20
2,669 reads
Designing A Data Warehouse: Part 1 Dimension Types
In this first part of a multiple part series, Brian Knight shows the different types of slowly changing dimensions you'll use and the business reason for using each type.
2007-03-19
4,753 reads
Different forms of CrossJoin
This article is about different syntactical ways to write CrossJoin in MDX, all of which are completely equivalent from the functional and performance standpoint. Therefore, the article doesn't convey any practical information, and can be ignored. Readers curious about history of MDX can keep reading, however.
2007-03-16
3,902 reads
Blogs
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers