Category Archives: System/DB Administration

ClickOnce, Crystal Reports, and dependent projects

Problem causing failure to install ClickOnce project after adding a reference to another project: ERROR DETAILSERROR DETAILS Following errors were detected during this operation. * [7/17/2017 12:01:25 PM] System.Deployment.Application.InvalidDeploymentException (RefDefValidation) – Reference in the manifest does not match the identity … Continue reading

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

Linkdump: Docker, Puppet, SQL Server hosting

http://www.sqlservercentral.com/blogs/the-database-avenger/2017/06/13/orchestrating-sql-server-with-kubernetes/?utm_source=SSC&utm_medium=pubemail http://www.sqlservercentral.com/blogs/the-dba-who-came-in-from-the-cold/2017/06/14/changing-default-location-for-docker-containers/?utm_source=SSC&utm_medium=pubemail    

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

Kendra Little’s free SQL Server training webcasts

New Free Webcasts on Interviewing and Indexing https://littlekendra.com/2017/06/29/new-free-webcasts-on-interviewing-and-indexing/

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

Linkdump: Security- Web pages, Linux, Amazon Web Services

Web pages https://www.owasp.org/index.php/Top_10_2010-Main https://www.owasp.org/index.php/Top_10_2017-Top_10 Linux Don’t believe these four myths about Linux security AWS (Amazon Web Services) https://cloudonaut.io/aws-security-primer/ https://cloudonaut.io/your-single-aws-account-is-a-serious-risk/ https://www.simple-talk.com/sql/database-administration/automating-synchronization-rds-sql-server-agent-jobs-multi-az-environment/

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

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