So just a quick one today. I was recently working on a SQL Server, running through some Database Mail setup and testing (see Microsoft Docs) with one of our applications. I needed a way to see what e-mails were being sent out as well as what wasn’t. The below queries will give you the info … Continue reading "Queries for troubleshooting the Database Mail (dbmail) function of Microsoft SQL Server"
Working with one of my education customers I recently had to perform some maintenance on their SQL Database server as they were running low on disk space AND had a free unused virtual disk where we could throw their tempdb onto (it was meant to go here but they didn’t place it there during installation). … Continue reading "Moving the SQL Server tempdb file location after SQL Server is installed"
I was recently setting up some Linked SQL Servers for a customer to perform queries against a database on one server through another. One of the things you need to get right when setting up linked servers when using Service accounts in Active Directory is SPNs (or Service Principal Names) and Authority to Delegate (for … Continue reading "How to easily Check your SPN and Delegation settings for SQL Server in an Active Directory environment"
I was recently helping out a colleague with an SQL Server Reporting Services (SSRS) installation. When it came time to configuring that instance of SSRS and making it listen on port 80 for that particular site we got The URL has already been reserved warning message, navigating to the Reporting Services URLs gives us a HTTP … Continue reading "Fixing SQL Reporting Services The URL has already been reserved error during Configuration"
So I was asked recently to setup a test environment for one of our CRM applications. So I went ahead and instead of copying the existing Virtual Machine I decided to create a new one from scratch. Installed SQL Server 2012 and the required application files. As I went to install the database onto the … Continue reading "Changing the SQL Server Collation After Installation for SQL Server 2012 or 2014 without re-installation"
So I’ve been toying with SharePoint 2013 in my lab at home, doing the install and configuration at the moment, setting up my first Site after the initial configuration but noticed that I made a typo in the Database name. So how do I go about fixing or renaming that database in SharePoint and in SQL … Continue reading "How to Rename a SharePoint 2013 Content database name hosted on SQL Server"
So I found out recently that one of our servers was running out of space. It’s our AV server so I was like what the hell, why is it running out. Turns out it had an instance of SQL Server on there as a quarantine and configuration database. The Virtual Machine was being backed up … Continue reading "Changing the recovery mode doesn’t shrink an SQL Database log file, how to shrink logs manually."
We are currently in the process of trailing Forefront Endpoint Security along with our SCCM Deployment. So after a few weeks of tweaking we have got our systems center deployment to a level where we are happy with it, it was time to begin installing and testing Forefront. After beginning our installing and answering a … Continue reading "Setting up an SPN and fixing the cannot verify the service principal name error when installing ForeFront Endpoint Protection"
During my morning rounds of looking after clients’ servers, running SBS 2008. I noticed one was running out of space. It had recently been updated to WSUS 3.0 SP2, after doing a quick hard drive space check I found that SUSDB was over five gigabytes in size. Generally this database should be around one gig. … Continue reading "Moving your SUSDB when it is running under MSDE"