New Whitepaper: 5 Most Common Critical SQL Integrity Issues
Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to...
2013-09-16
1,212 reads
Backups, Encryption and Branding in San Diego
This weekend is SQL Saturday #249 in San Diego. I’m looking forward to the trip for a few reasons, but...
2013-09-16
831 reads
PowerShell – List Local or Remote Programs with an Exclusion List of Programs
This post is to list all the software installed on your local or remote machines. The exclusion list is an...
2013-09-16
1,278 reads
How to Check SQL Server Evaluation Version Expire Date ?
SQL Server Evaluation Edition is available free of cost. It’s a trial version & valid for limited time of period. The...
2013-09-16
27,095 reads
Last Weeks Top “Reading” Links #49
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-09-16
928 reads
Why the Lazy Spool Is Bad
First thing, there are no bad operators, just bad parents, uh, I mean query writers, or database designers, or ORM...
2013-09-24 (first published: 2013-09-16)
3,583 reads
DBA Myths: You can’t use an alias in an UPDATE statement.
I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an...
2013-09-16
898 reads
Notes from SQLSaturday #232 in Orlando
Our seventh annual SQLSaturday here in Orlando went well. To the casual observer it might appear to happen without effort,...
2013-09-16
670 reads
Loop Through Excel Files in SSIS
You can loop through excel files using SSIS. This will use the For Each Loop container and a data flow...
2013-09-16
1,999 reads
Announcing the SQLpassion Online Academy
Over the last weeks it was a little bit silent on my Weblog for a very good reason: I’m very...
2013-09-16
831 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