Archive for the ‘Windows’ Category
Converting between Gregorian and Julian Dates
In: SQL Server
23 Oct 2008T-SQL functions for converting between Gregorian and Julian dates.
- No Comments
- Tags: calendar, date conversion, dateadd, DATEDIFF, DATETIME, gregorian, HOWTO, julian, UDF
I 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.
- No Comments
- Tags: Review, SQL Server, SQL Server 2008, T-SQL
Displaying row count for all tables
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.
- No Comments
- Tags: DMV, HOWTO, SQL Server, SQL Server 2005, SQL Server 2008, T-SQL
Calculate Weekdays Between Two Dates
In: SQL Server
24 Sep 2008SQL Server T-SQL function to calculate the number of weekdays between two dates and helper function to return the maximum of two integers.
List to Table Function
In: SQL Server
22 Sep 2008Split delimited values into a table using T-SQL UDF.
- No Comments
- Tags: function, HOWTO, SQL Server, UDF
- HOWTO: Sync Google Calendar on iPhone OS 3.0
- HOWTO: Setup SQL Server Linked Server to MySQL
- Connecting to Oracle from SQL Server
- Windows 7 in VirtualBox: Shared Folders workaround
- Fixing "passwd: Authentication token manipulation error" when changing passwords
- Installing Windows 7 Beta 1 in VirtualBox 2.1.0
- HOWTO: Synchronize Dropbox and ZumoDrive on Windows
- Updating SSH known hosts fingerprints (WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!)
- HOWTO: Connect to MySQL in SSIS
- Efficiently query the DATE in DATETIME
- Stop SOPA
- Access system date in SSIS without a Script Task
- Connecting to Oracle with SSIS 2008
- Set Permissions Across SQL Server Database Instances
- SQL Server Principals & Roles Permission Audit
- New Office Outlook 2010 Data File Menu Item
- Why RAM Matters Less with OS X Lion
- Cache multiple values in a Map Container for fast in-memory lookup
- Ubuntu VirtualBox Server Redux Addendum
- Default column value to identity of different column
- KALImaR:Im having the same 11.10 problem with this irritating disaster...Solutions please [...]
- Balkan:Hi All, I have similar problem as Dwarakesh, I set the automatic login on, and after that my passwo [...]
- Creating an automated database backup by means of SQL Server Agent Job « Placko's SQL KB:[...] Configuring SQL Server Agent Operators by Taylor Gerring [...] [...]
- Dwarakesh:yeah even I'm getting the same error on my sony e series laptop!!!! I am currently running ubuntu 1 [...]
- Phil:Thanks - this article was a great help. [...]
