Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on Sunday 29 Oct, whilst the USA remains on Daylight Savings until mid November. The start time for this meeting is equivalent to 19:00 (7PM) in Central Europe and (for this month only) 11AM in Seattle / PST Due to the clock changes, please carefully check World Time Buddy this month for all local times This session will be led by John Heaser who is an experienced Access developer based in the U.K. Topic outline: SQL Server has a Geography data type that can represent points, lines and polygons on the Earth’s surface. This data can be used to: • Find which polygons contain a point: e.g. find the Local Government Region for a location where you know the Latitude/Longitude (Lat/Long can be found from the PostCode) • Find the points that lie within a radius of a starting point and order them by distance: e.g. find the Stores that lie within 50 miles of a customer and show them in ascending order of distance This can be very useful for many purposes and SQL Server calculates the results very fast - provided that suitable Spatial Indexes are defined. Unfortunately Access can’t work directly with Geography data types! However, you can make use of Geography data in Access by using: • Persisted Computed Columns • Scalar Functions • Stored Procedures • Triggers We will look at how these SQL skills can be used to bring the benefits of Geography data types to Access. The same skills can also be used to leverage the power of SQL Server to do other tasks that would be slow to perform or difficult to code, if done directly in Access. For more details about this month's presenter and session content, see: https://accessusergroups.org/europe/event/access-europe-2023-11-01/ or https://isladogs.co.uk/aeu-21/ The meeting will again be held on Zoom. When the time comes, you can connect using: Join Zoom Meeting. If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210 For more connection options, please see the AccessUserGroups.org web page for this event As always, the session will be recorded and the video uploaded to YouTube after the eventIntroducing Advanced KQL Free Online Course
Are you analyze data on ADX? User Analytics? Geographic? Machine Learning? Time Series Analysis? Anomaly Detection? You have come to the right place! You are welcome to take our new Advanced KQL course that will boost your knowledge and skills for performing advanced analytics in ADX
Free edition of Microsoft Teams and geographic data location
Good morning, good afternoon, good evening, In the free version of Microsoft Teams, where geographically is the data stored? I can find is reference to using it with an Office 365 subscription and its own geo-location setting (https://docs.microsoft.com/en-us/microsoftteams/location-of-data-in-teams). However as the free versions of Teams is from what I can gather not linked to Office 365, I wonder how users can specify the data-sovereignty of the content stored? Thanks in advance, and best wishes to you and your families.
