PowerShell: Delete Unneeded Rows/Columns In Excel
I had a project to automate the import of a large number of excel files via SSIS into SQL 2012....
2013-11-08 (first published: 2013-11-01)
7,032 reads
Blog Posts
Reblog: November 1 to November 7
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-08
919 reads
SSAS– Resolving target machine actively refused
I always wanted to have my hands on SSAS, SSIS and SSRS as I always feel short-hand in these areas....
2013-11-08
980 reads
What If Someone Tampered with the Process?
I’m a big fan of automation. Automation means I can do more. Automation means I eliminate the mundane stuff to...
2013-11-08
2,384 reads
What If Someone Tampered with the Process?
I’m a big fan of automation. Automation means I can do more. Automation means I eliminate the mundane stuff to...
2013-11-08
486 reads
Configuring the RecycleTime SSRS Setting
If you administer a SQL Server Reporting Services server, chances are you’ve had users complain the report manager is loading...
2013-11-07
4,587 reads
Create Semaphore in Sybase
It seems like I am going to write another none SQL stuff again. No. This is a real life scenario. I am writing an ETL for my customer to...
2013-11-07
23 reads
Create Semaphore in Sybase
It seems like I am going to write another none SQL stuff again. No. This is a real life scenario....
2013-11-07
1,235 reads
Do your Foreign Keys Hate You?
We all love our databases. We trust everything they do! How could we not? It's our baby.... well, probably not....
2013-11-07
324 reads
Free Online SQL Server Training for the Week of November 10, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-07
1,601 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