Tags: SQL

Free PDF download MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203

Benjamin Perkins, Azure Data Engineer, C#

If you want to get a free copy of the Index, Table of Contents and of Chapter 1, have a look here.  Click on the READ AN EXCERPT dropdown and then select the one you would like to review.  Figure 1 illustrates how that looks like. Figure 1, how to get a free PDF copy […]

Read More →

MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203

Benjamin Perkins, Azure Data Engineer, C#

I am proud to announce the publication of my newest book titled, “Microsoft Certified Associate Data Engineer Study Guide” for the DP-203 exam. The example data used in this book consists of my brainwaves. You can download the data and the source code for all the examples in the book on GitHub here . ADLS, […]

Read More →

With-clause referenced two different from-clause elements

Benjamin Perkins C#

I believe if you are getting this error that there is more likely something wrong with your configuration than with NHibernate. I received this error when I wanted to create a nested join between 2 unrelated tables. Something like this in HQL: [sourcecode language=”sql” padlinenumbers=”true” autolinks=”false” gutter=”false” toolbar=”false”] select tbl.CODE, av1.NUM, al1.CODE from TABLE tbl […]

Read More →

How to sort by month in SQL Server

Benjamin Perkins C#

This is a older blog which I am migrating, you can see how the older website looked like here. You can see on the Blog.Archive() navigation bar on the right of this page that I present the Year, Month and number of blogs which I have written each month. Everything worked fine from October 2010 […]

Read More →