We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in).
In this newsletter:
- Add SSRS to the SQLServer PowerShell Provider?
- Tonight: PowerShell ? SQL Server: Modern Database Administration with dbatools
Last week I blogged about how you can turn on Dark Theme in SSMS 2016 but that it’s unfinished and you can use it at your own risk.
As good quality 4K monitors in the 30+ inch range continue to get cheaper & cheaper I find myself wanting to have… Read more
Back in July when we received the first official release of SSMS not tied to an engine release we got a new SQL PowerShell module and we also received the ability to run SSMS in Read Uncommitted mode via a registry setting.
I was hopeful that this new option would… Read more
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re database people, not email mavens, and the newsletter does go out to over 4,000 people so it’s worth taking time to try and get it right (even though we don’t… Read more
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date of the last known good DBCC CHECKDB to SYS.DATABASES. This one seems like a no-brainer to me. When you NEED this… Read more
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same situation can arise where the SQL Server PowerShell Provider is responding to your request with stale data. So how do you fix that? Pretty easily actually. Wherever you are… Read more
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s time.
I use SSAS on a regular basis but I’m probably not going to come up with the lion’s share of… Read more
Everyone is really excited about PASS Summit being right around the corner and as usually happens, the folks at the Portland Oregon user group are putting on a SQL Saturday the weekend before.
I love getting to explore the city of Portland and eat food that came out of a… Read more
Next up for the PowerShell Virtual Chapter of PASS Scott Sutherland ( b | t ) will be presenting: Hacking SQL Servers on Scale using PowerShell. This session will be live on Wednesday Oct 19, 12-Noon EDT (GMT -4). As always, we will get the recording posted to you PoSh… Read more
Just a quick blog today to show you something which is possible with a handful of lines of code. I am writing a more in-depth article for SQL Server Central on Write-SqlTableData, in the meantime hopefully this might inspire or help you with something you need to do.
The… Read more
That’s right, PowerShell & Power BI.
How does this work you ask?
Here’s Rob’s abstract to give you more info on the session. We… Read more
Next week Chrissy LeMaire ( b | t ), Laerte Junior ( b | t ), Rob Sewell ( b | t ) and I will be hosting a webinar covering the new PowerShell cmdlets that have just arrived in the end-of-June update of SSMS 2016.
You can register… Read more
TL;DR: Go Vote / File on Connect NOW!
For years I’ve avoided Connect, it’s true.
In an ironic twist fit for a recursive-CTE I think I quit using Connect over responses to items like this one “Improvements to Keyboard Shortcuts in SSMS” when it was “Closed as Won’t Fix”. Well… Read more
SQL Saturday is returning to Atlanta on May 18th at Georgia State University – Alpharetta, 3775 Brookside Pkwy, Alpharetta, GA 30022
The day before the event Atlanta MDF is presenting 5 Pre-Cons to choose from. Last year all three Pre-Cons sold out well before the event so get your tickets… Read more
The date has been set for the next North American PowerShell Summit. It will be held Monday April 22nd – Wednesday April 24th at the Microsoft campus in Redmond, Washington. I’m already secured my spot and if you want to be there you better act fast! As of… Read more
Atlanta MDF presents:
SQL Saturday #111 Pre-Conference Sessions
SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve managed to schedule 3 awesome pre-con sessions for the Friday before (April 13). They will cover a broad spectrum of topics: Performance Tuning, SSIS, and SSRS. Registration is… Read more
PowerShell takes the Pole at SQLRally!
PowerShell has taken the Pole for the DBA division at SQLRally! Come see why the organizers have chosen this session to lead the pack to the Green Flag.
PowerShell provisioning of Hyper-V Servers
Designing Cubes for Performance
Database Standards SOP
PowerShell provisioning of Hyper-V Servers
April 20, 2011, 12 PM EDT (GMT -4)
Marco provides an overview of using sysprep for Windows Server 2008R2, and SQL Server 2008R2, which also now supports this feature. This… Read more
In case you’re in need of some images to help us promote the largest PASS event on the East Coast this year, I’ve gathered some together for you For all you chapter leaders I’ve also included a flyer that you can print out and hand out at your user group… Read more
I was referred to someone on twitter today who wants to email query results without setting up database mail. I explained this in Post 6 of PowerShell Week at SQL University but that example was somewhat complicated. Instead, I thought I’d whip up a new example using Paul’s latest survey Read more