We are a fictitious consulting company from the extraordinary imagination of Erin Dempster. At Endless Reporting, we could be implementing business intelligence solutions for companies of all sizes, from the corner barber to the multi-national conglomerate. Like most new companies, Endless Reporting has a multitude of data needs to run our business. With a limited amount of starting capital, we have decided to develop our own internal applications, while working on projects for our fictitious customers. At the heart of our data center is Azure, SQL Server and the Microsoft Business Intelligence (BI) stack.
Let’s do some blogging.
-
Standing up Azure SQL Managed Instance & Connect to Storage Account
This is a quick article, related to connecting an Azure SQL Managed Instance to an Azure Storage Account. When creating an Azure SQL Managed Instance, you have the options of creating a public endpoint and/or configuring the connection type of the private endpoint (as shown below). The default connection type for private endpoint is Proxy,… Read more
-
Recent and Upcoming Presentations
The first set of blogs I posted on this site center around Row Level Security in Microsoft SQL Server. In addition to these posts, I’ve decided to present the topic at PASS events, including multiple SQL Saturdays. Below are the events I’ve already presented at in 2020 and am hoping to present at later this… Read more
-
From a Past Life – Maximizing SQL Server Integration Services
Revisiting a series on SQL Server Integration Services and data integration projects.
-
From a Past Life – Querying Role Playing Dimensions with DAX
Revisiting an older post about role-playing dimensions in DAX.
-
Restricting Data Access with Row Level Security – Part 3
To this point in the series, the examples we’ve used are limited to the single Azure database for the Endless Timekeeping application. It’s great to define the concepts, but for an enterprise application, a few more tools need to be added to the tool belt. Endless Reporting isn’t large enough to really have good enterprise… Read more
-
From a Past Life – Reporting Services and Filtering Data by Current User
Revisiting an older blog about #ReportingServices
-
Restricting Data Access with Row Level Security – Part 2
Binding a filtering predicate function to a database table.
-
Restricting Data Access with Row Level Security – Part 1
When starting a new company, and you’ve added at least one other staff member, one of the most important applications you can have is a time tracking system. Time tracking is even more important for a consulting company, so customers are billed appropriately and we get paid. Depending on the number of features of this… Read more
-
Getting Started
As Endless Reporting gets up and running, we will be sharing tips and techniques we’ve found to be effective, related to Microsoft SQL Server, Azure and related technologies. Whether it’s for an “internal application” or for a “customer’s project”, we will share patterns and code snippets that were useful to us.