Category Archives: Presentations

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

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:

  1. AlwaysOn in SQL 2012/2014
  2. Clustered ColumnStore Indexes in SQL 2014 (2012 has Non Clustered ColumnStore Indexes only)
  3. 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!

Great time at Florida .Net UG in West Palm

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 not just a useful and marketable skill, but fun to do! If you attended and have follow up questions or need reminders of the resources I referred to, please contact me. I think the slides will be less useful than set of resource links to help learning the fundamentals of PowerShell. Looks like I have work to do….

I want to take a moment to thank thank three guys that provided me with some slides and demos to to share. Mike Robbins, Michael West, and Michael Cruz. (Yes, three Mikes helped me.) Thanks gents! Hope to ‘see’ you April 16th at our next Florida PowerShell user group virtual meeting!

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

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 SQL Server, so the Frameworks and how they connect and interact with my SQL Server are important as well. Like many I.T. professionals I work with many interrelated technologies, and staying effective means knowing about both administering my servers and developing and supporting applications.

So while the I.T. industry seems to push us to specialize, there will always be a place for people who excel in both systems administration AND development, particularly in small companies where wearing many I.T. hats is a necessity. And as the technology continues to develop, learning new technology is essential to staying relevant and valuable in the marketplace. But time is a limited resource, so getting familiar and productive quickly is essential.

This brings us to why I believe PowerShell to be so important, especially to developers. PowerShell is built on the .Net Framework, so developers get a jump on the rest of us in learning and applying it. While the learning curve can seem steep, with a basic knowledge of this tool you can then leverage the tools of others, to solve problems and develop new solutions quickly. Microsoft’s latest Server 2012 comes with dozens of PowerShell modules built in. There are PowerShell modules for Microsoft technologies like IISWindows Azure, and Hyper-V. But not just Microsoft:  Amazon AWS, VMWareDell Servers, and many other companies understand that leveraging PowerShell is good for the customer and for business. 

So any technology professional on the Windows platform, whether administrator, developer or somewhere in between, should seriously consider investing the time to learn PowerShell so they can be more effective.

I’m excited about PowerShell. I’ve just been learning it over the last few months, and it has already helped me solve problems for clients, and made me a better consultant. So my goal for my presentation this week is to introduce both the basics of PowerShell and its possibilities to the developers in attendance, so they might get excited about PowerShell and how they can leverage it to be better at what they do.

I’ve been too long without blogging… I mean, who really reads this stuff? But if you took the time to read this, please contact me or comment below and let me know what you think, and perhaps you can help inspire me to continue blogging regularly. 🙂 Thanks!

SQL 2012 and PowerShell 3 talk at Florida.Net UG

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….

SQL 2012 and Powershell 3 SFSSUG Talk

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 to share.

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

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 interested, or have other questions, please  contact me.

I’d love to hear from you!

-David