Home

Can you import this JSON?

In a recent project, I got the opportunity to learn way more about the SQL Server (2016 and later) JSON functions than I would have even imagined. The task was to “get it imported”. Much like a staging table, the goal here was ingestion, not normal form or relational design (although some of that came … Continue reading Can you import this JSON?

Clean up your dbatools

It’s easy to get the latest version of the dbatools PowerShell module:Update-Module -Name dbatoolsHowever, this does not remove the old versions. Those stay around until you manually do something about it. To see all the versions installed, this command is helpful:Get-Module -Name dbatools -ListAvailable | Select-Object Name, Version, Path Why clean them up?1) Remove clutter … Continue reading Clean up your dbatools

Reboot

Here’s the “initial commit” for the blog reboot. More to come soon.

Introducing ISDeploymentCmd

A few months back, after resuming SSIS development full-time on a new team, I began to look for ways to incrementally improve the processes causing pain around deployments. New or improved packages would be sent to the DBA in the form of an ISPAC and then he’d open SSMS and deploy to the target server … Continue reading Introducing ISDeploymentCmd

Little fish, big pond

The SQL Server Community feels large. There are so many resources online at my disposal that I may even say it is bit overwhelming. There so are many that greats that came before me which leads me to ask, what could I possibly contribute by having yet another blog? The answer is quite simple – … Continue reading Little fish, big pond


Follow My Blog

Get new content delivered directly to your inbox.