• About Me
  • Articles
ExpressNetSolutions.com Microsoft SQL Server with the occasional foray into Oracle

SQL Saturday #222 coming to Sacramento CA on July 27, 2013

June 12, 2013 2:09 pm / Leave a Comment / sqldch

The Sacramento SQL Server users group is happy to announce the second annual SQL Saturday in Sacramento to be held on July 27, 2013.  Our schedule boasts five tracks with six sessions in each track, adding up to 30 speakers coming from all parts of the globe.  We will be well represented with local talent, … Read More →

Posted in: Sacramento SQL Server user group

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

August 21, 2012 3:59 pm / 1 Comment / sqldch

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 Bottel (@SacSQLdude), Helen Norris (@hpnorris), Jon Amen (@dungeongurunet), Eric Freeman (@sqlelf), Tom Keller (@tomkeller02) and … Read More →

Posted in: Sacramento SQL Server user group, SQL Server general

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

April 12, 2012 8:16 am / Leave a Comment / sqldch

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 Scripture we were studying in church.  It wasn’t addressing a group of parents about our … Read More →

Posted in: Sacramento SQL Server user group, SQL Server general / Tagged: Dan Hess, database mirroring, presentation, Sacramento SQL Server user group, slide deck, Transparent Data Encryption

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

March 16, 2012 12:33 pm / Leave a Comment / sqldch

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!

Posted in: Sacramento SQL Server user group

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

January 30, 2012 4:42 pm / Leave a Comment / sqldch

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 Server 2000 service pack 4 Installed the updated Windows Installer 4.5 Launched the “System Configuration … Read More →

Posted in: Random errors and weird experiences / Tagged: Database Engine Recovery handle failed, error 15116, password complexity, severity 16, sqlagent90_msdb_upgrade.sql, SqlEngineDBStartConfigAction_upgrade_configc_Cpu32, upgrade SQL Server

“In transit” encryption to SQL Server

December 13, 2011 11:03 pm / Leave a Comment / sqldch

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 transit” encryption is the encryption of the data packets at the network level. IPsec does … Read More →

Posted in: SQL Server general / Tagged: certificate, force encryption, in transit encryption, ipsec, secure sockets layer, self-signed certificate, sql server configuration manager, sql server encryption, ssl, transit encryption

Simple restore using T-SQL

December 8, 2011 12:06 am / Leave a Comment / sqldch

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), among other things. You’ll use this information if you’re renaming or moving the .MDF or … Read More →

Posted in: SQL Server w/o the GUI / Tagged: restore, restore filelistonly, t-sql, with move

PASS Summit 2011 first timer, three days of awesomeness

October 15, 2011 2:19 am / Leave a Comment / sqldch

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 at the conference on Tuesday night, too late to attend the ‘first timer’ event. I … Read More →

Posted in: Random errors and weird experiences

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

September 15, 2011 1:03 am / Leave a Comment / sqldch

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 took me three tries to be successful. My first attempt failed with the following, non-descript … Read More →

Posted in: Random errors and weird experiences

Getting information from Oracle into SQL Server using SSIS

May 4, 2011 7:50 pm / Leave a Comment / sqldch

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 this successfully using the IMPORT data wizard (and had my application owner confirm the data) … Read More →

Posted in: Working with Oracle

Post Navigation

1 2 Next »

Useful Links

  • Jon Amen's blog
  • My LinkedIn profile
  • Sacramento SQL Server Users Group

Categories

  • Random errors and weird experiences (5)
  • Sacramento SQL Server user group (4)
  • SQL Server general (3)
  • SQL Server w/o the GUI (4)
  • Working with Oracle (2)

The Latest

  • SQL Saturday #222 coming to Sacramento CA on July 27, 2013
  • SQL Saturday #144 – The Good, the Bad and the Ugly
  • My first SQL Server presentation – database mirroring w/ Transparent Data Encryption
  • SQLSaturday #144 coming to Sacramento CA on July 28, 2012
  • Another “Wait on the Database Engine Recovery handle failed” – SQL Server 2000 to 2008R2 upgrade

@SQLDCH Twitter feed

Tweets by sqldch

Follow @sqldch

Powered by Twitter Feed

RSS SQL Server Central daily articles

  • Review: Stellar Phoenix SQL Database Recovery
  • Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell
  • An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services
  • PASS Data Architecture Virtual Chapter presents Steve Simon
  • Usage of CTE - Trick with Dates

RSS Jon Amen’s blog

  • Updating a Slowly Changing Dimension with a Recursive Relationship on its Key
  • Creating a Solid SSIS ETL Solution: Part 4 – Email Task and Package Execution Report
  • Creating a Solid SSIS ETL Solution: Part 3 – Package Template Overview

Tags

certificate create date Dan Hess database Database Engine Recovery handle failed database mirroring error 15116 force encryption freezes hangs in transit encryption ipsec linked server microsoft ole db oracle ole db password complexity presentation recovery model restore restore filelistonly Sacramento SQL Server user group secure sockets layer self-signed certificate severity 16 slide deck sqlagent90_msdb_upgrade.sql SqlEngineDBStartConfigAction_upgrade_configc_Cpu32 sql server sql server configuration manager sql server encryption SQL Server logins ssl sys.databases sys.database_files sys.server_principals sys.sql_logins t-sql transit encryption Transparent Data Encryption unresponsive upgrade SQL Server with move
© Copyright 2013 - ExpressNetSolutions.com
Infinity Theme by DesignCoral / WordPress