You are here

SQL Server

Wordpress' Secret Admin Panel

wordpress blog pic

As I was attempting to update my email address in a Wordpress blog, it was stuck. A notification said:

There is a pending change of the admin email to xoxoxo@xoxoxo.com

But that was it. It would never go through.

Script Storage Update

This is an update to a previous post. In another post on this site, it was said that Dropbox Paper is the code storage of choice. This has changed.

Moving FDLAUNCHERLOG in SQL Server

EDIT: I had two scenarios like this. The one written about here worked. The other one failed. The actual solution came from sql-ution.com. The solution is to fix the registry with the new value. And just in case his website comes offline before mine does, I'll post the code:

sp_who2 Alternative (T-SQL, SQL Server)

The trusty "sp_who2" is a quick way to look at what's happening on your SQL instance, but completely lacks the ability to filter using a WHERE clause. You may have to manually sift through hundreds of results to find what you need.

Never fear.

Removing SSMS Boost

SSMS Boost is an add-on for SQL Server Management Studio.  I used it for quite some time but I got tired of using it as freeware.  The reason SSMSBoost as freeware didn't work for me was because they require that you continually re-download the new version and re-register every 120 days, otherwise it renders your existing version useless.  That process gets tedious, at least I think it does.  I want my tools to serve me, not the other way around.

TempDB Reporting Incorrect File Size

So what happens when you run a query to check TempDB file sizes and SQL tells you that each file is 101 MB, but when you look in the file system, they're actually a 45 GB each?  

SQL Server - Disabled User Account Overrides AD Group Authorization!

Just a quick note on a scenario I ran into, and what I did to fix it:

SQL Server Maintenance Plan Backups Failing On Secondary Replica in High Availability Environment

When a High Availability (HA) environment failed over, on the node that became Secondary, the backup jobs did not gracefully handle the change. The Maintenance Plans are supposed to intelligently determine whether each database is Primary or Secondary in an HA environment, and skip the backup if it is not Primary.  This check actually fails (practically speaking) if you have "Verify backup integrity" checked.

TSQL - Make Excel Link In Output

Here is a situation I just came across (boiled down and simplified).  An end user was having to manually find a user id, navigate to an image folder, and then search through hundreds of images to find the one corresponding with that user.  Sure, they were in numerical order, but still, what a pain!  He wanted to generate an excel file with links to files to quickly access the corresponding image. 

TSQL - Get All Queries Currently Running

This is perhaps my most commonly used query when troubleshooting.

Pages

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
12 + 5 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer