Tags » Data Access

Capre Noctem – Using SQL Server Diagnostics (Preview) to analyze SQL Server minidump

Microsoft just released the SQL Server Diagnostics (Preview) extension within SQL Server Management Studio and Developer APIs to empower SQL Server customers to achieve more through a variety of offerings to self-resolve SQL Server issues. 201 more words

SQL Server

My #ESHG2017 Workshop Recording Available Now!

Please find below the workshop video I gave on Sunday 28th of May in Copenhagen as part of the European Society for Human Genetics (#ESHG2017). 30 more words

Tutorials

Azure Analysis Services ready for production!

Microsoft announced today the general availability of Microsoft Azure Analysis Services, the latest addition to their data platform in the cloud. Built on the on-premises analytics engine in SQL Server, Azure Analysis Services provides enterprise-grade data modeling in the cloud. 135 more words

BI

Learn to Protect Yourself From the Inside

Kingdoms have fallen, and wars have been lost because of betrayal. Although we all desire to foster an atmosphere of trust and dependence on one another within our companies, it would be foolish to underestimate the internal risks with reports and employees in this digital age. 570 more words

Hurricane Matthew Data Resources: Quick Snapshot (not inclusive)

Hurricane Matthew delivered a one-two-three punch (wind, storm surge, rain) to the Southeastern States last week.  Some of the facts/statistics on the storm are captured very well in this recent… 1,193 more words

General

My First Encounter with arcpy.da.UpdateCursor

I have been using arcpy intermittently over the past year and a half mainly for automating and chaining batch processing to save myself countless hours of repetition. 613 more words

Python

Management Reporter – Unit Security

Within this post I would like to present a feature that allows you restricting the access to data included in Management Reporter financial reports. A common business scenario where this feature can be applied are situations where business unit/cost center managers shall only have access to the data of the business unit/cost center they are responsible for. 754 more words

Management Reporter