A simple Machine Learning process example (supervised) – just to start with
I have just written the fifth article of the Machine Learning topic. !!! This time it is an example of the process – step by step. Do not miss...
2019-08-17
62 reads
Always On: Troubleshooting Consolidated
Working on Always On and configuration/setup of AG we have observed many errors. especially when configuration listener with following error 19471 or AG could not configure: Creating availability group...
2019-08-17
58 reads
Changing Git Credentials in Windows
tl;dr For Windows when you need a different account. I had to work with a new GitHub account recently and needed to add a separate account. I worked through...
2019-08-16
7,500 reads
Troubleshooting “Could not obtain information about Windows NT group/user”
This is one of those typical blog posts that I write for my future self, the guy who keeps fixing the same stuff over and over and forgets what...
2019-08-28 (first published: 2019-08-16)
2,734 reads
Installing Microsoft MDS on SQL Server Standard Edition
HaHa, tricked you. You can’t install SQL MDS on Standard Edition. You must first upgrade to SQL Enterprise Edition before you can proceed with an MDS installation. Upgrading SQL...
2019-08-15
116 reads
Constructing a datetime from an integer date and an integer time.
Occasionally I’ve seen date and time stored separately as integers. This had some practical applications back before we had date ... Continue reading
2019-08-27 (first published: 2019-08-15)
795 reads
Get All Database Snapshots and Their Parent Databases On A SQL Server
This is going to be a quick post but this morning I was asked the question, ‘how can I get the name of all the database snapshots on a...
2019-08-15
216 reads
Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running.
I have a client who uses MDS (Master Data Services) and SSIS (Integration Services) in an Azure VM. Since we only need to execute the SQL Agent job that...
2019-08-27 (first published: 2019-08-15)
250 reads
Jenkins in a Container
One of the things I needed to do recently was get Jenkins running as a demo for a customer. We have some pre-built VMs to do this, but I...
2019-08-26 (first published: 2019-08-14)
499 reads
Power BI Monthly Digest – August 2019
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI
2019-08-14
146 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers