Microsoft just released SQL 2016 CTP 2. CTP is a customer technology preview, that lets us explore new features of the product before it’s released to marketing (RTM). I found it in my MSDN new downloads. Not ready to download and install it but still want to learn? Technet Virtual Labs already has SIX virtual […]
Author: dave
Get your Public IP and Geographic Data with PowerShell
Always fascinated by what can be done very tersely with PowerShell. I saw an interesting tip on PowerShell.com that gives the geopraphic info on a given public IP. They had a post I dug up a couple years back that determines your public IP dynamically, so I connected the Lego blocks… here is a […]
Scripting COMPLETE Full-Text indexes after a database restore
You may find yourself working with SQL 2000 databases, or later versions of SQL that were migrated from SQL 2000, with the Full-Text indexes stored outside the SQL data files. In this scenario, once you restore a SQL Server database, your full-text catalogs and the full-text indexes within are not restored along with your data. […]
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 […]
Don’t Fear the Shell! Presentation on PowerShell Basics to FlaDotNet User Group
Tonight I presented a hands on introduction to PowerShell for the great folks at the FlaDotNet user group. I skipped the slides and dove into PowerShell from the console and the PowerShell ISE. PowerShell scripts and referenced resources are available. UPDATE: Dave Lord documented the event with photos! Thanks Dave!
Helping out at TechEd 2014 in Houston
I am privileged to be a member of the fifty or so Microsoft Certified Trainers who are volunteering their time this week with the Hands On Labs here at TechEd 2014 in Houston. There are 300 general use machines plus 400 machines dedicated to Instructor Led Labs. Look at my computer lab! 🙂 There are […]
Bi-Annual blog post
Yes, six months just went by. Since I’ve last posted: My youngest is walking, and also talking (in his own language, English will come soon I’m sure.) I’ve assisted a small handful of clients and their customers with their database, application and infrastructure needs. Taught SQL querying and administration classes onsite around Florida. Delivered a […]
Back to Work, and ain’t it Great?
Aaaaaaaaaaaaaaaaand a month goes by. 🙂 PASS Summit 2013 was a great experience, made several contacts, a few friends, and learned a lot about SQL, and lot more about this I.T. industry we are in. It’s a big place, and the rules are continually changing. It was a pleasure to volunteer as an MCT Ambassador […]
Off to SQLPASS 2013!
This year I’m volunteering at SQL PASS Summit 2013 as an MCT Volunteer, to assist those interested in certifying for SQL Server 2012. Being an MCT means keeping up with certifications, which means keeping up with tests, and since 2002 I’ve certified on SQL 2000,2005 and 2008. This May I achieved my MCSE: Data Platform this […]
Presenting on SQL 2014 New Features
Life has been so busy, haven’t kept up with the blog. Have been researching SQL 2014 new features for CTP1, lots of great material out there. Presenting today at New Horizons in Fort Lauderdale