Presented on SQL 2012/2014 – What You Need to Know

Presentations, Speaking
Yesterday New Horizons in Fort Lauderdale asked me to present to some of their customers on SQL 2012 and and 2014, focusing in on the new features most essential to know. You can find the slides in the Presentations link above. The presentation was only 3 hours, so I really struggled with what to cover, and I boil down the most important features to these: AlwaysOn in SQL 2012/2014 Clustered ColumnStore Indexes in SQL 2014 (2012 has Non Clustered ColumnStore Indexes only) In-Memory OLTP in SQL 2014 Yes, I talked about DQS,MDS,Tabular,SSIS Project Model, T-SQL Enhancements, Azure options, and some other cool features. But the three above are, in my opinion, the most important. Disagree with me? Let me know your opinion in a comment or by contacting me!
Read More

Great time at Florida .Net UG in West Palm

PowerShell, Presentations, Speaking
Whew! Presentation on PowerShell for Developers to the Florida .Net user group went well, and it was a very lively group. I went in expecting to dig deep into applying PowerShell for GUI application development, deployment and the like. But we had a lot of folks very new to PowerShell, and we had a very interactive presentation and discussion with lots of good questions.  I instead focused on using the PowerShell 3 ISE as a starting point to new students to PowerShell, and taking advantage of this tool (along with the basic three Get Cmdlets, remember those? :) ) to make those uncomfortable first steps to learning a new technology as easy as possible. It is my hope that many in the group will get excited about learning something that's…
Read More

Presenting PowerShell for Developers to Florida.net UG in West Palm

PowerShell, Presentations, Speaking
I've been asked to present to the Florida.Net user group in West Palm this week, and chose to present on PowerShell for Developers, and here's why. There are incredible possibilities and utility in PowerShell, most of the marketing and discussion on the web is for I.T. administrators, rather than developers (though there are some signs this is changing.) The conventional wisdom (and humor) tells us that people in I.T. must fit into either of these categories. Here's another perspective. As a consultant and trainer, I need broad familiarity with technology. I'm focused on Windows, with some geek love for Linux :). SQL Server is my technology focus, but Windows Server setup and configuration are important to ensure it runs well. I have built and also supported .Net applications that rely on…
Read More

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

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