SQL Saturday #144 – The Good, the Bad and the Ugly

SQL Saturday #144 is over but what a great time it was!  Sacramento’s first SQL Saturday boasted close to 200 attendees and showcased great speakers like Steve Jones (@way0utwest) and Kalen Delaney (@sqlqueen).  We were represented with local talent Mitch …

Read more »

My first SQL Server presentation – database mirroring w/ Transparent Data Encryption

I’ve finally cut my teeth on a technical, public presentation on SQL Server. This wasn’t explaining to a bunch of co-workers and managers about the latest features in SQL Server 2012.  It wasn’t sharing my understanding of whatever piece of …

Read more »

SQLSaturday #144 coming to Sacramento CA on July 28, 2012

The Sacramento SQL Server users group is happy to announce that we’ll be organizing our own SQL Saturday event to be held in Sacramento on July 28, 2012. Check out http://sqlsaturday.com/144/eventhome.aspx for more details!

Another “Wait on the Database Engine Recovery handle failed” – SQL Server 2000 to 2008R2 upgrade

I was given the task of upgrading our SQL Server 2000 instance to SQL Server 2008R2. I ran through the following steps to make sure the upgrade would be a success: Took a snapshot of the VM Upgraded to SQL …

Read more »

“In transit” encryption to SQL Server

To encrypt connections to the SQL Server engine, there are a few options: IPsec, that encrypts the whole network packet SSL (Secure Sockets Layer) using “Force Encryption”, which only encrypts the packets sent to the database IPsec + SSL “In …

Read more »

Simple restore using T-SQL

Restoring your database is simple using T-SQL. I begin by using ‘RESTORE FILELISTONLY’ to get information about the files contained in the backup set. It returns a result set with information like ‘LogicalName’, ‘PhysicalName’, ‘FileGroupName’ and ‘Size’ (in 8K pages), …

Read more »

PASS Summit 2011 first timer, three days of awesomeness

My first time attending the Professional Association of SQL Server Summit was amazing! Three days of great people, useful information and free stuff! I had to check an extra bag at the airport to bring home my loot. I arrived …

Read more »

SQL Server upgrade to 2008R2 and “Wait on the Database Engine Recovery handle failed”

Recently, I was tasked with doing an in place upgrade of SQL Server from 2005 to 2008R2.  My environment was virtualized so I had the luxury of snapshot’ing the server before I performed the upgrade.  This was fortunate, as it …

Read more »

Getting information from Oracle into SQL Server using SSIS

I needed to populate a SQL Server database with information from an Oracle database, but found when I created a linked server and ran the INSERT statement manually, I was getting errors regarding truncation and datatypes.  I had already run …

Read more »

Create a linked server to an Oracle database (and not lock up the instance)

I’ve created numerous linked servers to Oracle from SQL Server and what should be a straightforward process using SSMS has caused me some headaches.  For whatever reason, when using the GUI, I’ve actually locked up the entire SQL Server instance …

Read more »