One question that is consistently asked by users is about the time values in subscription views. If you look at the “EnterDateTime” and “LastChgDateTime” values in the views, you’ll notice that time may be off by a number of hours. The difference is due to MDS using UTC when it stores time internally.
After a short hiatus, the SQLSaturday BI edition is coming back to Atlanta. The event will be held on September 22, 2018 at the Microsoft office in Alpharetta.
This year we’ll have two excellent PreCons available:
From 0 to DAX By Marco Russo, MVP, Dax Guru & Author
During this one-day workshop, the author of the bestseller books The Definitive Guide to DAX, The Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model, and Building Data Models with Power Pivot, will guide you in the process of learning the DAX language, through many examples and scenarios that will help you understand the important concepts of DAX and how to leverage them in the everyday work.
The workshop is useful to many profiles: Information Workers interested in exploiting the many interesting features of PowerPivot for Excel and BI developers who want to learn the DAX language.
Deploying Power BI in your Enterprise by Adam Sexton & Patrick Leblanc from Guy In A Cube
Description: Have you wondered what the right approach is for creating and deploying your Power BI content? Which tools are the right ones? When do you use app workspaces and apps? How to understand your licensing options? And how to keep your data up to date? If you answered yes to one or more of the above questions, then this pre-con is for you!
During the pre-con, we will look at the following areas
- Deployment options
- Licensing options
- Data storage
- Refreshing data
- Collaboration and sharing options
- All about administration and security
- and more…
What’s a full day without time for your questions also!
Changesets are one of the most useful features in MDS for data management. Confirmation of a proposed change can help prevent mistakes both locally and when “Approval Required” is enabled. The only issue is how do you determine who approved the changeset in MDS?
There is a table for each model that ends in “_CS” to store the changeset information. For example, model 1 would be named “mdm.tbl_1_CS”. This table stores the current status as well as create and update information. There is some other useful information, but the change approver is not listed.
The Message column in “mdm.tblNotificationQueue” does contain that information. It looks like there are separate entries when the changeset status is changed to Pending/Approved and Committed. It would be a lot easier if all of those were in the “_CS” tables.
SELECT b.UserName AS [Approved By],
SUBSTRING(Message, CHARINDEX('<changeset>', Message) + LEN('<changeset>') , CHARINDEX('</changeset>',Message) - (CHARINDEX('<changeset>', Message) + LEN('<changeset>')) ) AS [Changeset] ,
SUBSTRING(Message, CHARINDEX('<new_status>', Message) + LEN('<new_status>') , CHARINDEX('</new_status>',Message) - (CHARINDEX('<new_status>', Message) + LEN('<new_status>')) ) AS [Changeset Status] ,
FROM mdm.tblNotificationQueue a
JOIN mdm.tblUser b ON a.EnterUserID = b.ID
where Message like '%<new_status>Approved</new_status>%'
I’ve been using CrashPlan for Home for a few years now to back up my NAS and a few of my machines. They’ve been great and I’ve never had any issues once I got everything configured. Working in IT and hearing stories about friends losing data led me to follow the 3-2-1 backup rule. Accidents can happen in many different ways and are usually expensive.
About a year ago I received an email from CrashPlan announcing that they were moving away from the personal backup business and focusing on small business. The Home plan was a pretty good deal, and I wouldn’t be able to match the features that their service provided for the price.
A few weeks ago, after some focused procrastination and another email warning about the deadline, I decided to take the easy route and switch to their Small Business account. That option is a little more expensive, but it was a seamless move. It didn’t require any changes at all. I read some reviews of the other comparable services, and it just seemed like a good idea to stay with CrashPlan.