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,846 reads
Blog Posts
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,588 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,730 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,456 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,692 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,566 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,328 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
415 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
479 reads
Back From Vacation and Making a Big Mistake
I actually got back from camping Sat night, but since I wasn’t scheduled to come back until Sun afternoon, I...
2009-09-28
651 reads
Blogs
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers