Badges
75 Points
9 Years
User Activity
Over 8 years ago
The problem was in expectations as to which technical aspect of the implementation should be shifting during deployment. With consistency there was no issue, but testing pushed through changes in the database that broke the package variables in an environment. We weren't…
About 9 years ago
Sorry I should've been more clear. While this is possible, it's not ideal and from what I've seen not recommended in a production environment.
About 9 years ago
Answered a question: SQL Server 2012 - can I make OLTP transactions from my ERP run in memory?
https://msdn.microsoft.com/en-us/library/dn133186(v=sql.120).aspx
Here's the MSDN discussion of SQL 2014 in-memory OLTP
About 9 years ago
Over 9 years ago
Answered a question: When evaluating Relational Databases, what aspect do you think is the most important to look for?
Scalability, performance and Business Intelligence capability from ETL to warehousing and analytics. Also how well the database solution can be leveraged in an enterprise development organization. There are many more options these days but not from a mature development to…
Projects
Over 9 years ago
Collaborated for publication of Business Intelligence Reference ArchitectureCollaborated for publication of Business Intelligence Reference Architecture while at Microsoft.
Reviews
Answers
About 9 years ago
Relational Databases Tools
Over 9 years ago
Relational Databases Tools
Comments
Over 8 years ago
Relational Databases Tools
About 9 years ago
Relational Databases Tools
About me
Eight years of customer, product and channel reporting as Financial Reporting and Analyst, including customer consulting on report automation ,and then shifting to a focus on BI systems within IT to leverage SQL Server technologies. Worked as an information architect on a cross-functional team to deliver Business Intelligence to internal Microsoft, focusing on Business Solutions customers, partners, products and services metrics. It would be characterized as an agile platform.
A couple of highlights during my time in engineering:
I collaborated on the external publish of the Business Intelligence Reference Architecture documentation, along with other architects within Microsoft. I also joined the Design Rangers - a group of technology specialists within Microsoft IT working to improve the documentation of business processes, information models, database and system documentation.
I'm currently working as enterprise architect at Intelligent InSites, a software company that leverages real-time location software within healthcare environments to improve efficiency for staff, equipment and patients. It's an exciting platform with expanding use case scenarios and tremendous demand, with an added challenge for real time intelligence.
Specialties: Analytics, Data Analysis and Problem Solving, SQL Server, T-SQL, MDX, Excel and VBA, ProClarity, ProClarity Analytics Server, SharePoint, MS Access