Search Results for: Powershell

Powershell for SQL Server DBA’s

Is the list of servers you manage growing and growing? Are you starting to wonder if there is a more efficient way to manage your SQL Server instances than T-SQL and SSMS? In this session we will give you an … Continue reading

Speaking at Pittsburgh Powershell User Group

Tomorrow, May 15th at 6pm I will be joining the script club and give a presentation on how DBA’s can leverage powershell to do their job quicker and automate processes.  It’s not too late to sign up. If you will … Continue reading

PowerShell User Group starts in Pittsburgh!

Recently, it has come to my attention that there is a PowerShell User Group being born in Pittsburgh.  The first user group meeting is December, 13th and  Ed Wilson also known as TheScriptingGuy will be their first presenter.   There are … Continue reading

Passed my #SQLUniversity PowerShell Midterm!

I am always up for learning something new so I jumped in on the free PowerShell training at SQL University. I saw that Aaron Nelson gave me the tools to loop through a Central Management Server and I was inspired. … Continue reading

Import Databases to Azure SQL Database

I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do this with DBATools.io. You can use the same code to just … Continue reading

Calculating DTU in Azure SQL Database

A few months ago, I posted a question over on ask.sqlservercentral.com.  In a nutshell, it was how do you measure DTU? How could you pull the data shown in the Azure Portal graphs with T-SQL?  No one answered, so this … Continue reading

Community

Here is a list of several different ways I pay it forward within the SQL Server Community from Austin, Texas. Contact me if you would like me to speak at your event I was a Microsoft Data Platform MVP. (2016 … Continue reading

8 Hours of SQL Server Performance Training This Week!

Check out the annual Performance Palooza hosted by the Performance Virtual Chapter on July 23rd, 2015.  This is a virtual online event open to the public and it’s absolutely free.  We’ll have 8 back to back sessions with start times … Continue reading

T-SQL Tuesday #50: Automation for LazyDBAs!

T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month. … Continue reading