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)

You rated this post out of 5. Change rating

2019-04-30

3,560 reads

Blogs

Better Trigger Design: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

SQL Server in the Cloud – Are DBAs Still Needed?

By

Things your cloud vendor may not tell you   Here’s a common theme I...

ColumnStore Indexes: The Secret to Fast SQL Queries

By

🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍...

Read the latest Blogs

Forums

Dropping a PK constraint.

By stevec883

I will have to test this next week, but will not have a chance...

SQL - Conditional merge join

By SQL Bee

I want to add a condition in the joining columns part of the merge...

Is there a way to implement ROWS between logic?

By water490

Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...

Visit the forum

Question of the Day

What is Between?

I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?

SELECT *
FROM dbo.Products
WHERE ProductID
BETWEEN 4 AND 7;

See possible answers