July 2018 Meeting Notes

Topic

Topic: Introduction to SQL Server Reporting Services 2017

Related Links:

• Visual Studio
  • SQL Server Data Tools: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
  • Extension: https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio
• Report Builder: https://docs.microsoft.com/en-us/sql/reporting-services/report-builder/report-builder-in-sql-server-2016
• Mobile Report Publisher: https://docs.microsoft.com/en-us/sql/reporting-services/mobile-reports/create-mobile-reports-with-sql-server-mobile-report-publisher
• Theming: https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/03/20/how-to-create-a-custom-brand-package-for-reporting-services-with-sql-server-2016/
• Data Driven Subscriptions: https://docs.microsoft.com/en-us/sql/reporting-services/create-a-data-driven-subscription-ssrs-tutorial

News and Recommended Reading

• SQL Saturday 2018 Baton Rouge (Aug 11th): http://www.sqlsaturday.com/749/
• The Imposter’s Handbook by Rob Conery: https://bigmachine.io/products/the-imposters-handbook/

SQL Saturday Baton Rouge 2018

SQL Saturday Baton Rouge 2018 is open for registration! The event will be held on  August 11, 2018. Please visit the website and sign up if you’re interested.

If you’re interested in development at all this is a must attend event. The sessions span all areas of development. As the site says:

For the 10th year, SQLSaturday Baton Rouge is coming to LSU!

SQLSaturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day of technical training. The Baton Rouge SQLSaturday event is sponsored by the Baton Rouge SQL Server and .NET User Groups, and will be our annual event on campus at LSU. We expect 600+ regional IT professionals and national speakers to join us. This free conference is open to the public and is perfect for students, CIO’s, database administrators, developers, IT managers, server admins and job-seekers.

2017 Year End Link Round Up

Here’s your 2017 link round up for recommended reading. This should cover Nov and Dec.

• The Heisenberg Developer
  • https://visualstudiomagazine.com/articles/2017/09/01/the-heisenberg-developer.aspx
• Encryption Strategy
  • https://visualstudiomagazine.com/articles/2017/09/01/an-encryption-strategy.aspx
• Razor Pages
  • https://github.com/VenusInterns/BlogTemplate
  • https://msdn.microsoft.com/en-us/magazine/mt842512
  • https://docs.microsoft.com/en-us/aspnet/core/mvc/razor-pages/?tabs=visual-studio
  • https://developer.telerik.com/content-types/podcast/aspnet-core-razor-pages-worth-checking/
• .NET Core vs .NET Framework: How to Pick a .NET Runtime for an Application
  • https://stackify.com/net-core-vs-net-framework/
• Developer Extensions, Plugins, etc.
  • http://vsrefactoringessentials.com/
  • https://github.com/kspearrin/Visual-Studio-jQuery-Code-Snippets
  • https://oz-code.com/
  • https://stackify.com/prefix/
  • http://www.codemaid.net/
  • https://www.hanselman.com/blog/WebOptimizerABundlerAndMinifierForASPNETCore.aspx
• Building Inclusive Toggle Buttons
  • https://www.smashingmagazine.com/2017/09/building-inclusive-toggle-buttons/
• QuickType
  • https://quicktype.io/
• New Tools and Extensions for VS2017
  • https://visualstudiomagazine.com/articles/2017/09/01/22-new-tools.aspx
  • https://marketplace.visualstudio.com/items?itemName=DanielGriffen.WhackWhackTerminal
  • https://marketplace.visualstudio.com/items?itemName=vs-publisher-599079.FixNamespace
• .NET Portability Analyzer
  • https://github.com/Microsoft/dotnet-apiport/blob/master/docs/VSExtension/README.md
• Extracting Data with Regular Expressions
  • https://visualstudiomagazine.com/articles/2017/09/01/extracting-data.aspx
• SQL Application Lock
  • http://www.sqlteam.com/article/application-locks-or-mutexes-in-sql-server-2005
  • https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-getapplock-transact-sql
  • https://www.mssqltips.com/sqlservertip/3202/prevent-multiple-users-from-running-the-same-sql-server-stored-procedure-at-the-same-time/
• Quick Wins For Improving Performance And Security Of Your Website
  • https://www.smashingmagazine.com/2017/10/improving-performance-security/
• Code Analysis, Profiling and Refactoring Tools for VS 2017
  • https://visualstudiomagazine.com/articles/2017/10/01/code-analysis.aspx
• Modernize existing .NET apps with Windows Containers and Azure
  • https://blogs.msdn.microsoft.com/dotnet/2017/11/01/modernize-existing-net-apps-with-windows-containers-and-azure/
• Introducing API Analyzer
  • https://blogs.msdn.microsoft.com/dotnet/2017/10/31/introducing-api-analyzer/
  • https://www.hanselman.com/blog/WritingSmarterCrossplatformNETCoreAppsWithTheAPIAnalyzerAndWindowsCompatibilityPack.aspx
• Connect Event
  • https://www.microsoft.com/en-us/connectevent/
• Dependency Injection w/ Miguel Castro
  • https://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Dependency-Injection
• Free Azure Account
  • https://azure.microsoft.com/en-us/free/
  • https://azure.microsoft.com/en-us/free/free-account-faq/
• Understanding CSS Layout and the Block Formatting Context
  • https://www.smashingmagazine.com/2017/12/understanding-css-layout-block-formatting-context/