Where to Buy a New Laptop

Let’s say that you are in the market to buy a new laptop or ultra book to replace that old...

Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?

Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Extreme Logging

I was having a discussion with Idera (@idera_software) dev lead Vicky...

Rebuild indexes based on fragmentation – sp_RebuildIndex

In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server databases indexes using dynamic management...

Several useful T-SQL Function

1. Using the OVER clause with aggregate functions
The following sample is from BOL:
-------------------------------------
USE AdventureWorks2008R2;
GO
SELECT SalesOrderID, ProductID, OrderQty
    ,SUM(OrderQty) OVER(PARTITION BY...

Why I failed my goals

I have two goals that I have sought to achieve by mid-year of 2012. The deadline I set for myself...

Win A Free Registration to SQLskills Immersion Event 1

You have until July 6 to enter to win a free seat at the SQLskills Internals and Performance (IE1) training...

Get Dependent Databases, Tables, Columns…

Quite often people need to write a new T-SQL application to replace an existing one for various reasons. For instance,...

Using Excel Macro (.xlsm) Enabled Files in SSIS

Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel...

Powershell, SMO, and Add-Member - Not Always BFF

Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of...

Troubleshooting Database Mirroring Error 1418 Updated

Troubleshooting Database Mirroring Error 1418 Updated
Last night I was helping someone with a database mirroring setup problem via email. It...