• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Home » Blog » SQL

SQL

SQL stands for Structured Query Language and allows you to access and manipulate databases. SQL has many advantages which makes it a popular and efficient language for communicating with the databases such as faster query processing and easy to learn. Check the latest posts from tutorials to troubleshooting from Joe Gill.

Synapse Link for Dataverse – Metadata

5th July 2022 by Joe Gill

I previously wrote a couple of blog posts (post1 and post2) suggesting two different ways to access your Dataverse metadata in Synapse. Both of these techniques are now redundant as Microsoft announced in May 2022 that the Dataverse metadata is now available directly in Synapse. Your Synapse serverless pool now contains additional external tables with the metadata. Your queries … [Read more...] about Synapse Link for Dataverse – Metadata

Dataverse Metadata in Synapse

17th January 2022 by Joe Gill

Datavseres Metadata - Azure Synapse

Note: the Dataverse metadata is now available out of the box and so this approach is no longer relevant. I have an updated post here When you configure Synapse Link for Dataverse it exports your Dataverse data into a Synapse data lake as CSV files. A database with external tables is created automatically in the Serverless SQL pool providing access to the data in the CSV … [Read more...] about Dataverse Metadata in Synapse

Synapse Link for Dataverse – Option Sets

22nd December 2021 by Joe Gill

Azure Synapse Link for Dataverse Tables

Note: the Dataverse metadata is now available out of the box and so this approach is no longer relevant. I have an updated post here On November 23 Microsft announced that DES (Data Export Services) will be deprecated and will reach end of life in November 2022. Microsoft is recommending that customers use Azure Synapse Link for Dataverse instead. DES has been around for a … [Read more...] about Synapse Link for Dataverse – Option Sets

Dynamics CRM Default Custom Report Template

11th April 2016 by Joe Gill Leave a Comment

This is a quick tip which may save you some time if you frequently use Business Intelligence in Visual Studio to develop custom reports for Dynamics CRM. You can create a report RDL file and use this as the default template for new reports. Simply create a new report and configure your CRM data source and add any other common items you require such as … [Read more...] about Dynamics CRM Default Custom Report Template

Could not load file or assembly Microsoft.ReportViewer.WebForms

3rd October 2012 by Joe Gill Leave a Comment

A colleague of mine got this error after deploying an application which uses the reporting services report viewer control.  By default when you add a reference to an assembly which resides in the GAC  it does not copy the dll to the local bin folder. So the application runs fine locally in debug mode however you then get this error when you deploy it to a server where … [Read more...] about Could not load file or assembly Microsoft.ReportViewer.WebForms

SQL Server Saturday Dublin 24th March

17th January 2012 by Joe Gill Leave a Comment

Well done to the SQL Server User Group in Dublin who have organized a great day of SQL server talks taking place on 24th March.This is a community event and free to attend with many of  the world top sql experts speaking.More details and registration here   Well done all involved. … [Read more...] about SQL Server Saturday Dublin 24th March

SQL Server Express – Profiler

12th July 2010 by Joe Gill Leave a Comment

SQL Server Express does not come with a profiler however AnjLab have just released a new version of their great free open source profiler here.  Well recommended … [Read more...] about SQL Server Express – Profiler

Reporting Services – Shared Datasets

7th July 2010 by Joe Gill Leave a Comment

Shared datasets which were introduced in Reporting Service 2008 R2 allow a dataset to be shared across reports improving performance and avoiding the typical duplications of common querys and joins you find in most reporting services projects. Like most things in Reporting Services they are pretty easy to use.The following is an example of how to use shared datasets with the … [Read more...] about Reporting Services – Shared Datasets

Reporting Services – Data -Driven Subscription

22nd October 2009 by Joe Gill Leave a Comment

 In Reporting Services data driven subscriptions are used to run a query on a scheduled basis which returns a list of recipients to receive a report.  What I have tried to do here is to show a simple example which will use this functionality to monitor an application and email out a report when any alerts that have been triggered.  You need the enterprise version … [Read more...] about Reporting Services – Data -Driven Subscription

SQL Server Express and Reporting Services

29th September 2009 by Joe Gill Leave a Comment

A common question that gets asked is if SQL Serve Express supports Reporting Services. Yes it does however you need to install the version Advanced Services which can be downloaded from here.In addition to the usual restrictions you get with the Express version you can only use Reporting Services against you local express database i.e. you cannot install SQL Express and then … [Read more...] about SQL Server Express and Reporting Services

Next Page »

Primary Sidebar

Popular Categories

  • Power Platform
    • Power Apps
    • Power Automate
    • Power Virtual Agents
  • Azure
    • Logic Apps
  • Dynamics 365
  • .NET
  • AI
  • SQL

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

Synapse Link for Dataverse – Metadata

5th July 2022 By Joe Gill

extract table from pdf and write as csv file using Power Automate Desktop

Extract Tables from a PDF using Power Automate Desktop

23rd May 2022 By Joe Gill

Tweets

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

Power Fx Formula Columns in Dataverse

Synapse Link for Dataverse – Metadata

Extract Tables from a PDF using Power Automate Desktop

Dataverse Anonymization

© 2022 · Joe Gill