Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLvariant

Aaron Nelson ( blog | twitter ) is a Microsoft MVP for SQL Server (Data Platform) and leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta. The PowerShell VC of PASS hosts monthly sessions on SQL Server and PowerShell, and you can find the recordings of those sessions on their YouTube channel.

PowerShell Virtual Group of PASS January Newsletter

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...

Read more

0 comments, 108 reads

Posted in SQLvariant on 18 January 2017

T-SQL Tuesday #86 – Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view

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...

Read more

2 comments, 99 reads

Posted in SQLvariant on 10 January 2017

Refreshing the SQL Server PowerShell Provider

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...

Read more

0 comments, 108 reads

Posted in SQLvariant on 6 January 2017

Up Next, SQL PowerShell for SSAS!

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...

Read more

1 comments, 12 reads

Posted in SQLvariant on 12 December 2016

October 2016 SQL Mastery Sessions

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...

Read more

0 comments, 15 reads

Posted in SQLvariant on 18 October 2016

Webinar: Hacking SQL Servers on Scale using PowerShell

This presentation will provide an overview of common SQL Server discovery, privilege escalation, and data targeting techniques. It will also cover how SQL Servers can be leveraged to escalate privileges in Active Directory domains. Finally, we'll show how PowerShell automation can be used to execute the SQL Server attacks on…

Read more

0 comments, 12 reads

Posted in SQLvariant on 17 October 2016

Searching SQL Servers & Saving Results, with Write-SqlTableData

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...

Read more

0 comments, 14 reads

Posted in SQLvariant on 14 October 2016

Next for the PoSh VC: PowerShell, SQL and Power BI

That’s right, PowerShell & Power BI. How does this work you ask? Well back in July, Rob Sewell ( b | t ) gave us a preview of this, you can catch a few...

Read more

0 comments, 15 reads

Posted in SQLvariant on 12 August 2016

Webinar on 25 New PowerShell cmdlets for SQL Server and 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...

Read more

3 comments, 18 reads

Posted in SQLvariant on 30 June 2016

Connect is Working! Get in While the Getting is Good!!!

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...

Read more

0 comments, 14 reads

Posted in SQLvariant on 7 May 2016

Atlanta MDF Presents Five Pre-Cons to choose from in Atlanta Friday, May 17

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...

Read more

0 comments, 10 reads

Posted in SQLvariant on 13 March 2013

2013 North American PowerShell Summit

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...

Read more

0 comments, 786 reads

Posted in SQLvariant on 25 September 2012

Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012

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...

Read more

0 comments, 1,074 reads

Posted in SQLvariant on 1 February 2012

PowerShell takes the Pole at SQLRally!

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.

We will be covering new ground, not rehashing last year’s PASS Summit presentation.  I have… Read more

0 comments, 478 reads

Posted in SQLvariant on 10 May 2011

Late April Free Training from PASS VCs

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 Shaw

Marco provides an overview of using sysprep for Windows Server 2008R2, and SQL Server 2008R2, which also now supports this feature. This… Read more

1 comments, 538 reads

Posted in SQLvariant on 15 April 2011

Help Promote SQLRally!

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

2 comments, 957 reads

Posted in SQLvariant on 25 February 2011

Emailing tempdb Query Results to Paul Randal with PowerShell

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

0 comments, 1,584 reads

Posted in SQLvariant on 23 February 2011

PowerShell Interfaces with Other Hammers

This month’s installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: “So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or with PowerShell or a mix of both. Give us your best tips/tricks and… Read more

0 comments, 589 reads

Posted in SQLvariant on 9 February 2011

PowerShell Week at SQL University – Post 6

Yesterday we went over some loop constructs to get information out of SQL Server.  While getting the information out is great, as Data Professionals our very next concern is going to be: “ok, where do I put this so that I can refer to it later?”

Today we’re going to… Read more

0 comments, 1,231 reads

Posted in SQLvariant on 21 January 2011

PowerShell Week at SQL University – Post 5

In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually means something to a SQL person whenever we ca.  There are quite a few more language constructs that we need to cover but we have enough info to start recouping… Read more

0 comments, 937 reads

Posted in SQLvariant on 20 January 2011

Older posts