SQL Saturday #85 Orlando 2011 Presentation
Presentation and scripts from my Storing Powershell Output session at SQL Saturday #85 Orlando 2011:
2011-09-24
967 reads
Chad Miller
Managing AlwaysOn with Powershell
Although you can use SQL Server Management Studio or T-SQL to manage AlwaysOn, SQL Server Denali CTP 3 includes 25...
2011-09-05
18,995 reads
Recursively Enumerating Local and AD Groups
If you ever need to flatten out groups which may include nested local and AD groups there’s a really easy...
2011-08-14
4,237 reads
Using SMO Transfer Class to Script Database Objects
I’ve spent some time trying to get the SMO Transfer class to bend to my will. I want to script...
2011-07-25
4,861 reads
South Florida IT Camp Presentation
Presentation and scripts from my Storing Powershell Output session at the South Florida 2011 IT Camp:
2011-07-24
605 reads
Denali SQLPS First Impressions
I’ve taken a few hours to try out Denali CTP 3 sqlps and noticed some welcome changes. The biggest change...
2011-07-18
2,032 reads
Creating Icons Files
While working on a PowerPack for PowerGUI I needed to create a bunch of icon files from bitmaps files so...
2011-07-03
667 reads
MVP Award
Today on July 1st 2011, I was pleasantly surprised to be recoginzed as a Microsoft Most Valuable Professional for contributions to the PowerShell technical...
2011-07-01
581 reads
Counting Licenses for VMs
This is old news, but I’ve had to explain SQL Server VM licensing to enough people recently that I thought...
2011-06-28
3,117 reads
Tampa PowerShell Presentation
The presentation material from the Tampa PowerShell User Group 6/21/2011 meeting on PowerShell ETL is available here:
2011-06-22
1,291 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Upgraded VS2019 to version 16.11.49 but I cannot access my original SSIS package
Hi I upgraded to new version of VS2019 to 16.11.49. My original SSIS package...
How do I make this one row per id
I've written this code, but it is showing right now as 2 rows per...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers