In the December post, SharePoint 2016 Initial Configuration, Part 2, I created some managed accounts, a web application and a root site collection using the Graphical User Interface and PowerShell. The third blog in this series details creating a User Profile Service Application and importing users. In SharePoint 2016 Preview and SharePoint 2016 Beta 2, theRead more
Overview SQL Server 2016 is the latest version of the data platform from Microsoft (currently in public preview). Per Microsoft, “It is the biggest leap forward in Microsoft’s data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios.” There’s a tonRead more
Introduction Common Cloud and Software as a Service (SAAS) applications, typically require the use of data from multiple sources. Accessing data from multiples sources can be complicated. This blog will discuss how accessing data from multiple sources can be simplified using an open source Object Relational Mapper (ORM) as part of the multi-tenant application. AnRead more
This statement is a bit misleading. Clearly, SQL Server Reporting Services (SSRS) never actually went away. At Superior Consulting Services (SCS), SSRS never left our arsenal of tools for meeting client business needs. We have been using SSRS to create robust reporting and data visualization solutions all along. We have continued to train and mentorRead more
SCS consultant, Jared Zagelbaum, shares from his blog a custom solution to render SQL Server Analysis Services Tabular Model metadata to users using Reporting Services; a task that is often performed manually. Read more.
Today is the big day, Power BI (also referenced as the “new” or 2.0 release) is becoming generally available (GA). This is a very big announcement and we will also see a major update to the Power BI Desktop (formerly known as Power BI Designer) application that will be made available today. The Power BIRead more
On Monday June 8, I attended Big Data Tech, a Minnesota conference on the technology behind analytics. Held at Normandale Community College, this free one-day conference on Big Data was hosted by Minneanalytics and attracted approximately 500 attendees representing a variety of industries including a large segment from healthcare. The presentations were primarily focused on largeRead more
SCS Consultant Jared Zagelbaum is a data warehouse professional with direct experience in Manufacturing, Retail, Insurance, and Financial Services verticals. Some of his most recent solutions have implemented Microsoft’s In-Memory analytics engine, or SSAS tabular. Here he shares from his personal blog, a DAX formula language development pattern that adds value to client solutions. LinkRead more
Scenario When running a query, many times there are instances where there is non-existent data. The following blog addresses various scenarios and solutions for overcoming this issue. A hospital report needs to show Intentsive Care Unit (ICU) bed occupancy by date. The WITH statement below simulates a small table of source data so you canRead more
Scenario As a consulting database administrator (DBA), there is a long list of things I look at when first assessing the overall health of a client’s databases. A number of these checks require I issue the same query in every database. Some clients have a dozen or more SQL Server instances with any one containing 100 orRead more
