Technology Musings
In: Windows
31 Oct 2008Explanation on how to use PowerShell to automate generating a build file. Code and walkthrough included.
In: SQL Server
28 Oct 2008Tutorial on how to test and verify account permissions with impersonation in SQL Server.
In: SQL Server
23 Oct 2008T-SQL functions for converting between Gregorian and Julian dates.
In: SQL Server
2 Oct 2008I stumbled upon a few little gems that SQL Server 2008 includes that I hadn’t yet heard about. Although, very few are deploying SQL 2008 to production currently, these enhancements might make life programming in 2008 much easier.
In: SQL Server
1 Oct 2008T-SQL query to report the row count of all tables in a database without the heavy I/O cost of a table scan.