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: Installation
SQL Server Installation Failed Due to Pending Restart of Server?
Incidentally, the sort of problem I’m discussing here is why I (almost) always copy the patch/servicepack/media to somewhere local – each time you run a servicepack or cumulative update, the whole package decompresses to your hard drive, runs, and then … Continue reading
Posted in SQLServerPedia Syndication
Tagged Cumulative Updates, Installation, Patching, Service Packs
1 Comment
Skype for Business – SQL Server Frustrations
Scenario The environment is new and secure. Assumptions: You are a DBA who knows how to build WSFCs and AGs. If you need help with that, then you’re in the wrong place for this post. The Windows 2016 / SQL … Continue reading
Windows 2012 R2 KB2883200 / KB2919355
In case you ever get round to trying to install vNext (or SQL2016SP1) on a Windows 2012R2 server, you may encounter some problems with missing updates. At least, I did, while following these steps: Create new Windows 2012 R2 VM … Continue reading
SQL Server TempDB, Azure Virtual Machines, and the D: Drive
Why put the TempDB on the D: drive? In the wonderful world of Azure Virtual Machines, for certain VM types, the D: drive is hosted on SSDs – great for performance. However, in this world, the D: drive is “non-persistent … Continue reading
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
SQL Server 2012 Silent Install problems
Just been working on a silent install script for SQL 2012, and had a few odd errors. Unfortunately, I don’t have direct access to the server, just to my notes from the install. Error: “‘<null or empty string>’ is not … Continue reading
Posted in SQLServerPedia Syndication
Tagged Installation, SQL Server 2012, Troubleshooting
Leave a comment
sqlenginedbstartconfigaction_install_configrc_cpu64 returned false
Some fun & games today. I was building a nice new SQL Server 2008 R2 VM (yes, I know it’s 2013, but this counts as a big upgrade where I am at the moment). 90% or so of the way … 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
Unable to launch Activity Monitor.
It all started so innocently. A SQL Server 2005 installation. An installation of SQL Workbench, sorry, “Microsoft SQL Server Management Studio.” And a need to find out what’s going on. Click, click, click – Activity Monitor. Double-click. Uh-oh. (Incidentally, why … Continue reading
Posted in SQLServerPedia Syndication
Tagged Cluster, Installation, SQL Server 2005, Upgrade, WTF
2 Comments