The Detroit Area SQL Server Special Interest Group
The user group in Detroit is back and looking for new members. If you are in the area, check out the announcement for their next meeting.
The SQL Site Map Provider You've Been Waiting For
SqlSiteMapProvider reads site maps from SQL Server databases. And it takes advantage of the ASP.NET 2.0 provider architecture to integrate seamlessly with the site navigation subsystem. Just create the site map database and register SqlSiteMapProvider as the default provider, and then, like magic, everything else just works.
The Pitfalls of Foreign Keys
What is the cost of DRI and is it something that you should implement? SQL Server expert David Poole takes a look at the impact of adding DRI to a CMS system and provides some real world results on which you can base your decision.
Case Study of Building a Data Warehouse with Analysis Services (Part T
In Part Two of his series, database administration expert Baya Pavliashvili explores the challenges involved in building and maintaining a warehousing solution using a simple database warehouse.
Printing in .NET
A bit of a break from the SQL Server side with this great new .NET class developed by new author Jereme Guenther. He prints a page character by character to handle control of formatting. Take a look and see if this solves any of your .NET printing problems.
Case Study of Building a Data Warehouse with Analysis Services (Part O
In the first of a two-part series, Baya Pavliashvili, database administration expert, offers solutions to your business problem using a data warehouse.
The Zero to N Parameter Problem
T-SQL has some well known limitations when working with parameters for a stored procedure, not the least of which is a variable number of parameters. While there are some solutions, they can be cumbersome to work with. Sloan Holliday brings us a creative solution using XML that can solve many issues.
Indexing Guide: The art and science of SQL Server indexing
You can improve your SQL performance by using indexes. But you have to choose the proper indexes and make sure the ones you do choose fit into your business situation. In this indexing guide, you will find answers to common indexing questions, indexing dos and don'ts, and tricks for working with the Index Tuning Wizard to improve overall system performance for SQL Server 2000 servers. This is particularly useful for servers that need a boost before they are upgraded to SQL Server 2005.
Utility Procedures
Have you ever wanted to create your own utility procedures in SQL Server? Maybe your own information schema view? SQL Server export David Poole brings us an article dicussing these very topcis and offers advice on how to proceed.
Stored procedure: Generate code for ad hoc data operations
A SQL Server DBA often needs to perform ad hoc operations on data in their databases. The tasks can typically be handled with simple T-SQL statements, but other times a more complex operation is called for – and having to manually enter all the T-SQL code necessary for such an operation is not appealing! It can be difficult to perfect the syntax, and tedious to list column names once, twice or even three times. Fortunately, useful template code can be easily generated instead of being entered by hand.
Blogs
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...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
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...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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