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,012 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
915 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
976 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
485 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,379 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,565 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
12 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,225 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
313 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
358 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers