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 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...]
How to Show Field Values as Columns in SQL Server
One of the most asked questions by users when they pull data using T-SQL is whether or not there's a way to present the values of a field they're interested in as columns instead. The answer is of course it's "Yes." You can achieve this by using PIVOT relational operator if you use MSSQL 2005 or later. Without PIVOT With PIVOT Further Reading Using PIVOT and UNPIVOT SQL Server … [Read more...]
How to reset SA password on Microsoft SQL Server
If you happen to forget your sa password, you can still recover it as long as you have access to the server. Here are the steps to do it. Steps Launch Sql Configuration Manager under Configuration Tools folder. Look for your SQL Server instance (the default is MSSQLSERVER) and stop the service. You can click the stop button while having the SQL Server (MSSQLSERVER) row highlighted or you … [Read more...]
Ways to Upsert a Record in SQL Server
To continue the previous post, this article demonstrates ways to do Upsert (update and insert) and how MERGE statement in SQL Server 2008 (or later) can be more efficient to perform the two operations at once. First we'll create a table for this demo. We want to do update if the Id is found on the table and insert if it's a new Id number. 1. Conventional way of doing it is by using IF … [Read more...]