Dynamics 365 Customer Engagement
Handling British Summer Time/Daylight Savings Time in Azure SQL
Is it just me or is British Summer Time (BST) AKA Daylight Saving Time (DST) an utterly pointless endeavour these days? Admittedly, on its…
Tag: SQL
Dynamics 365 Customer Engagement
A Beginner’s Guide to using FOR JSON in SQL Server
When it comes to handling large datasets in a formal, structured and highly scalable manner, nothing beats SQL Server. Having worked with the product…
Dynamics 365 Great Plains
SQL Collation – SQL_Latin1_General_CP1_CI_AS vs Latin1_General_CI_AS by Craig Verster via WinthropDC – azurecurve
Over the last few years as we have grown the ERP Practice at Perfect Image we have taken over a number of clients from…
Dynamics 365 Great Plains
Start/Stop SQL by Batch File – JenKuntz.ca
Today’s #TipTuesday post is for anyone who might be running more than one local instances of SQL Server. I often have at least a…
Dynamics 365 Great Plains
The Dynamics GP Blogster: Calling SQL Server stored procedures from Microsoft Dexterity
Back in January of 2009, I wrote an article showing a method of calling a SQL Server stored procedure from Dexterity by calling a…