Visual Studio 2017 was recently released. Here’s an article on Microsoft’s MSDN .NET Blog on what’s new in C# 7.
Recently I had to replace my flat screen TV. I’ve been using Roku’s for many years. I learned that there is a company the sell Roku built in. I was excited and decided that it would be our purchase. I got it at my Costco, plugged it in and have used it for about a month. I can say that now, after a month’s use, the TCL Roku TV is the worst purchase I’ve made in the last 10 years.
Problems From the Start
From the first day that we unpackaged it and started using it, we found that it would just stop working, very frequently. When we stream content we tend to stream Netflix. It is almost never the case that we can watch anything at all on Netflix without it either freezing up or rebooting itself back to the start menu. Once it rebooted itself back to the start menu 8 times watching a 45 minute TV episode!
Problems Extend to More Than Just Streaming
The problems we’re experiencing for this sorry excuse for a Smart TV extends to more than just streaming. We don’t have cable TV or satellite; instead we use a Terk Antenna for over-the-air TV reception. Just watching regular TV, the TCL Roku TV will sometimes just restart back to the start menu! Really? Just watching over-the-air TV causes the TCL Roku TV to restart itself back to the start menu?
The Steps I Took, to No Avail
I have communicated with TCL Technical support, on Twitter, Facebook and via email. They’ve had me return my TCL Roku TV back to factory settings 5 different times! It has never helped at all. I connect the TCL Roku TV to my router wirelessly. I’ve tried connecting it to both the 2.4 GHz and the 5 GHz bands, with no improvement at all.
Summary – This Thing is Going Back
So, bottom line, I’m taking the TCL Roku TV back. It is not worth the money we’ve paid for it. It really isn’t worth any amount you’d pay to get something that doesn’t work so often. So, today I’m taking this back, get my money back and get something else that does work.
I didn’t complete it
In my previous attempt to get my local SQL Server MediaLibrary into Azure, I left it incomplete. I truly didn’t realize that until I tried to connect SQL Server Management Studio (SSMS) to my database in Azure. It connected, but there was no data in any of the tables. My bad.
So let’s get this right. First, I deleted the database in Azure SQL. I don’t know if it is possible to do it any other way, but since it’s a small enough database I thought that would be all right. That and when I tried to upload it straight from SSMS, I got error messages about incompatibility. So in order to resolve this I decided to delete the previous instance from the Azure portal, to start over again. To do this I returned to the MSDN article SQL Server database migration to SQL Database in the cloud.
Starting Over Again
There are three steps you must take in order to migrate your local SQL database into Azure, they are:
- Test for compatibility
- Fix compatibility issues
- Perform the migration
I decided to use SQL Server Data Tools for Visual Studio (SSDT). This is for testing for compatibility. That led me to a link titled Migrate a SQL Server Database to Azure SQL Database using SQL Server Data Tools for Visual Studio.
WOW, in going through this I’ve discovered what step I left out. Its towards the end under “Fixing Compatibility Issues Using SQL Server Data Tools for Visual Studio”. I stopped short of doing step #4 which is updating the local target V12 compatible database and actually publishing the original data to the V12 compatible database.
(Someone, I can’t remember who nor where, asked me for my feedback on where in the Microsoft Azure documentation, did I leave off accidentally. I’m sorry, I can’t remember who you were, but it is here, in this Migrate a SQL Server Database to Azure SQL Database using SQL Server Data Tools for Visual Studio. I think it was because this article, to me, seemed to suggest that if I followed this article, I’d be done. I was mistaken in my interpretation, that is clear. And it was before this point where I stopped previously.)
Step 5 is a link back to Migrate a compatible SQL Server database to SQL Database. So I’m returning to the that article to select a migration method.
Migrating my SQL Server compatible database to Azure SQL
Because of my local video library database is small and I can control activity to it, I’m going to use the SSMS Migration Wizard. Selecting the link to migrate my compatible database I went to a page titled Migrate SQL Server database to SQL Database using Deploy Database to Microsoft Azure Database Wizard.
After getting back in SSMS I right mouse button clicked on the new V12 compatible database I created locally, and selected “Deploy Database to Microsoft Azure SQL Database” option under Tasks. That brought up a wizard to walk me through deploying the database.
At this point I started entering my Azure credentials, this time selecting a different name for the target database in Azure (just in case). I noticed that for the temporary file name the wizard is creating a .bacpac file. Interesting. So one way or other a BACPAC is used to perform the migration.
I’d like to point out that at this step the dialog box that I got for entering my initial credentials, didn’t look like what was in the article. Here’s what mine looked like:
The instructions at step 6 talk about naming the database, setting the edition of Microsoft Azure SQL database, max database size, etc. Because this is an experimental database that I alone will be hitting against (maybe some of my family members will use it later on when I get to the point of writing an app to hit against it – I’ll blog about that as well), I am choosing Basic Edition, 2 GB of database size (that’s the max for basic anyway) and Service Objective of Basic.
Clicking the Next button takes you to a summary. And here I can click on the Finish button which actually performs the migration of the database and data, into Azure SQL.
And here’s what the Deployment Settings window looked like:
Verifying it worked
While still in SSMS I used Object Explorer to connect to my Azure SQL database to just make sure it worked.
It has nice features, but the battery life is very poor.
I got my Microsoft Band 2 in 8 months ago. I like the features that it has, especially after they added the Explorer tile.
However, the battery life on these Band 2 are so poor as to seriously detract from it. My first Band 2 began to need to be recharged in under 24 hours. Then it went even lower. It got so bad that I decided to get a replacement. I’ve been using the replacement for less than 2 months and it is even worse. It now goes dead in under 8 hours. I’m charging it twice a day. Its on the charger more than its on me. This is unacceptable. Reluctantly I have to say that I do not recommend the Band 2.
OK, I’m used to accessing SQL Server databases using SQL Server Management Studio (SSMS). Tonight I found an article on the Azure website describing how to do exactly that. Check out Connect to SQL Database with SQL Server Management Studio and execute a sample T-SQL query.
I’m very pleased to say that I’ve finally gotten my local SQL Server database into Azure SQL!! The MSDN article that really helped was using this one titled SQL Server database migration to SQL Database in the cloud. This article lists various ways in which you can migrate you SQL Server database into Azure. (Note: it also references other types of databases.)
One of these methods was to use SQL Server Data Tools (SSDT), which I’ve got experience at using, so I decided on that one. The link to SSDT led me to a page titled Migrate a SQL Server Database to Azure SQL Database Using SQL Server Data Tools for Visual Studio. I found this to be very helpful!
Following the instructions on that last link I created a project in Visual Studio (using SSDT) to detect SQL Database V12 Incompatibilities. I had some V12 incompatibles (really, no surprise), but again following that last link’s instructions I eliminated the incompatibles.
Next I published my (slightly modified) database schema and data into Azure. At this point I created a new database and published it there. It asked me to create the firewall rules (this is where I specified my IP address). I’ve got it up there and have looked at the data through Visual Studio.
I’ve heard that when working with Azure, especially such as I am, just to learn how to use it, its best to turn off things when you’re not using it. Then turn them back on again, afterwards. I thought I might be able to do that with Azure SQL, but I’ve learned that isn’t an option! Here’s a UserVoice message about it.