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
19,054 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,245 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,911 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
609 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,036 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
673 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
582 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,129 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,294 reads
Blogs
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
PASS Data Summit 2025 Recap
By Tim Mitchell
Last week, I attended the annual PASS Data Summit in Seattle. This was the...
Forums
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers