SQL Server Security Principals Lightning Round Presentation

Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!

I presented a lightning round to the combined user groups on SQL Server Security Principals, which was a shortened version of a presentation I've given several times in the past. For this one though, I added some extra content about SQL Server Agent security and job permissions, which is a troublesome topic for some developers.

Hope you enjoyed my presentation!

Here's the slidedeck, with complete info and more links inside:
http://1drv.ms/1O4U51O

More information about these great Baton Rouge user groups: .NET | SQL | Power BI

Easy Installing .NET 3.5 for SQL Admins

Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.

This is a common problem and relatively easy fix for SQL admins installing a new SQL Server instance going back a few years, so it's about time to put all my notes about the solution into a single place. You'll get this error early on in the install:

"This computer does not have the Microsoft .NET Framework Service Pack 1 installed..." Similar error messages pop up going all the way back to SQL 2008 R2.

Before you go any further, click OK here but it is not necessary to abort SQL Server setup. Leave the "Feature Roles" page open, you'll be hitting "re-run" later.

This support article goes through the various solutions, some more painful than others.

Here's the fastest:

1. Extract the "...sources\sxs" subfolder from your Windows Server installation media .iso.
2. Run the below PowerShell, pointing at your extracted \sxs subfolder in the /Source syntax.

Dism /online /enable-feature /featurename:NetFx3 /All /Source:D:\sources\sxs /LimitAccess

3. Done.

For example:

Caveat- keep in mind that after installing .NET 3.5, you may now be eligible for additional Windows Updates/hotfixes that weren't there before.

When complete, back on the SQL Server Setup window, hit "re-run" in the "Feature Rules" window and move on with your pleasant SQL Server installation experience.

Then thank whoever should be thanked that you're not installing Oracle today.

Footnote:

Irrationally uncomfortable or afraid of PowerShell? Yes, you can use the "Add Roles and Features" feature of Windows to add this, via the ".NET Framework 3.5 Features" Feature. You'll still need to do step one above to extract the "...sources\sxs" subfolder, only instead provide it in the Alternative sources dialogue box like the below example.

Announcing the Baton Rouge Power BI User Group

Baton Rouge is home to one of the inaugural Power BI User Groups, starting up soon! I'll be serving as its initial organizer, but I've already received a lot of feedback from the community and hope to form a new leadership team for the group soon.

Power BI is quickly becoming the hub for all things SQL Business Intelligence related, and will soon have both cloud-based and on-premise options. This exciting technology will continue to expand as SQL 2016 is announced. 

Stay tuned for more information on the official website and first meeting of the Power BI user group, which will be in either December or January. We already know that Baton Rouge native and current Microsoft employee Patrick Leblanc, founder of the Baton Rouge SQL Server User Group, will be our virtual speaker in January.

Get involved with Power BI today at the Power BI Community site, and our page here: http://community.powerbi.com/t5/Baton-Rouge-Power-BI-User-Group/gp-p/BRPUG