Using PowerShell to Export SQL Data to CSV. How well does it perform?
So here we are at week 4 of the #SQLNewBlogger challenge. Earlier in the week I responded to the following...
2015-05-07 (first published: 2015-04-28)
33,499 reads
Blog Posts
Video: Bringing Together Databases, Virtualization and Storage
Bala Narasimhan, Vice President of Products from PernixData, and I recently sat down and discussed the convergence of infrastructure, SQL Server,...
2015-05-07
372 reads
Azure SQL Data Warehouse
Analytics Platform System (APS) is Microsoft’s massively parallel processing (MPP) data warehouse technology. This has only been available as an on-prem...
2015-05-06
1,342 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent...
2015-05-06
195 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent...
2015-05-06
170 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent of an instance. It’s an useful job that you...
2015-05-06
7 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent of an instance. It’s an useful job that you...
2015-05-06
11 reads
Join me Tues, May 12 – Consumption Based Architecture for BI
Join me on Tuesday, May 12 as I discuss consumption based architecture for BI Solutions with Pragmatic Works.
2015-05-06
576 reads
May 2015 – SQL Server Monthly Maintenance Checklist
image source
It’s time for a monthly reminder to review you SQL Server environment. Hopefully over the last few months of...
2015-05-06
654 reads
Moving SQL Server data between filegroups – Part 2 – The implementation
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups...
2015-05-06 (first published: 2015-04-28)
7,175 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers