IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact

How to Get Table Definition in SQL Server

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...]

January 21, 2020 Filed Under: How To Tagged With: SQL, SQL Server

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...]

May 22, 2019 Filed Under: How To Tagged With: Microsoft, Python, Windows Server

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...]

May 2, 2019 Filed Under: How To Tagged With: IIS, Information Security, Internet, Internet Information Services

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...]

April 5, 2019 Filed Under: How To Tagged With: iOS

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...]

March 20, 2019 Filed Under: How To Tagged With: IIS, Internet Information Services, PostgreSQL, SQL

  • 1
  • 2
  • 3
  • …
  • 22
  • Next Page »

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • WordPress
  • Writing

Recent Posts

  • F#: Seq, List, Array, Map, Set. Which One to Use?
  • How to Get Table Definition in SQL Server
  • Why You Need to Use a VPN
  • How to Use Custom Color in SSMS Using Redgate SQL Prompt
  • How to Install Python on Windows Server
Web Hosting

Recent Posts

  • F#: Seq, List, Array, Map, Set. Which One to Use?
  • How to Get Table Definition in SQL Server
  • Why You Need to Use a VPN
  • How to Use Custom Color in SSMS Using Redgate SQL Prompt
  • How to Install Python on Windows Server
  • RSS

Tags

.NET Core Access Adobe AdSense Amazon ASP.NET Cdonts Dll Classic ASP Code Editor Connect-It Copywriting ETL FSharp Genesis Framework Git Google HP Asset Manager HTML HTML5 Hugo IIS Information Security Internet Internet Information Services iOS Linux macOS Microsoft Microsoft SQL Server MVC PHP Simple Mail Transfer Protocol Smtp Server Social Media SQL SQL Server SSIS SSMS SSRS VPN Windows Windows 8 Windows 10 Windows 2012 Windows Server

Copyright © 2011-2021 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure