Thomas Rushton
is… The Lone DBA.
- "... a scholar and a true gentleman." - Buck Woody, Microsoft's "Real World" SQL Server DBA.
-
Recent Posts
- Agresso
- AskSSC
- availability groups
- Azure
- Backup
- Book Review
- Books
- Career
- Configuration
- CTE
- DBCC
- Deadlock
- Denali
- Deployment
- Design
- Disaster Recovery
- DMV
- Documentation
- Education
- Error Logs
- Error Message
- ETL
- Full Text Indexes
- Geometry
- Indexing
- Installation
- IT Management
- Kaseya
- Kindle
- Maintenance
- Maintenance Plans
- Management
- Meme Monday
- Memory
- Migration
- Monitoring
- MSDB
- Normalization
- Performance
- PowerShell
- Programming
- Project Management
- red-gate
- Redgate
- Restore
- Scheduled Tasks
- Security
- Spatial
- SQL Agent
- SQLBits
- SQL Monitor
- SQLPrompt
- SQLSaturday
- SQL Server
- SQL Server 2000
- SQL Server 2005
- SQL Server 2008 R2
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQLSouthWest
- SSMS
- SSRS
- T-SQL
- T-SQL Tuesday
- Training
- Triggers
- Troubleshooting
- Upgrade
- User Group
- Virtual Machines
- Windows
- Windows 2012
- WordPress
- WTF
Archives
Categories
SQL Server blogs
- Brent Ozar – Too Much Information
- Denny Cherry & Co (DCAC)
- Microsoft SQL Server blog
- Microsoft SQL Server Team blog
- Midnight DBA – DBARant
- Midnight DBA – SQLAwesomeSauce
- Redgate Hub – SimpleTalk
- Simple-Talk – DBA, Dev, Admin
- SQL Server Central Articles
- SQLBlog – Aaron Bertrand
- SQLRockstar – Thomas LaRock
- SQLSkills
- The Scary DBA
- Voice of the DBA
Tag Archives: PowerShell
CmdExec vs Powershell – error? What error?
Just a quickie Batch file scripts, called by SQL Agent, are not propagating their errors back up to the SQL Server job system because…. they’re being called from a Powershell script? To replicate the problem, create a .bat file containing … Continue reading
Departure of a SQL Server Administrator – What to Check?
A SQL Server administrator has left. But what does that actually mean? What do we need to check to make sure that things will continue to work after their Active Directory account is disabled? Some things to check are: SQL … Continue reading
Posted in Uncategorized
Tagged Administration, PowerShell, Security, SQL Server, T-SQL, Windows
1 Comment
PowerShell – Slicing
I was skimming through the first part of the Simple-Talk series on PowerShell Desired State Configuration, and I got to the bit that says “To install them, all you need to do is copy and paste them into your PowerShell … Continue reading
PowerShell – Prompts, Paths, Profiles
PowerShell – PowerShell_ISE, Profiles and Prompts By default, your PowerShell prompt is “PS <<path>> >”. So normal; so dull. However, that can be easily changed. In my case, I want to add: the current time (well, the time at which … Continue reading
Notes on Instant File Initialization and Running Scripts on Multiple Servers
Instant File Initialization (IFI) IFI can be a useful performance booster if you’re in an environment where your database files grow regularly, although there’s an argument that if that happens regularly, you should grow them massively up front in a … Continue reading
Azure CustomScriptExtension – Are there limits?
Yes, another in a series of disjointed short notes about Azure. I’ve been buildings PowerShell scripts to automate the build of SQL Server AzureVMs. Part of that effort has been using the Azure Custom Script Extension to help get stuff … Continue reading
Problems with Azure VMs of different sizes
Just a quick note… If you’re building an Azure Cloud Service with multiple Virtual Machines of varying sizes, does it matter which order you create Azure VMs? I created a new Azure Cloud Service by building a machine of size … Continue reading
Posted in SQLServerPedia Syndication
Tagged Automation, Azure, Deployment, PowerShell, Virtual Machines
Leave a comment
New-AzureVM : BadRequest: The virtual network <foo> does not exist.
Just a quickie. It’s been a long week, and I’ve been trying to get my head around using PowerShell to automate deployments in Azure. However, I did come across a little glitch in the way that this is supposed to … Continue reading
Windows Server 2012 Core – Server Configuration, Add/Remove Features, SysPrep
Recently, I started building a Windows 2008 R2 / SQL 2008 R2 environment as per Jonathan Kehayias’s (blog|@SQLPoolBoy) series of articles on “Building A Free Test Environment“, I found myself wondering about doing similar in Windows 2012, specifically in Windows … Continue reading
SQL Saturday 194 Exeter Pre-Con – PowerShell 3.0 for SQL Server Administrators and Developers
OK, Yes, it’s (yet) another post pimping a SQL Saturday 194 Exeter Pre-Con session. This time, André Kamman (blog|twitter)and his day of PowerShell. I’ve seen André perform at a SQLBits conference, where he gave a session “RoboDBA” about PowerShell, and … Continue reading
Posted in SQLServerPedia Syndication
Tagged PowerShell, Programming, SQLBits, SQLSaturday
Leave a comment
The Lone DBA 