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,540 reads
Windows Temporary Profile
Amongst IT related problems one that can fill this most ardent optimist with dread is when logging into your pc...
2015-04-28
812 reads
Use PsPing When Working in Azure IaaS
Recently I’ve been learning more about how Azure functions and how it can help my customers. One of the best...
2015-04-28
1,121 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 on SQL Server. This article is the second of our...
2015-04-28
24 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,200 reads
Clustered Columnstore Indexes – part 52 (“What’s new for Columnstore XE in SQL Server 2014 SP1”)
Continuation from the previous 51 parts, the whole series can be found at http://www.nikoport.com/columnstore/
Microsoft has launched Service Pack 1 for...
2015-04-28
488 reads
Approaches to deploying Sql Server database code
When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated "compare...
2015-04-27
594 reads
Approaches to deploying Sql Server database code
When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated “compare...
2015-04-27
79 reads
Approaches to deploying Sql Server database code
When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated “compare...
2015-04-27
77 reads
BIML is better even for simple packages
BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a...
2015-05-07 (first published: 2015-04-27)
7,543 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers