T-Sql

SQL injection is a web security vulnerability that replaces the OWASP (Open Web Application Security Project) Top 10 every year. In shortly, SQL injection is …

In this article, I will explain how to backup and restore database backups with SQL Server Management Studio. The backup process is to keep an instance of all …

Many times we have to build reports which list customers/employees/orders etc in the system. At times when the systems are very large, the listing runs into …

Recently we faced a situation where the server hosting our Analysis Services ran out of the space on the primary C drive. After looking at the files stored on C …

We as database developers, many times have to export data into csv files and send them across to the Business users. The data the needs to be exported can be a …

Many times when we normalize our database, we end up storing multi-values attributes as separate rows in table. For eg. Consider we are storing Photos and a set …

In one of my earlier post Creating a Delimited list from a column of a table, we had seen how to generate CSV (demilited string) from column values in a table …

To support multi-value params, many times we use XML data type as input param. There are multiple ways to parse XML data in SQL Server. Lets have a look at them …

In this script post, we will look at different ways to get the list of user defined tables in a particular database, along with their rowcount and size …

There are three levels of data modeling. They are conceptual, logical, and physical. This section will explain the difference between the three, the order with …

Tables are the basic structure where data is stored in the database. Given that in most cases, there is no way for the database vendor to know ahead of time …

Views can be considered as virtual tables. Generally speaking, a table has a set of definition that sets the structure of the table, and physically stores the …