SQL Tact

pointers, solutions and scripts for the SQL DBA
not intended to replace common sense


Live Microsoft Event - Power BI Dashboard in a Day - Baton Rouge

Join BRSSUG Founder and Microsoft TSP Patrick Leblanc to learn how to use Microsoft’s self-service Business Intelligence platform, Power BI. In the first part of the session, the instructor will lead you through a Microsoft dataset and demo teaching you the basic elements of Power BI.

Each attendee should bring his or her laptop with a copy of Microsoft Office 365 Pro Plus or Professional Plus 2013 installed, specifically Excel.  In addition, each person should ensure that Power Query has been installed on their machine.  Power Query can be downloaded from this link: http://www.microsoft.com/en-us/download/details.aspx?id=39379

As part of this course, students will be creating:
·         Data Mash-ups: Discover and Combine Data using Power Query
·         Create Data Models using Power Pivot
·         Share Data: Learn how to add your data to the catalog for others to use
·         Explore, Visualize Data using Power View

12:00 PM – Arrivals & Networking
12:30 PM– Introductions and Overview
1:00 PM - Power BI Lab Walk through
2:30 PM - Break
4:15 PM – Wrap-up & Close
Space at these exclusive events is limited, so please reserve your spot today.

Registration Required!

Starts: Tuesday, April 14, 2015 12:00 PM
Ends: Tuesday, April 14, 2015 4:30 PM
Time zone: (GMT-06:00) Central Time (US & Canada)
Welcome Time: 11:30 AM
Location: Sparkhound Corporate Office
Suite 600 (6th floor, look for signs)
2900 Westfork Drive
Baton Rouge Louisiana 70827

Registration Page Link Here


Announcing: SQL Saturday Baton Rouge 2015

SQL Saturday Baton Rouge 2015 is coming up on August 2 at LSU, register today!

Email or instant message your friends, post it on your blog, tweet it on Twitter with hashtag #SQLSatBR - free training is coming soon for those interested in SQL Server, .NET development, SharePoint, Windows Server, PowerShell and more!

Who Attends SQL Saturday Baton Rouge?
Folks with the following skillsets are drawn to SQL Saturday Baton Rouge because of the professional networking, free training, and giveaways:

  • SQL Server Administrators
  • Business Intelligence Developers
  • Data Analysts
  • ETL Developers
  • C#/VB.NET Developers
  • Mobile Developers
  • Windows Server Admins
  • SharePoint Architects
  • SharePoint Developers
  • Network Administrators
  • Quality Assurance Analysts
  • IT Managers
  • Project Managers
  • Students
After our 600+ person 2014 event, we received some great feedback and testimonials, like these actual responses:

  • “Some very good talks with great content, large community of very smart, talented developers, great networking, and awesome SWAG/goodies”
  • “Great networking opportunity, good way to get to know the community. Some talks were really excellent presentations on state of the art database techniques.”
  • "Lots of companies with great networking opportunities; lots of free training and free stuff. High quality and free is very unique.”
  • “It was a fun way to network and learn about how everyone is using technology that we can bring back to our own organizations. It is a chance to learn something new, and meet new people.”
  • “My first sql saturday and certainly not my last. Had a very nice time.”

Check out the results of our last, most important question on a post-event survey:

See you there!

Team SQL Saturday Baton Rouge
Register today!


Quickly Add Telnet

Have you found yourself on a server or workstation that doesn't have telnet (typical in new builds and new Azure VM's from the gallery), and need it to test port connectivity? Did you receive this error when you tried to execute telnet in cmdshell or powershell?

telnet : The term 'telnet' is not recognized as the name of a cmdlet, function, script file, or operable program.
Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1

Three quick ways to add the Telnet Client to the server you're on right now that are much faster alternatives than adding telnet via the Windows features section of the Control Panel. Note that you must launch PowerShell or Command Prompt as an administrator to run these commands, so non-administrators will need to track down a helpful sysadmin first.

Install telnet via DISM (via cmd/PowerShell):

This option should complete the installation of Telnet in seconds. You may receive an error if a reboot is pending because of another installation.

dism /online /Enable-Feature /FeatureName:TelnetClient
Install telnet via pkgmgr (via cmd/PowerShell):

This option should also complete the installation of Telnet in seconds. PkgMgr was deprecated along with a few other tools when replaced by DISM for Windows 7. PkgMgr still works on later operating systems, including Windows 8.1 and Windows Server 2012 R2.

pkgmgr /iu:"TelnetClient"

Install telnet via Install-WindowsFeature (via PowerShell):

This method is just as fast but unfortunately doesn't work for desktop installations (client-based operating systems) like Windows 7 or 8.1. Neither does the cmdlet it replaced, the deprecated Add-WindowsFeature. For desktop operating systems, go with the first option above.
Import-Module servermanager

Install-WindowsFeature telnet-client