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?
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
Here’s the “initial commit” for the blog reboot. More to come soon.
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
I recently came across an error involving SQL Server Reporting Services (SSRS) that I recognized immediately but still took me some time to resolve due to intricacies of this particular environment. This involves a scenario with a Web App calling into SSRS which then connects to a separate SQL Cluster. The admin of the Web … Continue reading SSRS and Kerberos with a Cluster
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.