Container Tasks in SQL Server 2008 Integration Services
Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.
Installing Data Protection Manager 2007 as a VM in a lab environment
This article describes how to install DPM 2007 as a virtual machine in a lab environment. Here are the gotchas to look out for and an explanation of the benefits you can realise.
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
SSD, The Game Changer
I’ve often described SQL Server to people new to databases as a data pump. Just like a water pump, you have limited capacity to move water in or out of a system usually measured in gallons per hour. If you want to upgrade your pumping systems it can be...
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
SCOME - Centralize Monitoring with ASP.NET - Part 1
New author Drew Salem brings us a series on how to centrally monitor your SQL Servers. He includes ASP.NET code and a framework that will check your servers and display a report for you. This article presents an overview of the dealing with the SCOME issue.
Configuring the Maximum Degree of Parallelism
How to configure settings to limit the number of processors used in parallel query execution
Do SQL Server User Defined Datatypes (UDT) affect performance?
There is a legend among SQL Server developers and DBAs saying that UDTs may degrade performance. In this article I prove whether this believe is right or wrong.
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers