by Scott Muniz | Sep 10, 2020 | Uncategorized
This article is contributed. See the original author and article here.
The 22nd cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.
To learn more about the release or servicing model, please visit:
• CU22 KB Article: https://support.microsoft.com/en-us/help/4577467
Starting with SQL Server 2017, we adopted a new modern servicing model. Please refer to our blog for more details on Modern Servicing Model for SQL Server
• Microsoft® SQL Server® 2017 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=56128
• Update Center for Microsoft SQL Server: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server
by Scott Muniz | Sep 10, 2020 | Uncategorized
This article is contributed. See the original author and article here.
Today, I worked on a service request that our customer needs to know how to run a bulk insert for reading CSV file using Managed Identity credential. Following I would like to share with you how I configure this.
We have to configure two elements: Azure SQL Database and Storage Account.
Storage Account:
- First of all, we need to have a blob storage of general-purpose v2 type.
- Using PowerShell, you need to register your Azure SQL server with Azure Active Directory, running the following commands:
Connect-AzAccount
Select-AzSubscription -SubscriptionId <subscriptionId>
Set-AzSqlServer -ResourceGroupName your-database-server-resourceGroup -ServerName your-SQL-servername -AssignIdentity
- Under your storage account, navigate to Access Control (IAM), and select Add role assignment. Assign Storage Blob Data Contributor Azure role to the server hosting your Azure SQL Database which you’ve registered with Azure Active Directory (AAD) previously.
Azure SQL Database:
- Open SQL Server Management Studio and connect to the database.
- Open a new query and run the following commands.
- Create the database credential:
CREATE DATABASE SCOPED CREDENTIAL MyCredential WITH IDENTITY = 'Managed Identity'
CREATE EXTERNAL DATA SOURCE [MyDataSource]
WITH (
TYPE = BLOB_STORAGE, LOCATION = 'https://storageaccountname.blob.core.windows.net/backup', CREDENTIAL = MyCredential
);
CREATE TABLE [dbo].[MyDummyTable] (ID INT)
BULK INSERT [dbo].[MyDummyTable]
FROM 'info.txt'
WITH (DATA_SOURCE = 'MyDataSource'
, FIELDTERMINATOR = 't')
It is possible that running bulk insert command you could get an Access denied issue, I saw that after adding the Identity and the RBAC of the storage account these operations take some minutos to be effective.
Enjoy!
by Scott Muniz | Sep 10, 2020 | Azure, Technology, Uncategorized
This article is contributed. See the original author and article here.
Azure Stream Analytics service makes it easy to ingest, process, and analyze streaming data from an events source (Event Hub/IoT Hub/Blob Storage), enabling powerful insights to drive real-time actions. But before you publish your Stream Analytics query to cloud to run 24×7, do you know you can test your query 3 different ways?
Benefits of testing the query
Here are the key benefits of testing your query:
- Development productivity: Fast iteration to test and fix the query in a single box environment
- Test before deploying: You can test the query logic with live data or local data without deploying to the cloud
- Query behavior consistency: For live input, the queries will output the same results
- Fast results: You can view query results in < 4seconds
- Free: Test your query for free
Here are 3 ways you can test your query
| |
1. Azure Portal |
2. VS Code |
3. Visual Studio |
| Platform type |
Web client |
Editor |
IDE |
| Query execution |
Test runs in the cloud without charge |
Test runs on your machine
|
Test runs on your machine
|
|
Test scenario 1
Local data (JSON/CSV)
- You can test your Stream Analytics query by using a local file.
|
Yes |
Yes |
Yes |
|
Test scenario 2
Sample data
- You can test your Stream Analytics query against snapshot/sample of live stream input.
|
Yes
(Event Hub, IoT Hub, Blob Storage)
SQL reference data supported
|
No |
No |
|
Test scenario 3
Live data
- You can test your Stream Analytics query against live stream input.
|
No |
Yes
(Event Hub, IoT Hub, Blob Storage)
Blob/SQL reference data supported
|
Yes
(Event Hub, IoT Hub, Blob Storage)
Blob/SQL reference data supported
|
|
Job diagram availability while testing the query
|
No |
Yes
You can view the data & metrics of each query step in each intermediate result set to find the source of an issue.
|
Yes
You can view the data & metrics of each query step in each intermediate result set to find the source of an issue.
|
| Documentation |
Local data
Sample data
Job diagram |
Local data
Live data
Job diagram
|
Local data
Live data
Job diagram
|
|
Limitations
|
No support for Event ordering in testing.
C# UDFs and deserializers not supported.
Local input size <2 MB for testing.
Queries with <1 min execution time are supported for testing. |
Support for Event ordering.
C# UDFs and deserializers support expected by end of year.
|
Support for Event ordering
C# UDFs and deserializers are supported.
|
1. Azure Portal
Test your query in Azure portal by using a local file or sample of live data
2. VS Code
Test your query in VS Code by using a local file or live data
Use Job Diagram to see intermediate results
3. Visual Studio
Test your query in VS Code by using a local file or live data
Query testing should only be used for functional testing purposes. It does not replace the performance and scalability tests you would perform in the cloud. This testing feature should not be used for production purposes since running in a local environment doesn’t guarantee any service SLA.
Feedback and engagement
Engage with us and get early glimpses of new features by following us on Twitter at @AzureStreaming.
The Azure Stream Analytics team is highly committed to listening to your feedback and letting the user’s voice influence our future investments. We welcome you to join the conversation and make your voice heard via our UserVoice page
by Scott Muniz | Sep 10, 2020 | Uncategorized
This article is contributed. See the original author and article here.
Excited for the FIRST ever virtual Microsoft Ignite? The Humans of IT Community will be bringing a compilation of stories where humanity and technology intersect all in one track so that you can discover how to empower your community, build meaningful careers, be more productive and achieve more!
We know this is the post you’ve been waiting for.
As many of you have probably guessed, Humans of IT will be back at Microsoft Ignite 2020! Join us during our 8 Humans of IT sessions at Microsoft Ignite 2020! P.S – If you haven’t already heard, Microsoft Ignite is free to attend this year, so what are you waiting for? Register today!
8 Sessions You Don’t Want to Miss at Microsoft Ignite 2020
Tuesday 9/22 11:30AM PST: Leveraging Tech for Good: Empowering Nonprofits in a Global Pandemic
Speakers: Dux Raymond Sy, Shing Yu, Mario H Trentim, Foyin Olajide-Bello
Come hear from our panel about the vital role technology plays in helping nonprofits digitize and develop strong business continuity processes in the new normal. In this session, you will also discover how you can play your part in supporting the broader community and contributing your tech skills for good.
Tuesday 9/22 3:15PM PST: How to be a Social Technologist in a Virtual World
Speakers: Grace Macjones, Scott Hanselman
What does it take to be a social technologist in this new normal? Are you visible online, and an even better question – should you be? How do you show up on virtual Teams meetings or events? We cover GitHub, Twitter, LinkedIn, StackOverflow, Blogging, Podcasting etc and share tips on setting up your own webcam and home AV equipment (Spoiler alert: It doesn’t have to be fancy!) as we aim to understand what a well-rounded technologist looks like today’s virtual world. We also cover staying safe (and sane!) online, being both appropriately private and public, and how to be authentic while not giving away too many personal things.
Tuesday 9/22 1:45PM PST: Sustaining Human Connection in a Virtual World with Technology
Speakers: Megan Lawrence, Michael Bohan, Allexa Laycock, Leah Katz-Hernandez
Come learn about how Microsoft uses human-centered research to build technology that strives to match the natural ways in which our brains work and helps minimizes strain so we can stay productive as we adjust to the new world of remote work.
Wednesday 9/23 7:15AM PST: You + Power Platform: Be the Hero Of Your Own Story
Speakers: Jeremiah Marble, Gomolemo Mohapi, Ashlee Culmsee, Joe Camp, Mary Thompson
Have you ever felt like you’re a supporting or background character in this whole production known as work and life? Well, let’s end that nonsense TODAY and have you emerge as the hero of your own story. Come and hear from these 4 amazing humans who decided to be the active hero of their own stories…using the Power Platform as the sword as they marched into the modern battle. You’ll walk away from this session, 100% inspired with real, practical steps on how you, too, can #DoTheThing.
Wednesday 9/23 11:30AM PST: The Intersection of AI and Humanity: Solving World Challenges through AI Innovation
Speakers: Siddharta Chatuverdi, Alice Piterova, Kelvin Summoogum
The world we live in is constantly evolving, and humanity as a whole is now grappling with increasingly complex and challenging issues. Yet, innovative solutions can be found in the most surprising places. Join us in this session to hear from a panel of innovators at the forefront of technology, and be inspired by their stories of how they successfully combine their imagination and creativity with the power of AI to help solve health, societal and humanitarian challenges.
Wednesday 9/23 1:00 PM: Choose Your Adventure: How to Hack Your Tech Career and Carve The Path YOU Want
Speakers: Iasia Brown, Ryen Macababbad, Chloé Brown, Karen Alarcon
Want to learn how to manage up (“manage your manager”)? Looking to overcome the notorious Imposter Syndrome that continues to be a challenge for many of us in tech? While we cannot solve all the world’s problems, we can come together as #HumansofIT and share tips on how to hack your tech careers and discover tools you can use to keep calm and thrive in the new normal.
Wednesday 9/23 2:30PM: Want to start a startup? Passing on the collective experience of 50 founders in just 30mins
Speakers: Annie Parker, Lahini Arunachalam, Kai Frazier, Mikaela Jade
Would you like to learn from the collective advice of 50 badass women and other under-represented founders from around the world who have recently started companies and what they learnt along the way so you can learn from their successes and failures? Join Microsoft for Startups Execs Annie Parker and Lahini Arunachalam in this session as they walk through the findings from some recent customer research they have from speaking with some of the most amazing founders and they will be bringing some special guests to share their inspiring stories with us too.
Wednesday 9/23 7:30 PM: Mentoring Future Technologists in Tech: Students Get Real
Speakers: Tammy Richardson, Errol Blaize Jr, Kaylynn Armstrong, Trent Dalcourt, Lauren Gray, Desha Wise
Join us in this session to hear from our Microsoft Ignite Humans of IT Student Ambassadors from five Historically Black Colleges and Universities (HBCUs) to hear about how they discovered their passion in technology, their personal development journey and their goals to transform the future of tech. Gain insights on what students from underrepresented communities are looking for in their future tech employers, and how tech professionals like you can help support their growth.
Human-focused Microsoft Ignite Table Talks
Looking for ways to interact and connect with your peers? Be sure to check out the community table talks! Share insights with other attendees in an on-going live chat. Then, tune in to hear community leads highlight what’s been discussed! Our top picks of the lot are:
See you at Microsoft Ignite 2020, #HumansofIT- Register online to secure your virtual seat today!
#HumansofIT
#MSIgnite
#CommunityRocks
#ConnectionZone
by Scott Muniz | Sep 10, 2020 | Uncategorized
This article is contributed. See the original author and article here.
Microsoft Ignite 2020 is quickly approaching. The world has changed a lot since the new Yammer was announced last November and this year’s event will be entirely digital, making it available to attendees instantly around the globe.
The new Yammer is now generally available, which means we’ve got a lot to share about what’s new and how you can use Yammer to drive community and employee experience.
To get started, check out our latest video.
You can find the entire Ignite session catalog at https://myignite.microsoft.com on September 22nd, but here is a list of our dedicated sessions if you’re looking to learn more about Yammer and employee engagement.
Hero
Enabling collaboration, communication, and knowledge sharing with Microsoft Teams, SharePoint, Project Cortex, and more (Repeats 3x)
Organizations are moving to a hybrid workplace to support the needs of remote and onsite employees. In the 2nd part of a 2-part series, we look at how teams can collaborate fluidly with the latest innovations across Microsoft Teams, SharePoint, and OneDrive. We also look at how organizations can improve employee engagement, communications, and knowledge sharing through SharePoint, Yammer, and Project Cortex.
Employee Engagement and Communities in Microsoft 365 (Repeats 3x)
Learn how Microsoft 365 powers employee engagement using Yammer, Microsoft Teams, SharePoint, and Stream to empower leaders to connect with their organizations, align people to common goals, and to drive cultural transformation. Dive into the latest innovations including live events, new Yammer experiences and integrations, and the intelligent intranet and see how it all comes together.
Roadmap
Engage employees with the new Yammer: Communities, Communications, Knowledge Sharing – Session 1101
The new Yammer is here. See how Yammer has been completely redesigned to power leadership engagement, company-wide communication, and knowledge sharing. This session will cover what’s new and what’s next for Yammer.
Skilling
Supercharging communications and employee engagement with Microsoft 365 – Session 1045
This session provides both the strategy and tools needed to drive communications in your company. Learn how to keep everyone informed and engaged using SharePoint, Yammer, Microsoft Teams, and live events.
Driving open sharing and knowledge in communities – Session 1069
Capture, shape, and share knowledge across your organization using communities and your intranet. See how Yammer creates more resilient, intelligent organizations that drive innovation, responsiveness, and engagement at every level.
Yammer Governance in a Microsoft 365 World – Session 1100
Your one stop session for administering your Yammer network and managing compliance, including a double-click into the latest Yammer data governance features like eDiscovery, local data residency, and Native Mode.
Engaging employees with Yammer and Microsoft 365 – Session 1043
Similar to the Digital Breakout, see how Yammer, SharePoint, Stream, and Teams work together to deliver a modern workplace solution to engage employees and accelerate cultural transformation across organizational silos, geographic boundaries, and remote workstyles.
Optimize your new Yammer Communities – Session 1102
A lot has changed in the new Yammer. In this one-stop shop for community management, you’ll learn what’s new and what’s possible for Yammer community admins. Including:
- the latest features
- managing communications and campaigns
- branding a community
- hosting live events
- community moderation
- and more!
There will also be three (3x) Ask the Experts opportunities running in different timezones to ensure everyone has a chance to connect with our engineering and marketing teams for Q&A. Add them to your session calendar:
Wednesday, September 23 — 1:00pm-1:30pm PT
Wednesday, September 23 — 9:00pm-9:30pm PT
Thursday, September 24 — 5:00am-5:30am PT
Stay tuned! There will be more ways to connect and consume content at Microsoft Ignite 2020 and Yammer will appear in a number of other Microsoft 365 sessions as well. In the meantime, be sure to watch our blog for the latest updates and follow us on Twitter for more news, timing, and discussions.
Michael Holste is a Senior Product Marketing Manager for Yammer and Employee Engagement in Microsoft 365.
Recent Comments