Jerod Johnson

Jerod moved through life as a high school math and computer science teacher, developer support engineer, and software developer before landing in his current role as a technology evangelist, writing about, demo-ing, and presenting data connectivity solutions for CData. In the wild, you’ll find Jerod spending time with his wife and kids, out climbing some rocks (or plastic holds), or gathered around a table with friends playing board games.

SQLServerCentral Article

Build an OLAP Cube in SSAS using an ADO.NET Data Provider

SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]

5 (1)

2019-04-30

3,318 reads

Blogs

Truncating very large transaction log in full recovery mode

By

While I always configure transaction log backups for every database in non-simple recovery model,...

Autonomous Driving Around London

By

There’s a video of Bill Gates taking a drive in an autonomous car around...

Best way to monitor high worker thread on SQL Server

By

It is common to see high worker count issue on the production server and...

Read the latest Blogs

Forums

Remove the Dynamic code from my SQL sproc

By GrassHopper

I have a stored procedure that was created to run dynamically.  Other than me...

predictive query plan

By Arsh

Dear Friends, Please advise if there is a way to get a query plan...

Significance of Historical waits report in SQL server Performance dashboard

By IT researcher

I have the following historical wait report for my SQL server. I have noticed...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers