Blog

Get your Public IP and Geographic Data with PowerShell

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 script that determines your public IP and tells you where you are, using a web page and a REST API. [codesyntax lang="powershell"] #Determine Public IP Dynamically $ipaddress = (Invoke-WebRequest 'http://myip.dnsomatic.com' -UseBasicParsing).Content $infoService = "http://freegeoip.net/xml/$ipaddress" #Get Geographic Data based on my IP $geoip = Invoke-RestMethod -Method Get -URI $infoService $geoip.Response #As a One-Liner (Invoke-RestMethod -Method Get -URI "http://freegeoip.net/xml/$(Invoke-WebRequest 'http://myip.dnsomatic.com' -UseBasicParsing)").Response [/codesyntax]  
Read More

Scripting COMPLETE Full-Text indexes after a database restore

SQL
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. Note that this is not required for Full-Text indexes created in SQL 2005 and later, when the storage for Full-Text Catalogs was changed. Right-Clicking and choosing to script the full-text catalog will NOT create the indexes within the catalog. I found a useful script at humakhurshid.blog.com that scripts out the full-text catalog AND indexes. EDIT: However it misses some indexes, I found a better script at the bottom of the comment thread at this blog…
Read More

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

Helping out at TechEd 2014 in Houston

Current Events
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! :) [caption id="attachment_366" align="alignnone" width="604"] Hands On Labs area at TechEd 2014 (click to enlarge)[/caption] There are over 150 different labs available at the conference, all created and hosted by HynesITe. They do this with over 70 host servers, many with half a TERABYTE of RAM, all from a single colocation facility in Tampa, Florida. The labs are made up of one to several  virtual machines that are spun up and ready for the attendees when they sit down to…
Read More

Bi-Annual blog post

Current Events
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 custom PowerShell Module and PowerGUI interface to a client for testing. Next week will deliver a 5 day class on using SQL 2012 SSIS to populate a data warehouse. Then I'm off to Houston to learn and to volunteer along with the other MCTs there to help deliver hands on labs to thousands of TechEd attendees. Talk to you again in six months (or less, hopefully.)
Read More

Back to Work, and ain’t it Great?

Current Events
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 with the other MCTs and the Microsoft folks, helping people prepare for and take their certification exams. I was lucky to witness several very smart (and nervous) people taking the MCM SQL Exams before the program is retired at the end of the year. Talking to 'potential masters' during their breaks was inspiring. One takeaway from the conference for me was the appreciation for the community, and the desire to learn how to give back.…
Read More

Off to SQLPASS 2013!

Learning, SQL, Uncategorized
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 year, and working toward MCSE: Business Intelligence certification as well, with just one more test to go! If you're nervous about taking a Microsoft exam, just know you can do it, like thousands of other have. If you want help preparing to take a SQL Server exam, can you imagine a better place than the PASS Summit with thousands of smart SQL people there to help? Check out the PASS info page on MCP certification…
Read More