Powershell is great (as am I) for automating boring little tasks. So the question came to put 18 thousand plus image files that were in one folder into folders per year of Date created. So to no longer keep you in suspense, here is the complete code PowerShell1 2 3 4 5 6 7 8 […]
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Recently I needed access to the list of commits that were included with each of my TeamCity builds. TeamCity provides a pretty big list of Predefined Build Parameters, but it doesn’t provide access to details of the commits it is currently building. Having Powershell and Git on my server, though, I can write some scripts […]
Azure Hosted Services offers several really awesome features over using physical servers or standard VM infrastructure. Two of these are the staged deployment model and management SDK, which includes a powershell module. Using these two features, we are going to build a deployment script that deploys a new set of services (servers) in Azure, using […]
When you have Storage Analytics transaction logging turned on, it produces transaction log files for each service call you make to blob, table, or queue service. Unfortunately it captures these in multiple files per hour, stored in a folder hierarchy by service (blob, queue, table), year, month, day, and hour. Trying to dig through these […]
This blog post explains how you can add environment references in a PowerShell deployment script for SSIS 2012.
Recently, while working on a personal project, I found myself needing a lightweight way to deploy database changes to multiple environments. In the past I have used a wide range of methods, ranging from applying the changes manually to applying changes via a diff tool (SQL Compare), to automatically applying manually created change scripts, to automatically applying diff scripts that were automatically generated, to working directly in production..er, pretend you didn’t see that one.
In a previous post I showed how to get remote disk information with PowerShell. The script works nice untill you execute it on a server with Mount Points. When executing the following script on a server with Mount Points:
Every DBA managing multiple SQl Servers with multiple instances will know the issues with developpers, project managers and others that don’t know the importance of the instancename when they request you to take some action.
So you can start some e-mai…
A couple of weeks ago someone asked me why they should upgrade to MS SQL Server 2012. I named a bunch of reasons and only remembered afterwards that the possibility to use Windows Server Core could also be a surplus. Just 2 days later this Case for Core…
I’m preparing my demo’s for a MS6235A SSIS training I will be teaching in a couple of days. In one of the demo’s I just copy a SSIS package from the file system to SQL Server using the DTUtil from the command prompt with this command:
DTUTIL /FILE <…