Timothy A Wiseman is a Database Administrator for SAIC with a focus on efficiency and readability of the database and its surrounding ecosystem. In addition to administering the core SQL Server system, he has experience working with Python and Microsoft Access in conjunction with SQL Server. He holds a Bachelor's of Science in Mathematics as well as an MCDBA and MCITP.
As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows even more sophisticated scripting possibilities for managing automated database tasks. … Read more
So much has been written about SQL Injection, yet such attacks continue to succeed, even against security consultants' websites. The problem is often that only part of the solution is described, whereas the best practice requires the use of defense in depth.
… Read more
Python is increasingly used by DBAs as a general-purpose scripting language, despite the pressure to adopt Microsoft's PowerShell. They find it easy to learn, powerful, and reasonably intuitive. Here Timothy Wiseman, a working DBA, explains the attraction of Python and gives a general introduction to the language, suitable for anyone who has been wondering whether to give it a try.
… Read more