Horkay Blog
The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
Saturday, 26 December 2015

Have you ever started a process and then realized, it's taking a long time, you don't want to sit there and watch it, and wish you had put a line in at the end of the batch to send you an email when it was done...

Or had a long running job that you had to wait on, that didn't send an email as it's last step.

Happens to me from time to time, this script will monitor a SPID and send you an email when it's done and every 10 minutes to let you know it's still running.


-- email someone when a spid is completed (idle) or no longer exists
declare @spid int = 60
declare @email_to varchar(50) = 'rhorkay@hrblock.com'
declare @completed_subj varchar(50) = 'SPID ' + convert(varchar(10),@spid) + ' is completed.'

declare @check_in_time_in_minutes int = 10 
declare @check_in_subj varchar(50) = 'SPID is still running'

Declare @message varchar(100) = 'Your Message from server: ' + @@Servername

declare @status varchar(100) = Null
Declare @loop_continue int = 1

while @loop_continue >= 1
Begin

 select top 1 @status = [status] from sysprocesses
  where spid = @spid

 if @status in ('suspended', 'runnable')
 begin
  waitfor delay '00:01'
  if @loop_continue = 10
  begin

   exec msdb..sp_send_dbmail
    @profile_name = 'SQL Mail',
    @recipients = @email_to,
    @Subject = @check_in_subj,
    @body = @message

   set @loop_continue = 1
  end
  else
  begin
   set @loop_continue += 1
  end

 end
 else
 begin  
  exec msdb..sp_send_dbmail
   @profile_name = 'SQL Mail',
   @recipients = @email_to,
   @Subject = @completed_subj,
   @body = @message

  set @loop_continue = 0
  break
 end
END

Saturday, 26 December 2015 11:39:18 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server | Web_Blog#

DISM /online /enable-feature /featurename:TelnetClient

It's always frustrating when new server images don't have the TelnetClient installed.

 I usually use Package Manager to install, http://www.lifeasbob.com/2015/08/01/InstallingTelnetClientOnWindows.aspx , but lately that has not always worked. 

I found a new way here: 

http://blogs.technet.com/b/joscon/archive/2010/08/26/adding-features-with-dism.aspx 

DISM /online /enable-feature /featurename:<name of feature>

Note: The featurename syntax is case sensitive so make sure you're typing it out as it appears in the list below.

http://blogs.technet.com/b/joscon/archive/2010/08/26/adding-features-with-dism.aspx

The following is the feature list for Windows 2008 R2 SP1:

Features listing for package : Microsoft-Windows-Foundation-Package~31bf3856ad364e35~amd64~~6.1.7601.17514


----------------------------------------------------------- | --------
Feature Name                                                | State  
----------------------------------------------------------- | --------
DirectoryServices-DomainController-Tools                    | Disabled
IIS-WebServerRole                                           | Enabled
IIS-WebServer                                               | Enabled
IIS-CommonHttpFeatures                                      | Enabled
IIS-HttpErrors                                              | Disabled
IIS-HttpRedirect                                            | Disabled
IIS-ApplicationDevelopment                                  | Enabled
IIS-Security                                                | Enabled
IIS-URLAuthorization                                        | Disabled
IIS-RequestFiltering                                        | Enabled
IIS-NetFxExtensibility                                      | Enabled
IIS-HealthAndDiagnostics                                    | Enabled
IIS-HttpLogging                                             | Disabled
IIS-LoggingLibraries                                        | Disabled
IIS-RequestMonitor                                          | Disabled
IIS-HttpTracing                                             | Disabled
IIS-IPSecurity                                              | Disabled
IIS-Performance                                             | Enabled
IIS-HttpCompressionDynamic                                  | Disabled
IIS-WebServerManagementTools                                | Enabled
IIS-ManagementScriptingTools                                | Disabled
IIS-IIS6ManagementCompatibility                             | Disabled
IIS-Metabase                                                | Disabled
WAS-WindowsActivationService                                | Enabled
WAS-ProcessModel                                            | Enabled
WAS-NetFxEnvironment                                        | Enabled
WAS-ConfigurationAPI                                        | Enabled
IIS-HostableWebCore                                         | Disabled
IIS-ISAPIExtensions                                         | Disabled
IIS-ISAPIFilter                                             | Disabled
IIS-StaticContent                                           | Disabled
IIS-DefaultDocument                                         | Disabled
IIS-DirectoryBrowsing                                       | Disabled
IIS-WebDAV                                                  | Disabled
IIS-ASPNET                                                  | Disabled
IIS-ASP                                                     | Disabled
IIS-CGI                                                     | Disabled
IIS-ServerSideIncludes                                      | Disabled
IIS-CustomLogging                                           | Disabled
IIS-BasicAuthentication                                     | Disabled
IIS-HttpCompressionStatic                                   | Disabled
IIS-ManagementConsole                                       | Disabled
IIS-ManagementService                                       | Disabled
IIS-WMICompatibility                                        | Disabled
IIS-LegacyScripts                                           | Disabled
IIS-LegacySnapIn                                            | Disabled
IIS-FTPServer                                               | Disabled
IIS-FTPSvc                                                  | Disabled
IIS-FTPExtensibility                                        | Disabled
Smtpsvc-Admin-Update-Name                                   | Disabled
Smtpsvc-Service-Update-Name                                 | Disabled
NetFx3                                                      | Enabled
WCF-HTTP-Activation                                         | Enabled
WCF-NonHTTP-Activation                                      | Enabled
DirectoryServices-DomainController                          | Disabled
DirectoryServices-ADAM                                      | Disabled
OEMHelpCustomization                                        | Disabled
CorporationHelpCustomization                                | Disabled
Printing-LPRPortMonitor                                     | Disabled
Printing-InternetPrinting-Client                            | Disabled
Printing-AdminTools-Collection                              | Disabled
BitLocker                                                   | Disabled
BitLocker-RemoteAdminTool                                   | Disabled
BdeAducExtTool                                              | Disabled
SimpleTCP                                                   | Disabled
SNMP                                                        | Disabled
WMISnmpProvider                                             | Disabled
Microsoft-Windows-Web-Services-for-Management-IIS-Extension | Disabled
LightweightServer                                           | Disabled
MicrosoftWindowsPowerShellISE                               | Disabled
RemoteAssistance                                            | Disabled
WSRM                                                        | Disabled
TelnetServer                                                | Disabled
TelnetClient                                                | Disabled
BiometricFramework                                          | Disabled
IIS-WindowsAuthentication                                   | Disabled
IIS-DigestAuthentication                                    | Disabled
IIS-ClientCertificateMappingAuthentication                  | Disabled
IIS-IISCertificateMappingAuthentication                     | Disabled
IIS-ODBCLogging                                             | Disabled
Printing-Server-Role                                        | Disabled
Printing-LPDPrintService                                    | Disabled
BusScan-ScanServer                                          | Disabled
Printing-InternetPrinting-Server                            | Disabled
FaxServiceConfigRole                                        | Disabled
FaxServiceRole                                              | Disabled
DFSR-Infrastructure-ServerEdition                           | Disabled
DHCPServer                                                  | Disabled
DHCPServer-Tools                                            | Disabled
DHCPServer-RSATClient-Tools                                 | Disabled
NetworkLoadBalancingFullServer                              | Disabled
FailoverCluster-FullServer                                  | Disabled
NetworkLoadBalancingManagementClient                        | Disabled
FailoverCluster-AdminPak                                    | Disabled
InkSupport                                                  | Enabled
DesktopExperience                                           | Enabled
MediaPlayback                                               | Enabled
WindowsMediaPlayer                                          | Enabled
HandwritingRecognition                                      | Disabled
AppServer                                                   | Disabled
AppServer-UI                                                | Disabled
Licensing                                                   | Disabled
Licensing-UI                                                | Disabled
SessionDirectory                                            | Disabled
SBMgr-UI                                                    | Disabled
WebAccess                                                   | Disabled
SUA                                                         | Disabled
Microsoft-Windows-Deployment-Services                       | Disabled
Microsoft-Windows-Deployment-Services-Transport-Server      | Disabled
Microsoft-Windows-Deployment-Services-Deployment-Server     | Disabled
Microsoft-Windows-Deployment-Services-Legacy-SIS            | Disabled
Microsoft-Windows-Deployment-Services-Admin-Pack            | Disabled
ActiveDirectory-PowerShell                                  | Disabled
DirectoryServices-AdministrativeCenter                      | Disabled
DNS-Server-Full-Role                                        | Disabled
DirectoryServices-ADAM-Tools                                | Disabled
DNS-Server-Tools                                            | Disabled
WINSRuntime                                                 | Disabled
Microsoft-Windows-Internet-Naming-Service-AdminTools        | Disabled
IAS NT Service                                              | Disabled
HCSRuntime                                                  | Disabled
HCSUI                                                       | Disabled
RPC-HTTP_Proxy                                              | Disabled
Gateway                                                     | Disabled
Gateway-UI                                                  | Disabled
NPSManagementTools                                          | Disabled
HCAP-Server                                                 | Disabled
RasServer                                                   | Disabled
RasServerAdminTools                                         | Disabled
RasServerAll                                                | Disabled
RasRoutingProtocols                                         | Disabled
RasCMAK                                                     | Disabled
AdminUI                                                     | Disabled
NIS                                                         | Disabled
RSAT-NIS                                                    | Disabled
PSync                                                       | Disabled
WirelessNetworking                                          | Disabled
WindowsRecoveryDisc                                         | Disabled
WindowsServerBackup                                         | Disabled
WindowsServerBackupCommandlet                               | Disabled
ServicesForNFS-ServerAndClient                              | Disabled
ServerForNFS-Infrastructure                                 | Disabled
ClientForNFS-Infrastructure                                 | Disabled
NFS-Administration                                          | Disabled
DFS-Replication-All                                         | Disabled
DfsMgmt                                                     | Disabled
FSRM-Infrastructure                                         | Disabled
FSRM-Management                                             | Disabled
CoreFileServer                                              | Disabled
BITSExtensions-Upload                                       | Disabled
BITSExtensions-AdminPack                                    | Disabled
MSRDC-Infrastructure                                        | Disabled
FRS-Infrastructure                                          | Disabled
StorageManagerForSANs                                       | Disabled
Indexing-Service-Package                                    | Disabled
iSNS_Service                                                | Disabled
Microsoft-Windows-GroupPolicy-ServerAdminTools-Update       | Disabled
TFTP                                                        | Disabled
MultipathIo                                                 | Disabled
DirectoryServices-ISM-Smtp                                  | Disabled
SearchEngine-Server-Package                                 | Enabled
CertificateServicesManagementTools                          | Disabled
CertificateServices                                         | Disabled
OnlineRevocationServicesManagementTools                     | Disabled
OnlineRevocationServices                                    | Disabled
WebEnrollmentServices                                       | Disabled
NetworkDeviceEnrollmentServices                             | Disabled
CertificateEnrollmentPolicyServer                           | Disabled
CertificateEnrollmentServer                                 | Disabled
P2P-PnrpOnly                                                | Disabled
MSMQ-Server                                                 | Disabled
MSMQ-Triggers                                               | Disabled
MSMQ-ADIntegration                                          | Disabled
MSMQ-HTTP                                                   | Disabled
MSMQ-Multicast                                              | Disabled
MSMQ-DCOMProxy                                              | Disabled
MSMQ-RoutingServer                                          | Disabled
Printing-XPSServices-Features                               | Enabled
DFSN-Server                                                 | Disabled
ADFS-FederationService                                      | Disabled
ADFS-FederationServiceProxy                                 | Disabled
ADFS-WebAgentClaims                                         | Disabled
ADFS-WebAgentToken                                          | Disabled
RightsManagementServices                                    | Disabled
RMS-Federation                                              | Disabled
RightsManagementServices-AdminTools                         | Disabled
QWAVE                                                       | Disabled
PeerDist                                                    | Disabled
SIS-Limited                                                 | Disabled
Microsoft-Hyper-V                                           | Enabled
VmHostAgent                                                 | Disabled
Microsoft-Hyper-V-Management-Clients                        | Enabled
DamgmtTools                                                 | Disabled
Internet-Explorer-Optional-amd64                            | Enabled
SMBHashGeneration                                           | Disabled
ServerMigration                                             | Disabled
Xps-Foundation-Xps-Viewer                                   | Disabled
TIFFIFilter                                                 | Disabled
Microsoft-Windows-RemoteFX-Host-Package                     | Disabled
Microsoft-Windows-RemoteFX-EmbeddedVideoCap-Setup-Package   | Disabled

Saturday, 26 December 2015 09:58:46 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Thursday, 10 December 2015

Honey, There are cows out back, and they aren't ours !

Had a couple visitors show up from the neighbors.

 

Thursday, 10 December 2015 06:48:36 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Monday, 07 December 2015

Continuously I'm having issues with windows Explorer / File Manager with ACL's and NTFS permissions for SQL Server files, folder and logs.  All this is related to removing permissions and keeping things as granular as possible, but it creates headaches for DBA.

Anyway, always use robocopy for file copy, ensure to open "command prompt" with "run as administrator".  [xopy can work as well, but different switches].

robocopy o:\backups3\ o:\backups\ *.* /MT:10 /e /mir /sec /R:3 /W:15 /XD "RECYCLE" "System Volume Information"

https://www.autoitscript.com/forum/topic/95337-autoit-script-using-robocopy/

http://answers.microsoft.com/en-us/windows/forum/windows_other-windows_programs/how-to-use-robocopy-to-exclude-directories/b4f95d5b-1c5c-e011-8dfc-68b599b31bf5?auth=1

Don't forget that if you detach database in SSMS that sometimes "permissions" to the MDF, NDF and LDF are "removed" and / or replaced with your domain\{id} user credentials, and you may have to "default" them back to "NT Service\MSSQLSERVER" or "NT Service\MSSQL${Instance}" and/or the service account SQL Runs under as well.

 

Monday, 07 December 2015 09:17:39 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Search
Popular Posts
Unpatched Vulnerabiltiy discovered ...
Spring Fornicator brewed...
DTA - Failed to initialize MSDB dat...
SQL Server Security, not where it n...
Check the Uptime of a Windows Serve...
Recent Posts
Archive
May, 2017 (2)
April, 2017 (1)
March, 2017 (1)
February, 2017 (1)
December, 2016 (2)
October, 2016 (2)
September, 2016 (1)
August, 2016 (1)
July, 2016 (1)
March, 2016 (2)
February, 2016 (3)
December, 2015 (4)
November, 2015 (6)
September, 2015 (1)
August, 2015 (2)
July, 2015 (1)
March, 2015 (2)
January, 2015 (1)
December, 2014 (3)
November, 2014 (1)
July, 2014 (2)
June, 2014 (2)
May, 2014 (3)
April, 2014 (3)
March, 2014 (1)
December, 2013 (1)
October, 2013 (1)
August, 2013 (1)
July, 2013 (1)
June, 2013 (2)
May, 2013 (1)
March, 2013 (3)
February, 2013 (3)
January, 2013 (1)
December, 2012 (3)
November, 2012 (1)
October, 2012 (1)
September, 2012 (1)
August, 2012 (1)
July, 2012 (4)
June, 2012 (3)
April, 2012 (1)
March, 2012 (3)
February, 2012 (3)
January, 2012 (4)
December, 2011 (3)
October, 2011 (2)
September, 2011 (2)
August, 2011 (8)
July, 2011 (4)
June, 2011 (3)
May, 2011 (3)
April, 2011 (1)
March, 2011 (2)
February, 2011 (3)
January, 2011 (1)
September, 2010 (1)
August, 2010 (2)
May, 2010 (2)
April, 2010 (3)
March, 2010 (1)
February, 2010 (4)
January, 2010 (1)
December, 2009 (3)
November, 2009 (2)
October, 2009 (2)
September, 2009 (5)
August, 2009 (4)
July, 2009 (8)
June, 2009 (2)
May, 2009 (3)
April, 2009 (9)
March, 2009 (6)
February, 2009 (3)
January, 2009 (8)
December, 2008 (8)
November, 2008 (4)
October, 2008 (14)
September, 2008 (10)
August, 2008 (7)
July, 2008 (7)
June, 2008 (11)
May, 2008 (14)
April, 2008 (12)
March, 2008 (17)
February, 2008 (10)
January, 2008 (13)
December, 2007 (7)
November, 2007 (8)
Links
Categories
Admin Login
Sign In
Blogroll