I’m in the porcess of migrating and upgrading all previous versions of SQL server instances to 2016 at this stage. I’ve started to read about SQL 2017 and cannot wait to test a few new features out.
Vulnerability Assessment (VA) is a new feature of SQL Server Management Studio (SSMS) 2017 builds. I’ve tried it as the SSMS installation is seperated from the SQL server isntallation. There are plenty documentation of VA on the web, Microsoft Docs has a good artical on it as well.
Download button for Microsoft Docs
Let me sidetrack to Microsoft Docs for 2 seconds here, I found that not everyone knows that there is a dowload PDF button (see below)! It’s a great option for offline reading.
Back to VA, the tool is light and easy to use but its lacking some features such as export the result to PDF or Excel, it would be great if Database Administrators (DBAs) can run this as a schduled task, etc. I’m sure Microsoft is working on them as I publis this post! 🙂
I’m very interested in the Automatic Tunning and Indexing features for SQL 2017. I’ve listed some reading materials for these at the end of the post. These features obviously will make DBAs’ lives easier in the future but how much control are we willing to relinquish to machine learning? System administrators might be a thing of the past soon.
I’m not very sure why Visual Studio 2017 continuously prompts me for login today. I entered the username and login successfully then the prompt never disappears and I could not access my VSTS.
After some Googling, I found a post discussing the issue. In summary:
There is an issue with the update installer which causes some users’ identity cache to become corrupted, which produces very similar behaviour to the other bug. The following has generally fixed this:
- Close all instances of VS
- Open %LOCALAPPDATA% in File Explorer, e.g. c:\users\\AppData\Local
- Delete the .IdentityService folder
- Launch VS. You’ll have to sign in again
After that it should stop prompting you.
It totally worked for me!!! 🙂 🙂 🙂
I’ve had the Twenty Seventeen template by WordPress for too long, its header picture started to annoy me 🙂 … Editor by Array had caught my eye today, mainly because of its typeface and styles (see Style Guide).
The new template almost feels like a new start point. Hopefully, this new template will keep me more focused and motivate me to write more.
Virtualbox is Oracle‘s free Virtual Machine software. It’s fantastic, reliable and FREE! I’ve used it for a few years now and am loving it. I don’t install new virtual machines often but when I do, I struggle with the steps to enable the Virtual Machines to fullscreen mode. I’m writing this down now for future references.
The instuctions in the post assume that the virtual machine has been installed, for example, I would already done these tasks:
- donwloaded and installed the virtualbox software from Oracle
- downloaded and installed Windows 10 from Microsoft
Now, started the virtual machine and check if the virtual machine is shoing a thick black frame around it when in fullscreen mode. It means that the virtual machine is not displaying the same size as the host machine when in fullscreen mode.
What needs to happen now is to download and install the “Oracle VM Virtual Machine Extension Pack”, then attached the Guest Addition (installed by installing the Extension Pack) as a CD image to the virtual machines so it can be installed locally on the virtual machines. Detailed steps are:
Continue reading →
I’m doing some Project Euler problems to brush up my coding skills – see if I still have got it. Just like riding a bicycle years later, I think years of training in the past had not left me yet. Just like cleaning up and oiling the old bicycle, I found myself trying to setup the coding environment again.
It’s been a few years since I’ve used my Azure Virtual Machines (VM) that were setup for coding. Most of the resources were in the classic pools. First thing first, start up the VMs one by one to see if the logins are still working. Do not start them all in case the account notifications go crazy – they are not free! I deleted the VMs that I could not logon and created some with the latest products such as Visual Studio 2017 and Windows 10. I’m impressed with the variety of Azure VM template options – there is the popular WordPress and even Linux operating systems.
The new, compare to the classic, version of the Azure dashboard takes a bit of time to get used to. The dashboard options can be a bit overwhelming to a user who is unfamiliar with the tools. One can always switch to the classic dashboard if unsure.
There are some options that only exist in the classic dashboard, e.g. move subscriptions between Azure Active Directories (AAD). I had one subscription transferred from an old email. I created a new AAD and put all my subscription under it as a way of centralise all accounts and controls for my Azure resources.
The geek in me is feeling the excitement. 🙂
I am giving WordPress.com a try. Why, you ask?
Warning, this is the start of my 2 seconds rant:
I’v been hosting my personal blog with @bluehost for >5 years now so you would understand how disappointed I felt when my blog (and website) started to go up and down all the time! I enquired and was taken on a wild ride with their Service Desk and Technical Support people. I was told to get a developer to look at my site or upgrade to one of the Bluehost’s new 100% super fast plans. I am not running a business so that was out of the question. I picked them years ago because their plans were suitable for personal hosting. I tried to reach out on Twitter too. Until today, the issue is unresolved and like other frustrated customers, I gave up chasing them. I work in the IT industry so I can call BS when I see one. It’s not a nice feeling to be “handled”! 😱
That was my 2 seconds rant to the rest of the internet because the target audience does not care to listen.
Continue reading →
Do you know how to start your own Google Sites? There are many resources online about it so here, I will show you how to kick start the your every own Google Sites website project and give you some resource to move on to the next step.
- The Google login screen should appear (unless you have already login):
Continue reading →