Business Reasons For Implementing Power BI

Data is stored in heterogenous environments in many organizations. Enterprise reporting for management and other departments is created using a variety of tools.  There are Excel Workbooks, SSRS Reports, Tableau Dashboards, flat files, data streams from MySQL databases, etc.  Each data extract or report is created by a BI or DB Development Team member.  Often […]

Tip: Resetting Identity Fields

How to reset an identity field to the next contiguous value, after deletions.

Solving a Problem Importing Integers Using Format Files

When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.

Clustered Index Internals

usp_ShrinkAllLogs

Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.

SQL Server 2008 Upgrade Gotchas & Fixes

Preparation for upgrading SQL Server 2005 production database servers to SQL Server 2008, I tested upgrade in dev/test env.

Script SQL Table Schema as XML-XSD

When creating XML messages for Service Broker or other applications use this simple method to build a validation XSD.

usp_SQL_In_sp_who2

Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID

usp_ShrinkDBLogs

A T-SQL script to truncate your user database logs.