On vs. Where
Does it matter if you put your criteria in the ON clause or the WHERE clause? Well, as with most...
2009-09-30
1,781 reads
Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,999 reads
Jack Corbett Now Co-President of oPASS
I’m late announcing this here, but I’m pleased to announce my friend Jack Corbett is joining me in leading oPASS...
2009-09-29
1,617 reads
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,375 reads
Impact of uninstall instance on replication.
Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...
2009-09-29
1,673 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,580 reads
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,859 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
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,463 reads
Midlands PASS Chapter October Meeting
Next Meeting - October 6, 2009
Speaker - SQL Server MVP Brian Kelley
Trigger Happy Database Security
In this presentation we'll look at the use...
2009-09-29
1,832 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers