Category Archives: SQL Server

Password Strength Is A Hard Problem

Posted on August 31, 2019 by Gaius

We are all familiar with the classic advice on password strength, a mix of lowercase, uppercase, symbols, numbers, of a certain length. It is trivial to construct a validator for password strength in Python The problem with this is that … Continue reading →

Posted in Cyber, Linux, Microsoft, Python, Random thoughts, SQL Server | Tagged , , , | Leave a comment

Microsoft Professional Program Cybersecurity

Posted on August 16, 2019 by Gaius

In a previous job, amongst many other things I was responsible for the tending of a small herd of HP DL-whatever servers, ~1500 machines all running RHEL. These were considered mission-critical for the business unit. I used various tools for … Continue reading →

Posted in azure, Cloud, Cyber, edx, Linux, Microsoft, Random thoughts, SQL Server | Tagged , , , , , , | 2 Comments

Performance tips

Posted on May 10, 2011 by Gaius

One pretty cool new feature of Oracle 11g that DBAs may not be aware of is the client result cache. This stores the result sets of queries hinted with /*+ result_cache */ locally in-memory on the client. It’s much better … Continue reading →

Posted in Oracle, SQL Server | 2 Comments

Porting stored procedures

Posted on April 8, 2011 by Gaius

(Based on a Stack Exchange post) In SQL Server, a common pattern is to wrap some processing in a stored procedure that returns a standard result set, using a local temporary table, which is to say a table defined within … Continue reading →

Posted in Oracle, SQL Server | Leave a comment