Changing Storage for your SQL Server
A friend pinged me the other day with a question on SQL Server storage. He works as a Windows consultant,...
2010-03-18
2,215 reads
Minimizing Fragmentation when Moving data using a Switch
Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...
2010-03-17
815 reads
Using SSAS MDX Calculation Color Expressions
Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also...
2010-03-17
6,084 reads
SQL Saturday – A Few Lessons for Future Events
I’ve been to a few SQL Saturdays, and while most have run smoothly, I have a few comments on a...
2010-03-17
876 reads
Automating Imports from Access
Access is actually pretty good at importing files, and doesn’t on the surface work much different that import/export from Management...
2010-03-17
874 reads
Intel Xeon 56xx Series Westmere-EP Review
AnandTech IT has a quick review of the upcoming six-core, 32nm Intel Xeon 56xx processor, which includes several different database...
2010-03-16
1,966 reads
Dynamically Adding and Removing Columns to a Query and Report
Creating one report to meet multiple business requirements can save a lot of work
down the road. A common scenario is...
2010-03-16
814 reads
Return the Value of a Specified Dataset Row Outside a Data Region
I want to return the field value for a specific row to a textbox below a table in
my report. To...
2010-03-16
429 reads
User is prompted to login when viewing a report
A user has been added to a SSRS role for the report folder or report but is still
prompted to login....
2010-03-16
1,907 reads
How to parameterize a TOP values query
There are certain key words in a T-SQL query than cannot be parameterized, including
the TOP statement. Consider the followong attempt...
2010-03-16
801 reads
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