Whenever you need to pull a quick definition of a table in SQL Server. Here's the SQL command (T-SQL) to get the table definition in a database: The result would be something similar to this: COLUMN_NAME DATA_TYPE IS_NULLABLE AccountNo int(10,0) YES AccountName varchar(50) YES Balance money(10,2) … [Read more...]
How to Install Python on Windows Server
Python is an excellent general purpose language that can be used for batch processing and other tasks on your server. To install Python on Windows Server operating system, you just need to run the installer and use the simplest configuration. Steps to Install Python on Windows Server Operating System Download the installer (full as opposed to the web sintaller) and … [Read more...]
How to Enable Secure HttpOnly Cookies in IIS
Session cookies are often seen as one of the biggest problems for security and privacy with HTTP, yet often times, it's necessary to utilize it to maintain state in modern web applications. By default, it is insecure and vulnerable to be intercepted by an authorized party. Cookies typically store session identifiers that may offer full access to an account, therefore if a cookie is intercepted, … [Read more...]
How to Create iCloud Mail Email Address
Many people assume that just by creating an Apple ID, they automatically have an iCloud email address. This is not necessarily the case since people typically use a different email address as their Apple ID. In order to use an @icloud.com (or @mac.com, @me.com for that matter) email address, you must set that up separately and this is actually a required step if you plan to use iCloud … [Read more...]
How to Import IIS Log to PostgreSQL
If you ever had a need to dump and analyze IIS logs from a database, this post will show you how to do it in PostgreSQL RDBMS. The assumption is that you're already familiar with the default installation and setup of PostgreSQL, if not please check the manual link at the bottom of this post. We will use default settings. Steps to Create IIS Log Table and Import Log File to PostgreSQL Create … [Read more...]