Fort SQL - All Comments

re: List of SQL Server Service Names

Gary — Thu, 18 Apr 2013 22:48:56 GMT

When checking SNMP for the SQL Agent running (The Dude) I had to observe case sensitivity; SQL Agent runs as SQLAGENT.EXE, not sqlagent.exe

re: List of SQL Server Service Names

Donald Jackson — Sat, 26 Jan 2013 21:15:17 GMT

As a security analyst this list will be very helpful for writing database compliance checks for Nessus scanning.

re: Remove Public and Guest Permissions

Declan — Fri, 23 Nov 2012 17:32:56 GMT

Thank you. Such a neat scrip. And such tidy format. Man love.

re: Alert On Low Disk Space, Including Mount Points

lauraldo2 — Wed, 14 Nov 2012 19:28:39 GMT

Thank you so much for this tip and the script. I find it a little more user-friendly to display the data in a table format. See below for script that does that. It takes the server name as a parameter, so it is to be used from the command line, but it can be easily modified to be run from a SQL Server Agent job.

Thanks again,

Aldo Gonzalez

Param($ServerName)

$freespaceprct = @{ expression={ [float] $_.freespace / $_.capacity * 100} ; label='Freespace %';format="{0:N1}";width=12;alignment='right'}

$sizeMB = @{ expression={ [float] $_.capacity / 1024 /1024}; label='Size (MB)';format="{0:N1}";width=10;alignment='right'}

$FreespaceMB = @{ expression={ [float] $_.freespace / 1024 /1024}; label='Freespace (MB)';format="{0:N1}";width=15;alignment='right'}

$deviceid = @{ expression={ $_.Name }; label='Drive/MountPoint' }

$Volumes = Get-WmiObject -namespace "root/cimv2" -computername $ServerName -query "SELECT Name, Capacity, FreeSpace FROM Win32_Volume WHERE DriveType

= 2 OR DriveType = 3"

$Volumes | sort-object -property freespace | ft $deviceid, $sizeMB, $FreespaceMB, $freespaceprct -autosize

re: Managed Service Accounts

Prashant Jha — Sun, 16 Sep 2012 12:01:26 GMT

Nice one..I hadn't heard about it either. ;-)

re: The Easiest Way To Rebuild The master Database

Bhargav Lalisetti — Wed, 08 Aug 2012 11:42:07 GMT

Very Nice...Its' good to Understand and easiest way..

re: SQL Server Ports

Quantum John — Thu, 02 Aug 2012 17:59:39 GMT

Hi Freek,

I wanted to be comprehensive, and if you're using FTP as part of SQL Server replication, you're definitely dependent on port 21. Likewise, I know DBAs who can normally manage an instance of SQL Server by remoting into the server, which means they're dependent on port 3389. They are "SQL Server" ports, but they could be involved in SQL Server issues.

re: Remove Public and Guest Permissions

John — Tue, 31 Jul 2012 14:41:06 GMT

Great article specifically refresing DoD STIGS. Script works great on SQL 2012 as I am in the process of applying STIGS to SQL 2012 now.

re: Making STIG Compliance Much Easier

weakness — Thu, 26 Jul 2012 12:57:04 GMT

how are you going to post a suggestion and not share the templates...........

re: SQL Server Ports

Freek Berson — Wed, 04 Jul 2012 18:25:06 GMT

Hi!

Some ports you mention, like e.g. 21 and 3389, I would not categorize as ports that SQL Server would use or be dependent upon.

Kind regards,

Freek Berson

themicrosoftplatform.net