The Curious Engineer

All blogs / Databases

Sam Lester

learn.microsoft.com/en-us/archive/blogs/samlester

DatabasesAI / MLDev tools / editors / IDEsMicrosoft blogsMSDN archive

’15’20’25
Posts
90 from 2 Aug 2012 to 14 Oct 2018
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/samlester/feed.xml

2018 7

  1. Microsoft Flow – Copy files from SharePoint to a local PC
  2. Power BI Troubleshooting Checklist
  3. Importing a .dbf (dBase) file into Power BI
  4. Understanding the differences between “Power BI Desktop” and “Power BI Desktop Optimized for Power BI Report Server”
  5. Help! I can’t close the Power BI Desktop Splash Screen!
  6. Troubleshooting a Power BI Dataset Refresh Error
  7. Exploring Big Data: Course 10 – Microsoft Professional Capstone: Big Data

2017 27

  1. SQL Server DBA Morning Health Checks
  2. Exploring Big Data: Course 9 – Developing Big Data Solutions with Azure Machine Learning
  3. Exploring Big Data: Course 4 – Querying Data with Transact-SQL
  4. Exploring Big Data: Course 8 – Orchestrating Big Data with Azure Data Factory
  5. Exploring Big Data: Course 2 - Analyzing and Visualizing Data with Power BI
  6. Exploring Big Data: Course 7 – Implementing Real-Time Analytics with Azure HDInsight
  7. Exploring Big Data: Course 6 – Processing Big Data with Azure Data Lake Analytics
  8. Exploring Big Data: Course 5 – Delivering a Data Warehouse in the Cloud
  9. Exploring Big Data: Course 3 – Introduction to NoSQL Data Solutions
  10. Exploring Big Data: Course 1 – Microsoft Professional Orientation: Big Data
  11. My Journey into the Microsoft Professional Program (MPP) in Big Data
  12. Compiling a XAML-based project fails in Visual Studio with FIPS enabled
  13. Power BI Desktop and "The Case of the Missing Taskbar Icon"
  14. Troubleshooting SCCM Database Replication Service (DRS)
  15. Tracking LinkedIn and Twitter social media shares in Power BI
  16. Power BI Desktop – Terms and Definitions
  17. Calculating the difference between two dates in YEARS, MONTHS, and DAYS in Power BI or Excel
  18. Comparing Table Styles in Power BI
  19. Sorting by Month Names in Power BI
  20. Power BI - Using the Treemap Visual with KPI status colors (red, yellow, green)
  21. Excel Add-In not displayed in ribbon due to Group Policy setting
  22. What is the minimum number of AlwaysOn nodes required to obtain both HA and DR?
  23. Creating a New Project in Visual Studio fails when FIPS is enabled
  24. SSRS Report Manager issues when using SSL
  25. Connecting to SSRS through Management Studio throws "Invalid Namespace" Error
  26. SSRS Report Manager Configuration Wizard failed when Applying Connection Rights
  27. Power BI Parameter Error - Invalid URI: The hostname could not be parsed

2016 30

  1. Power BI 12 Days of Dashboards - Day 11 - NFL Football Touchdown Dashboard
  2. Power BI 12 Days of Dashboards - Day 9 - Building your first SCCM Report in Power BI
  3. Power BI 12 Days of Dashboards - Day 8 - Fitbit Dashboard
  4. Power BI 12 Days of Dashboards – Day 7 – Disk Usage Dashboard
  5. Power BI 12 Days of Dashboards – Day 6 – Meetup.com Dashboard
  6. Power BI 12 Days of Dashboards – Day 5 – Amazon.com Order History Dashboard
  7. Power BI 12 Days of Dashboards – Day 3 - Create your own Pinterest Viewer
  8. Power BI 12 Days of Dashboards – Day 2 – LinkedIn Connections
  9. Power BI 12 Days of Dashboards - Day 1 - Goodreads Book Statistics
  10. Enabling Preview Features in Power BI Desktop
  11. Power BI - What Version of Power BI Desktop am I Running?
  12. Power BI “Send a Frown” Makes Me Smile! :)
  13. Power BI Desktop .PBIX file fails to open with error “ZIP archive contains unsupported data structures”
  14. My Experience Completing the Microsoft Professional Program Certificate in Data Science
  15. Power BI Desktop - Installing 32-bit vs. 64-bit Power BI Desktop Application
  16. Power BI - Custom Shape Map fails with non-Latin1 characters
  17. Power BI - Comparing Date Selection Visuals - Slicer vs Timeline
  18. Power BI fails with "Windows Platform FIPS validated cryptographic algorithms" error due to FIPS Algorithm Policy
  19. Installing Power BI Desktop through SCCM
  20. Happy First Birthday to Power BI!
  21. Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!
  22. Power BI - Which data center hosts my data? Where is my data stored?
  23. Power BI - Using Web Page Data Sources and "Publish to Web" to build and embed your personalized dashboard
  24. So long AdventureWorks, we'll miss you! (And hello Wide World Importers!)
  25. Refreshing KPIs in SSRS 2016
  26. Power BI and SSRS 2016 in an On-Premises Environment
  27. Querying SCCM - Finding Manufacturer Counts and Percentages
  28. Discovering SQL Server 2005 Instances by Querying System Center Configuration Manager (SCCM)
  29. Auditing the usage of “EXECUTE AS” in a database
  30. Sorting MSDN Forums threads by number of page views

2015 3

  1. Connecting SQL Server Profiler to Power BI Desktop
  2. Windows Server 2012 / 2012 R2 - Logon restricted to members of Local Administrators group
  3. SQL Server 2014 Service Pack 1 Unattended Setup Error - "The specified value 'Upgrade' is invalid"

2014 2

  1. TechNet Guru Awards - December 2013
  2. TechNet Guru Awards - November 2013

2013 6

  1. TechNet Guru Awards - September 2013
  2. TechNet Guru Awards - August 2013
  3. EOMONTH() Equivalent in SQL Server 2008 R2 and below
  4. TechNet Guru Competition – Show off your SQL Server skills!
  5. SSMA for Oracle - Error: No columns were returned from the database for table 'Foo'
  6. SQL Server 2012 Discovery Report - Determining what SQL Server Components are Installed

2012 15

  1. Bulk Database Migration from On-Premise SQL Server to SQL Azure - Step 1: Bulk .bacpac Export
  2. TSQL - Solve it YOUR Way - Finding a Person's Current Age Based on Birth Date
  3. TSQL - Solve it YOUR Way - Parsing Tips and Tricks - Returning Digits after the Decimal Point
  4. TSQL - Solve it YOUR Way - Finding the Longest Repeated Substring
  5. TSQL - Solve it YOUR Way - Finding the percentage of NULL values for each column in a table
  6. TSQL - Solve it YOUR Way - Finding the MAX Value from Multiple Columns
  7. TSQL - Solve it YOUR Way - Text to Speech
  8. TSQL - Pick Your Path, Choose Your Destiny, Solve it YOUR Way!
  9. Finding the Correct Version of the AdventureWorks SQL Server Sample Database
  10. Creating Complex Test Databases - Using Excel to convert a raw list of text into viable T-SQL syntax
  11. Creating Complex Test Databases - Creating a Table with more than 1,024 Columns
  12. Creating Complex Test Databases - Request for Ideas
  13. Creating Complex Test Databases - Creating a Table with all Supported SQL Server Data Types
  14. Creating Complex Test Databases - Creating a Database with 1 Billion Random Rows
  15. Creating Complex Test Databases - Intro