CheckDB Error Msg 824 level 24
One of the common CheckDB errors that I see is the Message 824, level 24. This is something that I regularly work to repair for… Read More »CheckDB Error Msg 824 level 24
SQL Server
Prevent Server Manager From Loading
If you frequently connect to many different SQL Server as I do, you are probably used to the Server Manager loading slowly when you log… Read More »Prevent Server Manager From Loading
Building a SQL Restore Script When Your Backup Runs
It is handy to have a SQL Restore script ready to go for every backup that you run. Here is a script that will help… Read More »Building a SQL Restore Script When Your Backup Runs
Visualizing VLFs – Another update
This is an update to Visualizing VLFs – A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script.
The previously updated script added another column called “TextStatus” to the output to give you a better idea of what the different statuses mean. You now get 3 statuses shown, “In Use”, “Available”, and “Available Never Used”. The If you have lots of VLFs that are “Available Never Used” that may be an indication that your log file may be larger than you need. If you don’t have any that are “Available Never Used” the log may be smaller than you need.
This latest update changed the character shown in the bar chart to a X or an O depending on if the current file is in use.
Read More »Visualizing VLFs – Another updateUsing Antivirus with SQL Server
In a perfect world, your SQL Server would be so secure that you would not need antivirus software, you would have behind layers of firewalls,… Read More »Using Antivirus with SQL Server
TempDB – Do This and Don’t Do That
Today I had the opportunity to present on TempDB to the Spokane SQL Server users group (PASS Chapter). The session was titled TempDB – Do This… Read More »TempDB – Do This and Don’t Do That
Visualizing VLF’s – Updated
A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script.
Here is an updated script that has adds another column called “TextStatus” to the output to give you a better idea of what the different statuses mean. You now get 3 statuses shown, “In Use”, “Available”, and “Available Never Used”. The If you have lots of VLFs that are “Available Never Used” that may be an indication that your log file may be larger than you need. If you don’t have any that are “Available Never Used” the log may be smaller than you need.
SQL Server 2016 Developer Edition
With previous versions of SQL Server to get the developer edition, it was usually available for around $50 USD at Amazon.com. With the introduction of… Read More »SQL Server 2016 Developer Edition
Database Owner? What user owns your database?
Who owns that database? A quick check of the owner of most databases will likely reveal that the databases are either owned by sa, or… Read More »Database Owner? What user owns your database?
Is enabling xp_cmdshell a security risk?
After listening to an interview of Sean McCown (twitter) and some lively discussion on xp_cmdshell, I decided it would be a worthy enough discussion to create a blog post. At a minimum it might stir up some opinions.
There are many varying opinions out there, including some really good opinions that applied to SQL Server 2000, but don’t really apply any more.