SQL 2012 and PowerShell 3 talk at Florida.Net UG

PowerShell, Presentations, Speaking, SQL
After some tuning I re-presented my talk on SQL 2012 and PowerShell 3 for the Florida.Net user group. They let me ramble on much longer, so I had the chance to do more demos and step through the code more thoroughly. Recieved some really great feedback, and saw more than a few people may have caught the PowerShell bug :) The updated slides are on SlideShare.net. If I get five or more requests via email or my contact form, I'll post the code as well. Just want to check whether this internet thing is working....
Read More

SQL 2012 and Powershell 3 SFSSUG Talk

PowerShell, Presentations, Speaking, SQL
Spoke last night on SQL 2012 and Powershell 3 at South Florida SQL Server User Group today. Thanks guys for having me! I had lots of content, and was ready to dive into changes from PowerShell 2 to 3, new SQL 2012 Cmdlets, and coding with SQL Management Objects. However most of the group was just starting out with PowerShell, so I had to shift direction, ended up talking more than demoing. :)   Would be interested in doing a PowerShell 101 class for any user group interested in the future. PowerShell is just an incredible tool that any DBA, Server Admin or Developer should learn and apply. I've posted the slides on SlideShare.net I'll post the demo code as well shortly if requested, it needs some cleanup before it's ready…
Read More

SQL Alert when you’re low on disk space

Resources, SQL
I found this gem while troubleshooting a SQL Server with a backup drive that filled up often. It uses the WMI provider will alert when ANY drive on the server goes below 10GB. You can change the value '10000000000' below to adjust this. You'll also want to change your operator from 'Support' to your operator name.  Note that this requires Database Mail to be set up with an operator and valid email. Should work for SQL 2005 thru 2012 as is, mine was set up on SQL 2005. The ability to use WMI Provider in SQL Alerts seems very useful, I have seen uses for WMI SQL Alerts, but they involved more code than just creating the alert. If you're interested in exploring the metrics WMI exposes to you, check out…
Read More

Windows 8 is released to manufacturing

General
They just posted the release of Windows 8 20 minutes ago. http://blogs.msdn.com/b/b8/archive/2012/08/01/releasing-windows-8-august-1-2012.aspx I'm officially on the lookout for a reliable howto for setting up dual boot on my Win7 Ultimate laptop. I DO NOT have the time to learn by trial and error. :) Anyone?
Read More

Copying indexes from Oracle to SQL Server

Oracle, Resources, SQL
I'm working with a client that has access to an Oracle 10g database containing transactional data that they copy to their new SQL Server 2012 as a data warehouse. (We recently migrated the straight from SQL 2000 into SQL 2012, but that's another story.) They already had scripts to copy the tables and data to a staging database, and then copy new records to their data warehouse. Queries were slow against this data, as no indexes were created on the target tables. I wanted to copy the Oracle indexes to SQL Server, but found no simple way to do this, so I created a script to do so. I used Toad for Data Analysts to connect to the Oracle database, which is a really fantastic program for working with Oracle.…
Read More

The great adventure: Migrating from SQL 2000 to 2012

Oracle, SQL
I worked with a client that migrated from SQL 2000 32 bit database straight up to SQL 2012 64 bit! Quite a challenge, and quite the journey over 12 years and 5 releases (2000,2005,2008,2008R2,2012) of SQL. Some of the complicating factors include: Backup and Restore It is not possible to restore a SQL 2000 backup into SQL 2012. The solution is install an intermediate SQL instance (2005,2008,2008 R2), restore to that instance, then detach and attach into the SQL 2012 instance. For smaller databases, I was able connect to the SQL 2000 database from my SQL 2012 instance and use 'Generate Scripts...' in the context menu to script the objects and data. DTS SQL 2000 DTS packages no longer supported. Found the solution on MSDN from Jyoti Grove's comment. This…
Read More

The SQL Saturday experience!

SQL
This weekend I attended and volunteered at SQL Saturday #141, hosted by the awesome folks at Nova University. I didn't speak this year, but helped out with parking, food, and giving directions to the attendees throughout the day. It was a great experience. If you've enjoyed SQL Saturdays, I highly encourage you to volunteer for one in the future. I met so many great people, and was proud to be a part of such a great community event. I kept running into old friends and¬†acquaintances, some of whom just happened to be experts with aspects of SQL Server that I had questions on... It's great how that works. Thanks to all the sponsors and volunteers who make events like this happen. If you're a techie person that works with SQL,…
Read More

What I’ve been up to

Current Events
Haven't posted in a while. Been working on a few different projects, taking care of clients, staying busy. I've been asked by some SQL students to post sites with useful SQL scripts I've found. There have been so many over the years.. but I've started my Useful SQL Scripts page, and will add to it as I can. Playing around with SQL Azure . Getting my head around working with a database that I'll never touch... While many people won't want to give up control of their databases, I see possibilities for syncing SQL data between a SQL Azure instance and your local SQL 2012 database. Also wanted to learn something outside the SQL Server realm. Been creating some very basic apps using the Sencha Touch 2 javascript/css framework. This lets…
Read More

On the road!

Current Events
I'm on the road, training this week in Tempe, AZ. It's cold, but it's a dry cold! Have 3 client projects in the works, plus learning SQL 2012 ins and outs. Looks like it's going to be a busy year.
Read More