Category Archives: System/DB Administration

Best Practice: Securing Windows Service Accounts and Privileged Access

Best Practice: Securing Windows Service Accounts and Privileged Access – Part 1 Best Practice: Securing Windows Service Accounts and Privileged Access – Part 2    

Posted in System/DB Administration | Leave a comment

Phil Factor @ SimpleTalk: Statistics in SQL: Pearson’s Correlation

Statistics in SQL: Pearson’s Correlation The series so far: Statistics in SQL: Pearson’s Correlation Statistics in SQL: Kendall’s Tau Rank Correlation Statistics in SQL: Simple Linear Regressions Statistics in SQL: The Kruskal–Wallis Test

Posted in Business Intelligence, SQL Server, System/DB Administration | Leave a comment

RedGate: VMWare monitoring in SQL Monitor

VMware monitoring in SQL Monitor  

Posted in SQL Server, System/DB Administration | Leave a comment

Database unit testing resources

Not strictly a linkdump, but a list of resources for database unit testing. tSQLt, SQLunit, DBunit, dbForge

Posted in Linkdump, Programming, SQL Server, System/DB Administration | Leave a comment

Linkdump: SQL Server security through ActiveDirectory Groups, ConnectionString encryption

I swear I have a post or linkdump on this. Log now, search later! Securing SQL Server using ActiveDirectory: https://www.mssqltips.com/sqlservertip/1831/using-windows-groups-for-sql-server-logins-as-a-best-practice/ https://serverfault.com/questions/457798/why-does-a-d-account-need-sql-server-login https://security.stackexchange.com/questions/98247/ad-user-vs-sql-user-for-sql-server-authentication https://dba.stackexchange.com/questions/12453/login-to-sql-server-using-windows-authentication Connection String encryption: https://msdn.microsoft.com/en-us/library/89211k9b(v=vs.110).aspx https://msdn.microsoft.com/en-us/library/ms254494(v=vs.110).aspx http://stackoverflow.com/questions/11637348/encrypt-connection-string-in-app-config https://msdn.microsoft.com/en-us/library/ff647398.aspx          

Posted in Linkdump, SQL Server, System/DB Administration | Leave a comment

Linkdump: SQL Server authentication credentials, users, and logins

Google “best practice for sql server logins”: https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=best%20practice%20for%20sql%20server%20logins Recommendations and Guidelines on Configuring the Authentication Mode for SQL Server https://support.microsoft.com/en-us/kb/2028697 Google “how to set up users and logins sql server”: https://www.google.com/search?q=how%20to%20set%20up%20users%20and%20logins%20sql%20server Best practice on users/roles on SQL Server for a web application http://stackoverflow.com/questions/1395278/best-practice-on-users-roles-on-sql-server-for-a-web-application   … Continue reading

Posted in Linkdump, SQL Server, System/DB Administration | Leave a comment

SQL Server trigger to detect who uses sa login

Note to self: Implement this during next upgrade. http://www.sqlfingers.com/2016/07/using-sql-server-logon-trigger.html

Posted in SQL Server, System/DB Administration | Leave a comment

Linkdump: Working with (Tcl) Expect on Windows

http://expectonwindows.blogspot.com/ https://en.wikipedia.org/wiki/Expect http://expect.sourceforge.net/ http://stackoverflow.com/questions/19460420/running-expect-script-on-windows http://www.admin-magazine.com/Articles/Automating-with-Expect-Scripts http://docs.activestate.com/activetcl/8.4/expect4win/expect.html#exp_close http://docs.activestate.com/activetcl/8.4/expect4win/expect.html#exp_spawn http://tcl.activestate.com/man/tcl8.4/TclCmd/contents.htm?_ga=1.17009081.1244592451.1459347583 http://docs.activestate.com/activetcl/8.4/expect4win/expect.html http://docs.activestate.com/activetcl/8.4/expect4win/ex_usage.html#e4w_commands http://wiki.tcl.tk/3548 Expect script: start telnet, run commands, close telnet http://stackoverflow.com/questions/11250564/how-to-automate-telnet-session-using-expect?lq=1 http://stackoverflow.com/questions/11250564/how-to-automate-telnet-session-using-expect  

Posted in Linkdump, Programming, System/DB Administration | Leave a comment

linkdump: find newest file in folder or subfolders

http://codesnip.net/powershell-script-to-search-files-recursively/http://www.dotnetperls.com/recursive-file-listhttps://support.microsoft.com/en-us/kb/185476http://serverfault.com/questions/62162/shell-command-to-find-the-newest-created-files-recursively-from-a-root-directoryhttp://www.bing.com/search?FORM=U313DF&PC=U313&q=find+newest+file+recursively&src=IE-TopResult&conversationid=http://stackoverflow.com/questions/25493192/powershell-get-childitem-exclude-directory-several-levels-deep?rq=1http://stackoverflow.com/questions/9675658/powershell-get-childitem-most-recent-file-in-directory

Posted in Linkdump, Programming, System/DB Administration | Leave a comment

Creating unique constraints via SSMS

To create a unique constraint In Object Explorer, right-click the table to which you want to add a unique constraint, and click Design (Modify in SP1 or earlier).The table opens in Table Designer. From the Table Designer menu, click Indexes/Keys. … Continue reading

Posted in SQL Server, System/DB Administration | Leave a comment