Archive for August, 2017

If you missed a webinar, want to replay your favorites, or wish to share this training with colleagues, now is your chance! The webinar recordings are ready for viewing, learning, and sharing.
View Recordings
This event and session recordings are brought to you by the generous support of our presenting sponsors. View their sessions below:SQL Server on Linux – Don’t be afraid… this is the same SQL Server that you already know and love
Presented by Martin Wild, Systems Consultant, Quest

Introduction to Global Data Quality
Presented by Oscar Li, Product Channel Manager, Melissa
Getting the most from SQL Server – Deploying and Optimizing on Hyperconverged Infrastructure
Presented by Greg White, Solutions Marketing Principal, Enterprise Applications and Big Data, Nutanix

Paul Turley

Can’t We Just Get Along? Making SSRS, Power BI and Excel Play Well Together

Paul Turley

 10024 Hours of PASS (60 minutes)

Ginger Grant

Implementing Advanced Analytics with SQL Server 2017 and Python

Ginger Grant

 10024 Hours of PASS (60 minutes)

Kenneth Urena

Azure SQL VM – Implementing Basic AG in SQL 2016 STD

Kenneth Urena

 10024 Hours of PASS (60 minutes)

Scott Currie

Create and Load a Staging Environment from Scratch in an Hour with Biml

Scott Currie

 10024 Hours of PASS (60 minutes)

Oscar Li

Introduction to Global Data Quality

Oscar Li

 10024 Hours of PASS (60 minutes)

Gail Shaw

On Transactions and Atomic Operations

Gail Shaw

 10024 Hours of PASS (60 minutes)

Ben Miller

PowerShell for DBAs, What’s in it For Me?

Ben Miller

 10024 Hours of PASS (60 minutes)

Allan Hirt

The SQL Server 2017 Availability Story on Linux

Allan Hirt

 10024 Hours of PASS (60 minutes)

So,

I’m not sure how can I explain this better. But I happened to have a bluetooth keyboard linked to my tab which went rogue. I tried to remove the keyboard from bluetooth paired list and add it again. Biggest mistake, it just didn’t connect back. Rather than it’s normal prompt to type the PIN, it told me to enter the PIN. No idea what it was!

After a lot of digging and no solution, I tried to enter 0000. No response!

What worked was to type 0000 and press enter in your tab first and quickly type 000 and enter on the bluetooth keyboard. and VOILA! it connected.

So here are the steps:

Power on keyboard with 5 seconds button on. Keyboard will start with LED .

Go to Device menu and “Add a device”. Select Keyboard.

On the UI keyboard, input “0000” (no enter), and touch “add”.

Then on the physical keyboard, input “0000” + Enter.

It should make start connecting.

The UI changes into connecting view. But it already connected.

You can test with pushing “Windows Key” on the physical keyboard.

After connected, both LED on keyboard was automatically turned off. It is still working normally.

So I hope if you ever face this problem, you stumble on this blog.

Happy typing!

Original posted at:

The site has been down for a couple of days for me so I thought of making a copy of it.

The .NET team released Preview 2 of .NET Core 2.0 as well as a newer build of Visual Studio Preview 15.3 (Preview 3) yesterday:

https://blogs.msdn.microsoft.com/dotnet/2017/06/28/announcing-net-core-2-0-preview-2/

Here are the downloads for .NET Core 2.0 Preview 2:

https://github.com/dotnet/core/blob/master/release-notes/download-archives/2.0.0-preview2-download.md

One of the big changes for .NET Core 2.0 is the addition of more than 20,000 new APIs to the framework.  They are expanding the API list so it’s easier to migrate older apps to .NET Core.   They say 2.0 will support 70% of all existing packages in the Nuget repo.

Selenium with .NET Core

msft&Selenium

Last November (2016), I blogged about how the Selenium team had not yet added support for .NET Core but a community member had forked the code and created a new Nuget package with support.  At this time the Selenium team still hasn’t added official support for .NET Core but they may not need to now.

I’m happy to confirm .NET Core 2.0 Preview 2 can successfully run Selenium tests using the official Selenium Nuget packages with no additional changes or unofficial extensions.  I have not performed extensive testing by any means but basic UI automation with Selenium definitely works now with the latest preview.

Here is a working solution:

https://github.com/rschiefer/SeleniumInDotNetCore2P2

Core 2.0 compatibility

Its great to see a very tangible example of a pre-existing Nuget package that broke with .NET Core 1.0 now working with 2.0.  This goes to show that Microsoft is listening to customers and adjusting their plans accordingly.

I have actually been testing Selenium with each new .NET Core preview that is released and each seemed to get a bit closer to working.  .NET Core 2.0 Preview 1, for example, had an issue with finding the System.Security.Permissions API.  But that was resolved with Preview 2.

Microsoft provides a very cool API search tool which makes it very easy to research what APIs are available in each version of .NET:

image

https://docs.microsoft.com/en-us/dotnet/api/?view=netcore-2.0&term=system.security.permissions

Summary

Microsoft is getting closer to a final release of .NET Core 2.0 (target for this fall last I heard) and making good on their promise to increase backwards compatibility of the framework.  This will make it far easier for developers to port their legacy code to .NET Core and gain all its benefits (cross-plat, speed, modular, flexible deployment, open source).