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

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

Free hands-on SQL 2008 training from Microsoft!

SQL
While the folks at Microsoft have offered these for a long time, I'm sure most people don't know about it. Technet Virtual Labs offers focuses 90 minute virtual labs so you can play with new features in the latest Microsoft technologies just using Internet Explorer. Check out the SQL Server 2008 section to learn about features that interest you... like the two clustering labs... before they release SQL 2012 :)
Read More

DIY Hyper-V, Active/Active Clustering and SQL Server – Demo and Step by Step Instructions

Clustering, Hyper-V, Presentations, Speaking, SQL
Recently spoke at South Florida IT Camp Saturday on using Hyper-V, Windows Server 2008 R2 SP1 Enterprise, Microsoft iSCSI Target 3.3, and SQL Server 2008 R2 SP1 to create an Active-Active SQL Cluster. I actually managed to cover all the cool parts in an hour, and got some great feedback. If you're interested in implementing this demo yourself, I've posted: Network Diagram (Overview of the virtual server components in the SQL Cluster) Step by Step Instructions (The steps I took to create the Active/Active SQL Cluster) Hyper-V SQL Clustering Worksheet (Planning the values in this worksheet in advance makes this process simple.) My Slide Deck (Because everyone loves PowerPoint) I need someone who's interested to volunteer as my 'technical editor'.. To walk through these steps, help me clarify or correct anything unclear. If you're…
Read More

SQL cluster on the cheap with Hyper-V and iSCSI

Current Events, Presentations, Speaking, SQL
Speaking on how to set up SQL clustering in a virtual environment, for development and testing. Discuss options for production deployment. Now, how to compress 9 hours of setup into a session... Expect some smoke and mirrors along with some neat technology. Does anyone have some SSDs I can borrow? :) July 23rd http://itcampsaturday.com/southflorida/ Tentative outline: Setup Hyper-V Host Install two virtual networks (lan,iscsi) Create OS template Deploy and install 3 servers Configure iSCSI storage and targets Configure Windows Cluster Install SQL Node 1 Add SQL Node 2 Test Discuss production deployment options Q & A
Read More