Category Archives: System/DB Administration

Meltdown and Spectre patches, via SQLServerCentral

http://www.sqlservercentral.com/articles/SQL+Server/166822/?utm_source=SSC&utm_medium=pubemail  

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

SQL Server diagnostics notes

This week’s amusement: performance of a recently-implemented Stored Procedure dropped and dropped to intolerable levels. This system cannot be easily upgraded. Significant fragmentation is involved. Memory pressure is involved. Inserts to table variables in multiple stored procs are involved. This … Continue reading

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

tip: passive error and warning messages

It’s best to put error/warning messages in very passive, non-blaming language, especially if users might see them. Avoid exclamation marks unless something is seriously wrong and they need to take immediate action, and in that case tell them which actions … Continue reading

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

Windows 10 wireless displays

https://www.hanselman.com/blog/UseASecondLaptopAsAnExtendedMonitorWithWindows10WirelessDisplays.aspx Cool!

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

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 https://www.red-gate.com/simple-talk/sysadmin/containerization/overcoming-challenges-microservices-docker-containerisation/?utm_source=DBW&utm_medium=pubemail Lab Guide Working with Containers on Windows 10–Includes Docker and Nano Step-By-Step https://github.com/docker/labs/blob/master/windows/windows-containers/Setup-Server2016.md  

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