More on the MVP SQL Server book
If you buy from Manning directly today or tomorrow, there’s a 50% discount . Use the code pop0928 at the checkout....
2009-09-29
1,369 reads
Blog Posts
Off-Hours Work: A Guide For Managers
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-09-29
1,855 reads
Reporting Services resources
Thanks to everyone who attended my SQL Server Reporting Services class in Nashville over the last couple of weeks. As...
2009-09-29
1,606 reads
Space Sensitivity in SSIS Lookups
It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup...
2009-09-29
2,738 reads
SQL Server MVP Deep Dives
I’ve been reading through this book and it really does have something for everyone at any level.
I think it...
2009-09-29
1,461 reads
Temp tables and scope
create table MyTable (id int)
go
Create Table #Test (id int)
go
create proc MyProc
@id int
as
insert MyTable select @id
insert #test select...
2009-09-29
1,703 reads
Vote for Mr. LaRock
It is rapidly coming up on election time at the Professional Association of SQL Server users (PASS). Once more, a person...
2009-09-29
1,576 reads
Adding a folder to the SSIS Package Store
The SSIS Package Store is a nice option available for storing SSIS packages. The Package Store lists packages stored on...
2009-09-28
6,345 reads
Arrive in Sydney To Begin 30-Day Australia & New Zealand Speaking Tour
I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9...
2009-09-28
422 reads
Arrive in Sydney To Begin 30-Day Australia & New Zealand Speaking Tour
I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9...
2009-09-28
485 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers