Let’s talk about PropTech

Proptech may be the technology that assists real estate professionals with performing their daily tasks, but there are a wide range of ways this technology has been implemented, and to varying degrees of success.

Some people are concerned that the ever growing technology sector will push humans out of the equation. But according to Forbes, property managers provide superior personalized experiences for tenants, as well as acting as advisors to owners for “opportunities to buy, sell, invest or upgrade properties” and consult on ever-changing regulations and bylaws, thus making them an effective investment for the foreseeable future.

But in addition to that unsurpassed human experience, technology is needed to meet the expectations of savvy consumers and to give property managers back the time they need to build real relationships with their customers.

To train and retain excellent property managers, owners need to ensure that mentors are available to all new hires. Forbes suggests focusing company culture, though their advice on providing growth opportunities may not be feasible in smaller communities.

No doubt property managers are excited to get their hands on all the new technology emerging almost daily. According to cpexecutive.com, instead of a property manager turning on a piece of equipment and just setting the temperature, they’re now able to receive additional analytics that allow for fine-tuning the equipment. ‘Roving engineers’ use predictive technology to monitor from afar and only go onsite if there’s an alerting request.

For commercial buildings, propmodo.com says proptech “should be capable of handling mountains of complex data while providing actionable insights in real time, such as locating a specific worker.” Further, it should be able to report problems in tenant spaces and common areas as well as handle vacancies and contracts.

For more insights into PropTech and the human factor, check out the articles below:





SQL Spring Cleaning: You KNOW You Need it!

Tis the Season of Spring Cleaning! While washing your car and scrubbing the window sills, be sure to include your SQL Server environment in your whirlwind of activity. Yes, much like the base boards, your SQL Server environment needs a little extra ‘maintenance’ attention now again.


Upgrading seems obvious, but we see a significant number of SQL Server installations running on the 2008 and 2012 versions. These SQL Server versions were all reasonably solid, so the “if it isn’t broke, don’t fix it” mentality has created a lag behind. Upgrades do more than solve problems however – they also provide new functionality and address issues that exist, but my not be obvious. Additionally, support for SQL Server 2008 R2 ends July 9, 2019, and SQL Server 2012 is scheduled to reach the end of its lifecycle in only three years. This may seem like a lot of time, but depending upon your other projects and your environment, 36 months can come around quickly. If you are on a SQL Server version below SQL Server 106, we recommend you upgrade to SQL Server 2017. Please review the Supported Version and Edition Upgrades for SQL Server 2017 and the Upgrade to SQL 2017 articles, published by Microsoft, to plan and execute your upgrade.

Since many of our clients leverage SQL Server Reporting Services, we wanted to highlight two items specific to this feature. First, the look and feel of Reporting Services changed significantly in SQL Server 2016, along with adding some long-awaited functionality, such as the ability to control parameter layout, mobile reports, and KPIs in the SSRS Web Portal. Second, the Reporting Services installation is now a separate download and install, rather than a feature component of the SQL Server installation.

Evaluate Licensing

SQL Server 2017 Standard Edition can be licensed on a Server + CAL or a Per Core basis. Your Edition and current license agreement will impact your options. Take a moment to touch base with your Microsoft Software Licensing Provider for a period review of your licensing costs.

Perform an Access Review

Databases move, turnover occurs, leaving orphaned users and old windows accounts straggling as a result. Take a moment to run the sp_validateusers stored procedure to identify an Windows accounts that need attention. SQL orphaned users take a bit more research: the MSSQL Tips article, Different Ways to Find SQL Server Orphaned Users, defines scripts for locating and addressing these.

Review the Basics

The turn of the seasons is a good way to schedule a review of your database health, which should be performed multiple times a year. Review your indexes for fragmentation, your databases for overgrown log files or outdated backups. Schedule and perform a “test drive” of a database restore. It is better to identify problems during a test drive than find out your backups are no good in the middle of a real-life issue. Check your SQL Agent Jobs to make sure they are working as desired and retire any jobs that are no longer needed. Evaluate your Reporting Services Subscriptions and confirm their distribution list is current. Confirm your SQL Server Maintenance Plans are performing tasks against all appropriate databases.

Touch Base with Your Team

Ask the users of the applications that depend upon SQL Server how those applications are performing. Users are the eyes and ears of your back-office system performance, so reach out and solicit their feedback. Team members are often the first to feel the impact of a missing or fragmented index or suffer the delays of a poorly written query. While the performance issue may not be something that can be resolved immediately, often times it can be resolved in time or mitigated. Healthy environments make happy users!

Changing Accounting Standards Will Impact Property Managers

Leasing guidance before the issuance of ASU 2016-02 required lessees to classify leases as either capital or operating leases. Lessees recognized assets and obligations related to capital leases; expenses associated with capital leases were recognized by amortizing the leased asset and recognizing interest expense on the lease obligation. Many lease arrangements were classified as operating leases, under which lessees would not recognize lease assets or liabilities on their balance sheet, but rather would recognize lease payments as expense on a straight line basis over the lease term.

The IASB decided that lessees should apply a single model to all leases, which is reflected in IFRS 16, Leases, released in January 2016. The FASB decided that lessees should apply a dual model. Under the FASB model, lessees will classify a lease as either a finance lease or an operating lease, while a lessor will classify a lease as either a sales-type, direct financing, or operating lease.

Click here to read the article: How Changing Accounting Standards Will Impact Property Managers

Download the guide from PWC (including the differences between ASC 842 and IFRS 16)



Worker Training: Ramp It Up!

Economists love worker training, but companies are often reluctant to provide it. The benefits of training can walk out the door if newly skilled workers are poached by a competitor.

Near-record-low unemployment is one big reason companies are recommiting to training. With a U.S. jobless rate of just 3.7 percent in September and more than 7 million unfilled positions as of August, employers can’t find the people they need in the ranks of the jobless, and luring them away from other employers has gotten prohibitively expensive in some cases. “Your choice is always make or buy. ‘Buy’ is steal somebody else’s worker…

Read more at Bloomberg.com


BIM: What is it and How do I Use it?

What does BIM mean? BIM stands for Building Information Modeling. It is a digital representation of the physical characteristics of a building or home. The BIM file can be used to plan, design and construct a structure in a graphical form or it can simply be a list of the parts and pieces needed for construction. Most people are familiar with two-dimensional CAD drawings that include plans, elevations and sections, such as electrical. With the ongoing advancements in technology, many designers and architects are now using three-dimensional drawings, which eventually will become the industry norm.

One common misconceptions about BIM is that it comes in a box like Microsoft Excel but it doesn’t. Many business professionals use Excel to build cash flow models based on their information reporting needs. Even though it is a common platform, each cash flow is unique and specific to an organization. The same is true with BIM software; it may use a common platform, but each structure is unique and the underlying components of parts and labor vary from project to project.

Today, BIM is used by residential developers to:

  • Generate plans and elevations
  • Develop materials lists (take-offs) and cost estimates
  • Create graphical presentations to support sales and marketing efforts with brochures and online graphics
  • Conduct virtual home tours that offer potential buyers a walk-thru of a plan/elevation in the comfort of their home

During the market downturn, builders eliminated their estimators to reduce overhead and shifted the responsibility and workload to their suppliers. Cornerstone sees a new industry trend (in the past 18 months) of either establishing in-house estimating capabilities or outsourcing to professional firms. Builders focused on bids and take-offs are finding significant savings by taking responsibility for their own plans/elevations, which benefits their bottom line.


Click to watch the April 2018 BIM webinar on our YouTube channel