AWS' managed relational database service, RDS, can be a good option for many deployments. One thing you'll find that different when working with RDS is that you won't find the normal Tasks > Back Up... option available for a given database. This is because the service doesn't allow direct disk access to the instance(s) running you … Continue reading Backing up an AWS RDS MSSQL Database to a S3 Bucket
Recently, I was reviewing a space issue on a server, only to find that the culprit was a 35GB LDF. It was the OpenManage Essentials database. I've been trying to qualify it as a method of detecting hardware issues on ESXi hosts and various Dell hardware (Powervault SAN, etc). I reviewed the recovery mode and … Continue reading Handling huge LDF files when SQL Recovery Mode is ‘Simple’
I've started working with PowerBI Desktop these days for data visualization. It didn't take long to hit some limits on portability when using an Excel sheet as a data source. So, I decided to import the Excel sheets into SQL, and then connect PowerBI Desktop to the SQL database. First, I created a new SQL … Continue reading Import Excel into SQL using SSMS
This is something that I encounter more commonly with older versions of vCenter where the MS SQL Express 2008 that came bundled with vCenter was used. I've stumbled on to this when you can't login to vCenter and the VirtualCenter Server service won't stay started. **I have found that in some cases it might make … Continue reading vCenter Server MS SQL Express database is full
I stumbled on this handy tip here. Sometimes passwords fail to get documented properly. If that's the case, you can reset the appropriate account password or create a new db_owner by running SQL Mgmt Studio as SYSTEM via PsExec. Once you have PsExec run with options -s and -i with the path to you Ssms … Continue reading Not able to log into SQL Mgmt Studio? Not a problem.