My first book review! SQL Server 2014 with PowerShell v5 Cookbook

Current Events, PowerShell, SQL
Has been a very busy year for me, haven't posted lately, but was very excited to share this. I've had the opportunity to be a technical reviewer for three PowerShell books this year! One that I've really enjoyed reviewing has just been released, and the publisher Packt is offering an end of year sale for $5 eBook editions. Donabel Santos (sqlbelle.com & @sqlbelle) is a wonderful blogger, author, trainer, and Microsoft MVP. This is her second PowerShell cookbook for SQL, and it's an incredibly useful resource for learning the practical details of PowerShell, both in general and when working with SQL Server. All her examples come with code samples so you can leverage her scripts to get productive right away. You can check out the book on the Packt website. It's only $5 for a great PowerShell & SQL…
Read More

SQL 2016 CTP2 is out, with Technet Virtual Labs ready to learn!

SQL
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 labs you can use to explore the new features! [caption id="attachment_493" align="alignleft" width="1000"] SQL Server 2016 Virtual Labs![/caption] Just search for SQL 2016  
Read More

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