If you found this post… You probably want to make more sense out of the last_run_date, and last_run_time columns from the msdb..sysjobsteps table. Here is a quick conversion for you. I did […]
You’ll find many examples online on how to configure SQL Database Mail. These work great to demonstrate the process, but some might get confused on what to actually use for the ‘recipients’. […]
Here’s some quick SQL logic to help you find the other Mirrord Server in the SQL Server Database Mirroring configuration.
It’s generally a good idea whenever you have automated backup processes through Agent Jobs to make sure you have the proper settings in sys.configurations before running the ever so helpful backup process […]
Sometimes you’ll need to clear some space from the OS drive on the Server. One of which is constant, but doesn’t have to be that way; is the paging file. Yeah; sure… […]
Here’s some quick logic which takes the results from xp_fixed drives, and puts it in a table. Then a quick query against that tables shows the amount of free space in GB. […]
The 2012 Management Studio Download can be found in Microsoft’s Download Center. You won’t see the download option unless you click on the ‘Download’ button, then you’ll be presented with a bunch […]
So; you’re a DBA trying to configure something in the database system, and so it’s pretty ordinary stuff that you’ll need to browse Active Directory to find Shares, Accounts, Groups, OU’s, Members […]