Posts Tagged ‘HOWTO

Explanation on how to use PowerShell to automate generating a build file. Code and walkthrough included.

Tutorial on how to test and verify account permissions with impersonation in SQL Server.

T-SQL functions for converting between Gregorian and Julian dates.

T-SQL query to report the row count of all tables in a database without the heavy I/O cost of a table scan.

SQL Server T-SQL function to calculate the number of weekdays between two dates and helper function to return the maximum of two integers.


  • shiva ramani: good instruction. How to push data to MySQL from SQL 2005 [...]
  • Winkey: I've created a linked server for mysql successfully, and also can do Insert, Select. But when I try [...]
  • RaghuRam: Thanks a lot buddy it helped me to change the root password when I got the error trying to c [...]
  • Taylor Gerring: If you're on a 64-bit OS, did you run the 32-bit version of ODBC applet? Run: odbcad32 [...]
  • Taylor Gerring: If the issue is the guest sync'ing to the host, can't you just force time sync the host if you can't [...]


This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.