To Script or Not To Script
When approaching an automation problem the first questions you must answer is whether you should even invest the time to...
2011-03-15
687 reads
Chad Miller
Restore and Relocate Database Files Using PowerShell
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
2011-03-14
7,903 reads
SQLPSX 2.3.2.1 Release
We’ve released a minor update to SQLPSX which includes includes several bug fixes/enhancements as well as one new module. Here’s...
2011-03-13
1,028 reads
T-SQL Tuesday #15 Automation and the SSIS Dumper
This post is my contribution to T-SQL Tuesday, hosted this month by Pat Wright (blog | twitter).
In my previous post...
2011-02-08
1,058 reads
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-07
3,226 reads
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-03
11,068 reads
Tampa IT Camp Saturday
The first annual Tampa IT Camp will be held on Saturday, March 19th 2011.
What’s an IT Camp?
In the...
2011-01-22
571 reads
SQL Saturday #62
I presented a one hour session at SQL Saturday #62 in Tampa on SQL Server PowerShell Extensions (SQLPSX): “In this...
2011-01-15
418 reads
Making an Operations Manager Module
Operations Manager 2007 R2 ships with Operations Manager Shell which is simply a provider with associated cmdlets for working with...
2011-01-04
853 reads
Windows Cluster Scripting with WMI and PowerShell
Windows 2008 R2 includes a failoverclusters PowerShell module, but you’ll probably find normal usage limiting for several reasons:
Only works on...
2010-12-31
3,641 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers