celedonpartners.com
  • Blog
  • Case Studies
  • Microsoft Dynamics
  • Microsoft Azure
Select Page

How to setup Azure Active Directory/Office 365 Authentication with Azure SQL database (PaaS)

by Vatsana Kongtakane | Jun 22, 2017 | Azure, Blog, Microsoft SQL Server

As more users are starting to move their SQL workloads to the cloud, one of the common questions is how to setup user authentication with their Office 365/Azure Active Directory tenant. There is of course some limitations. At this time, Azure AD authentication can…

Use CREATE OR ALTER For New SQL Object Scripts

by Eric Isaacs | Jun 6, 2017 | Azure, Blog, Microsoft SQL Server

When scripting out SQL Server objects in earlier versions of SQL Server, you’ve historically had the option to do so with “CREATE”, “DROP and CREATE”, or as “ALTER” scripts.  Each option has advantages over the others for…

Know, analyze and improve your SSRS report’s performance

by Terrance Zhou | Apr 4, 2017 | Blog, Microsoft SQL Server

Part 1. Know your report’s performance SQL Server Reporting Services (SSRS) is a powerful report building and deployment tool that is frequently used by a large number of institutions. However, a report that needs a lot of time to be rendered is useless as users lose…

Steps to have SSIS Package Call a WCF Voided Function

by Abdul Hakim | Mar 29, 2017 | Microsoft Dynamics, Microsoft SQL Server

I was recently working on a WCF (Windows Communication Foundation) service to keep InsideView’s most recent data in a SQL database. This database served as a cache when updating accounts in Dynamics CRM Online. I used the cached database as a fail-safe option if…
“In-line Comment Block” Trick in SQL Server T-SQL

“In-line Comment Block” Trick in SQL Server T-SQL

by Eric Isaacs | Feb 20, 2017 | Azure, Microsoft SQL Server

In Transact-SQL (T-SQL) there are two ways to comment SQL code that are similar to comment options in many programming languages. First, there’s the “slash star” (/*) comment block that allows you to comment out multiple rows of SQL. Second,…

How to TRUNCATE a SQL Server Table from a SYNONYM Name

by Eric Isaacs | Dec 7, 2016 | Blog, Microsoft SQL Server

If you work in an environment where your SQL Server database procedures need to frequently reference data in other databases or on other servers, it can be difficult to implement development, test, and production environments while still maintaining a single code-base…
« Older Entries

Recent Posts

  • Trick to Disabling the Cache in Dynamics Portals Development
  • (How-to) Create a Dynamic Bulk Edit Form in Dynamics 365
  • (How To) Update Microsoft Unified Service Desk (USD) Logo
  • Celedon AutoNumber v1.2.0 Released!
  • (How-to) Perform IIS Microsoft Dynamics CRM URL Rewrite

Tags

agile Azure azure resource manager business cloud comparison configuration consulting CRM CRM 2011 CRM 2013 CRM SDK Dynamics dynamics 365 Dynamics CRM Fields integration KingswaySoft learning Microsoft Microsoft SQL Server migration Office 365 opportunity partnerpass Performance powershell Press Release Product Design project failure project management project success role hierarchy salesforce Salesforce.com security sharing SQL SQL Server SSIS Usability user experience design UX Virtual Machine virtual machines

Archives

  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • November 2013
  • October 2013
  • September 2013
  • February 2013