Exporting Data From SQL Server to Script File

SQL Server provides the ability to generate scripts for creating databases, tables, stored procedures, functions, views and inserting data. For Read More …

SQL Server – ANSI_Padding and Scripting from SSMS

Let’s say that you want to quickly create a table from an existing table in another database. If you are Read More …

iCacls and other Tools to set Permissions (Microsoft Windows)

Prior to Windows Vista, CACLS (Change Access Control Lists) was used to manage to complicated NTFS permissions, complement the Folder Read More …

Create New User and Grant Permissions in MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. It has a Read More …

Setup Transaction Replication in SQL Server 2012

Transaction Replication is used when DML or DDL schema changes performed on an object of one database on one SQL Read More …

Using UEFI Instead of the BIOS

New Windows 8 PCs don’t include the traditional BIOS. They use UEFI firmware instead, just as Macs have for years. Read More …

Clone or Copy an Excel PivotTable [VIDEO]

Ever came across a situation where you have to compare PivotTable data from same data source but from different environments, Read More …