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) YES UpdateDate datetime NO You need to substitute [MyDB] and … [Continue reading]
In this day and age, with most business transactions done either online or mobile devices, it’s still surprising that many people are still not aware of the danger of using public Wi-Fi, especially the ones without a password (even this “password … [Continue reading]
Continuing the two previous posts on employing custom color in SSMS using the built-in feature or SSMS Tools Pack to reduce error in connecting to a wrong environment, if you have access to Redgate SQL Prompt, this might be the easiest and best … [Continue reading]
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. … [Continue reading]
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 … [Continue reading]