Finding Last Password Changed for an Active Directory User Account

You can check the Last Password Changed information for a user account in Active Directory. The information for last password changed is stored in an attribute called “PwdLastSet”. You can check the value of “PwdLastSet” using the Microsoft “ADSI Edit” tool.

  Continue reading “Finding Last Password Changed for an Active Directory User Account”


TIOBE Index for December 2017

Have you seen the latest TIOBE rankings report?

The TIOBE Programming Community index is an indicator of the popularity of programming languages. The index is updated once a month. The ratings are based on the number of skilled engineers world-wide, courses and third party vendors. Popular search engines such as Google, Bing, Yahoo!, Wikipedia, Amazon, YouTube and Baidu are used to calculate the ratings. Observe that the TIOBE index is not about the best programming language or the language in which most lines of code have been written.

This month R and MATHLAB have made huge improvements, but the big news is Visual Basic.Net has dropped out of the top 5.

Dec 2017 Dec 2016 Change Programming Language Ratings Change
1 1 Java 13.268% -4.59%
2 2 C 10.158% +1.43%
3 3 C++ 4.717% -0.62%
4 4 Python 3.777% -0.46%
5 6 change C# 2.822% -0.35%
6 8 change JavaScript 2.474% -0.39%
7 5 change Visual Basic .NET 2.471% -0.83%
8 17 change R 1.906% +0.08%
9 7 change PHP 1.590% -1.33%
10 18 change MATLAB 1.569% -0.25%

The TIOBE Top 10 for this month:Read the entire results at this site.

Disaster Recovery Planning

Disaster Recovery

In your business, you are probably the only one tasked with understanding what types of disasters can strike your business and the task of planning to prevent those disasters from bringing down the business. As Alan Lakein said many years ago, “Failure to plan is planning to fail”. As an information technology professional, one of your many tasks is to understand the risks to your business systems and plan to prevent or overcome those risks from impacting your business.

About 40% of businesses do not re-open after a disaster and another 25% fail within one year according to the Federal Emergency Management Agency (FEMA). Similar statistics from the United States Small Business Administration indicate that over 90% of businesses fail within two years after a disaster.

Continue reading “Disaster Recovery Planning”

Four Years Later

Happy Anniversary - SeniorDBA

It has been over four full years since I started this technology blog. I originally created this blog as an easy to search reference for SQL Server information, really for my own personal use. This started as a place to store example scripts, techniques, and information about SQL Server. It has grown to include information about many of the subjects I deal with in my professional life, including programming, security, and project management.

Here are some basic facts to entertain you on this historic occasion:

  • This site has been in place for four years, and I have posted over 1300 individual posts.
  • I was posting at least one post for each calendar day for the first three years, but now I try to post each Monday.
  • The site now gets about 300 visitors per week, with an average of 50 page views per day.
  • When this blog started in December 2013, I was getting an average of 4 visitors per day.
  • The top 5 counties that have visited this site is the USA, United Kingdom, India, Canada, and Australia.
  • Someone from over 110 counties has visited this site in the last 12 months, with over 15,000 individual page visits.

Year One

Year Two

Year Three

I hope you continue to visit this site and you should encourage your friends to visit as well. Thanks.

CASB Explained

CASB - @SeniorDBA

A Cloud Access Security Broker (CASB) acts as a gatekeeper between your company’s endpoints and the multiple cloud services they use, and is positioned on the network perimeter. CASB software allows your company to extend your security policies to SaaS applications such as O365, Salesforce, Dropbox, and IaaS platforms such as Azure or AWS. A CASB simply helps a business secure communications end-to-end from cloud to device and vice-versa, regardless if the device is managed or unmanaged, from any location or any user.

In addition, modern BYOD policies can leave businesses staring liabilities in the face as employees begin to use cloud services without the IT department’s knowledge. This so-called ‘Shadow IT’ leaves data in the dark. Businesses have a responsibility to keep track of sensitive data, and with GDPR around the corner there’s no room for complacency. CASB can help enterprises make a compliant move to the cloud.

Continue reading “CASB Explained”

Troubleshooting RDP connections to an Azure VMs

RDP - @SeniorDBA

One of the most important aspects of placing your computers on Azure is the ability to connect to them using the Remote Desktop Protocol (RDP) to your manage your Windows-based virtual machines (VM). The issue with RDP can be with the Remote Desktop service on the VM, the network connection, or the Remote Desktop client on your host computer. We will attempt to guide you through some of the most common methods to troubleshoot and resolve common RDP connection issues.

The steps are displayed in the general order, but you should try reconnecting to the VM after each troubleshooting step.

Continue reading “Troubleshooting RDP connections to an Azure VMs”

10 Facts About Deploying Microsoft Office 365

O365 - @SeniorDBA

Microsoft Office 365 is a popular choice for enterprises that want a cloud-based suite of productivity and collaboration applications. The latest version of Office 365 gives you access to online Microsoft Office solutions anytime and anywhere on multiple Operating System platforms.

Microsoft’s marketing description of Office 365:

Microsoft Office 365 now includes Office 2016 and gives you the full Office experience. With access to the latest Office applications as well as other cloud-based productivity services, whether you need Office for home, school, or business, there is an Office 365 plan to meet your needs.
Our Office 365 subscription plans include Office 365 Home, Office 365 Personal, Office 365 University, and Office 365 for Mac. With each plan, you can install the 2016 versions of Word, Excel, PowerPoint, Outlook, and OneNote (Access, and Publisher are also included only for PC users). When a new version of Microsoft Office is released, you’ll get instant access to it so your applications are always up-to-date – and because Office 365 is optimized across your devices it’s easy to get anywhere access to your stuff on your laptop, phone, tablet and more.

Continue reading “10 Facts About Deploying Microsoft Office 365”