Scripting SSIS Package Deployments
Before I delve into the subject of scripting SSIS package deployments, I’m going to take a slight detour and explain...
2012-11-06
6,712 reads
Chad Miller
Cloning SQL Servers to a Test Environment
I’ve been involved in a project to set up a full test environment of dozens of SQL Servers. The requirements...
2012-11-08 (first published: 2012-11-05)
4,239 reads
Using Invoke-WebRequest
The website PowershellCommunity.org is moving to a new site poweshell.org and I wasn’t sure the old forum posts will be...
2012-10-26
3,143 reads
Upcoming Fall Events
During September/October I’ll be presenting at several in-person events:
Tampa IT Pro Camp
Join system administrators and IT professionals for the Tampa...
2012-09-09
1,109 reads
South Florida IT Pro Camp 2012 Presentation
Presentation and scripts from my Storing PowerShell Output session at South Florida IT Pro Camp 2012.
2012-07-22
1,105 reads
Jacksonville IT Pro Camp 2012 Presentation
Presentation and scripts from my Integrating SQL Server PBM with SCOM session at Jacksonville IT Pro Camp 2012.
2012-06-19
1,167 reads
Jacksonville IT Pro Camp
Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...
2012-06-03
1,227 reads
Appending New Rows Only
I saw a question in the forums related to inserting new rows into a SQL Server table only if they...
2012-04-27
5,467 reads
Backup Database Object
I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is...
2012-04-17
1,803 reads
Table-Valued Parameter Example
I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case...
2012-04-13
3,525 reads
Blogs
Who are you? Building an identity map.
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Call a Fabric REST API from Azure Data Factory
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
Distributed Availability Group Dashboard
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...
Forums
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric
Comments posted to this topic are about the item Create Raw Zone Tables using...
Database DevOps Metrics
Comments posted to this topic are about the item Database DevOps Metrics
Replacing a NULL II
Comments posted to this topic are about the item Replacing a NULL II
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers