Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 10
This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script.
October Energy Update
A recap of the world of energy from the previous two months. Steve looks at solar, wind, nuclear, and more.
SQL Server Integration Services Automation
After completing a project with SQL Server 2005 Integration Services, author G Vijayakumar brings us his technique for an automated scheduling of various source data into a data warehouse with multiple packages.
Service Broker Advanced Basics Workbench
SQL Service Broker, an asynchronous queuing and messaging system for SQL Server 2005, is set to change the way we design and run distributed applications. Adam Machanic once more makes it all seem so easy in Part 2 of his epic series
SQL Server 2005 Express Edition - Part 9 - Managing User Instances
SQL Server 2005 Express Edition's unique functionality allows you to distribute and implement single-user databases, without the dependency of having administrative privileges or the need for a cumbersome configuration. This article illustrates the practical use of this feature, known as XCopy deployment.
Microsoft BI Certifications or Why SQL is a 4-Letter Word
A look at the BI certification experience of a senior consultant and developer. New author
Mining or Profiling
The more data you have, the better you should be able to predict something. Or at least that's one of the things that I learned while studying economics. If we could actually gather enough data about someone or some system, we could determine what the most likely outputs of the system will be. In the […]
Aggregating Correlated Sub-Queries
Every now and then you may attempt to calculate an aggregate function -- such as SUM() -- on a correlated subquery, only to encounter the following error:
Output Parameters
Regular columnist Robert Marda writes about the basics of using output parameters. If you're not using output params we hope this article will get you started - they are a great way to return less data to the client, perfect if you need only a few values and not a recordset/resultset.
What's Fair
If you read my recent editorial called Get Some Help, you realize that I didn't get any World Series tickets from the sale on the Colorado Rockie's web site. Not to berate the subject, but some friends and I had an interesting debate on how the situation was handled and what could be done differently.
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers