Archive for the ‘Windows’ Category
Use a CTE to recursively roll up all descendant records into separate groups, regardless of level. Example data and Common Table Expression code included.
Control Startup Program Order with PowerShell
In: Windows
14 Apr 2009A highly flexible way to ensure programs are started under the correct conditions, in the proper sequence, with timed delay.
- (3) Comments
- Tags: HOWTO, PowerShell
HOWTO: Setup SQL Server Linked Server to MySQL
In: SQL Server
25 Feb 2009An illustrated, step-by-step guide for connecting MySQL and SQL Server via Linked Servers utilizing the MySQL ODBC Connector driver.
Efficiently query the DATE in DATETIME
In: SQL Server
17 Feb 2009The DATETIME data type is often misunderstood and used inefficiently, forcing table scans with YEAR or MONTH functions. With the proper knowledge and tools, developers can more efficiently leverage the DATETIME data type and speed up slow-running queries.
- (3) Comments
- Tags: SQL Server, T-SQL
Top 10 Cross-Platform Open Source Apps
10 Feb 2009Open source applications have a natural inclination to be compiled for multiple operating systems. Although many OS‘s and tools are converging in functionality, it’s nice to have a homogeneous environment of favorite programs to make the transition from machine to machine more seamless. I use Windows and work and Linux at home, but that doesn’t mean I have to give up anything in the process. Below are – in no particular order – some of my favorite cross-platform open source applications.
- 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. [...]
