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 →
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 Bottel (@SacSQLdude), Helen Norris (@hpnorris), Jon Amen (@dungeongurunet), Eric Freeman (@sqlelf), Tom Keller (@tomkeller02) and … 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 Server 2000 service pack 4 Installed the updated Windows Installer 4.5 Launched the “System Configuration … 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 transit” encryption is the encryption of the data packets at the network level. IPsec does … 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), among other things. You’ll use this information if you’re renaming or moving the .MDF or … 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 at the conference on Tuesday night, too late to attend the ‘first timer’ event. I … 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 took me three tries to be successful. My first attempt failed with the following, non-descript … 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 this successfully using the IMPORT data wizard (and had my application owner confirm the data) … Read More →
