SQL & Data
SQL scripts, GP tables, SQL Server administration, data fixes, check links and reconcile.
Articles
2018
- 2018-08-27SQL Script to Disable Business Analyzer Fact Pane
- 2018-06-11“There’s nothing wrong with our SQL Servers or network”, says the IT department confidently
- 2018-02-15How to Suck at Database Administration
2016
- 2016-02-08DynamicsPerf 2.0 QUERY ALERTS
- 2016-01-07DynamicsPerf 2.0 Historical Tables and Baselines
2015
- 2015-11-09Microsoft Power Query: An Excel User’s Dream for Data Extraction and Cleansing – MSDynamicsWorld.com
- 2015-09-22Weekly Dynamic: Trigger to Show Workflow 2.0 Final Approver on PO
- 2015-06-29Weekly Dynamic: Reporting Central’s The Closer bailed me out
2014
- 2014-12-01Get First and Last Date of Previous Month | Dynamics University
- 2014-09-30Change SQL Server From Windows Authentication To Mixed Mode | azurecurve
- 2014-05-29New home for DYNAMICSPERF
- 2014-04-28Weekly Dynamic: Create a Super User
- 2014-03-25Dynamic Dashboards: Pivot Tables, Power Pivot and 1 million rows
- 2014-02-04MSConnect Doc Attach Functionality
- 2014-02-03Weekly Dynamic: Managing Dates with Pivot Table Groups
2013
- 2013-09-16GP Cubes and Named SQL Instances | Dynamics Care Services
- 2013-06-27Big Data for SQL folks: The Technologies (Part I) – SQLServerCentral
- 2013-04-10SQL Script to List Actual vs Budget for GL Accounts by Period : Microsoft Dynamics GP Discussion
- 2013-02-25Weekly Dynamic: Drill Down Troubleshooting
- 2013-02-20View Summary of Accounts with drill down options via Account Rollup Inquiry | onza blog
- 2013-01-29SQL settings causing GP performance issues | Dynamics University
2012
- 2012-11-26Weekly Dynamic: Clear Data Physical Tables
- 2012-09-04Feature of the Day: Named System Database – Inside Microsoft Dynamics GP – Site Home – MSDN Blogs
- 2012-08-22Yes, Dynamics GP 2010 is Compatible with Microsoft SQL Server 2012
- 2012-07-05Error Posting to Table POP30390. Restore from a backup if possible
- 2012-07-03How to remove the Connect section on the HomePage in Dynamics GP (via SQL)
- 2012-06-04Table Links in Extender – Microsoft Dynamics GP Support Blog – Site Home – MSDN Blogs
- 2012-05-02A Get/Change Operation on Table ‘gpAppEnabled’ Cannot Find the Table | Dynamics University
- 2012-04-23Convergence 2012 Demo: Microsoft Dynamics GP 2013 Business Analyzer on tablet device – Inside Microsoft Dynamics GP
- 2012-04-16NEW Microsoft SQL Server 2012 Features – What is Supported with Microsoft Dynamics GP? – Microsoft Dynamics GP Support Blog
- 2012-04-11A Couple of Recent Backup Stories
- 2012-03-29Microsoft Dynamics GP and Microsoft SQL Server 2012 Compatibility | DynamicsCare
- 2012-03-28Dynamics GP 2010 R2 Database SDK | Interesting Findings & Knowledge Sharing
- 2012-03-13Feature of the week: Excel Report Pivot Tables in GP 2010 | onza blog
- 2012-03-08Interesting Findings & Knowledge Sharing » SQL Script for AP-GL Reconciliation – Updated
- 2012-03-07Number of results columns doesn’t match table definition errors in Personal Data Keeper – Microsoft Dynamics GP Support Blog
- 2012-03-05Moving SQL Server Reporting Services from Native Mode to SharePoint Integrated Mode – Microsoft Dynamics GP Support Blog
- 2012-02-16How to update Fixed Asset Labels using Microsoft SQL Server Management Studio – Dynamics GP Support and Services Blog
- 2012-02-15How to update Fixed Asset Labels using Microsoft SQL Server Management Studio – Dynamics GP Support and Services Blog
- 2012-02-15Streamlined Purchase Processing in Dynamics GP from the List View
- 2012-02-06Mohammad R. Daoud: How to change SQL Collation for SQL Server 2008 R2
- 2012-01-18Interesting Findings & Knowledge Sharing » SQL Script for AP-GL Reconciliation
- 2012-01-10IRS audits of small business software files
2011
- 2011-12-13Mohammad R. Daoud: Kill All Connections to an SQL Server Database
- 2011-11-14Project Accounting View–iSolutions
- 2011-11-14Mohammad R. Daoud: Purchase Order Commitments View
- 2011-11-03Business Portal Query Error – Cannot find table 0 – andy.nifong
- 2011-11-02Smartlist Builder Example – Sub Query Restriction Prototype | Interesting Findings & Knowledge Sharing
- 2011-10-20Weekly Review: Schedule Backups from Within Dynamics GP
- 2011-10-06Weekly Review: Copy Headings and Data from SQL
- 2011-10-03Weekly Dynamic: Transaction Aborted…in table ‘dbo.deleted’
- 2011-09-19SQL Reporting Services Error- Maximum request length exceeded
- 2011-08-08SQL View for Daily Payment Summary | Interesting Findings & Knowledge Sharing
- 2011-08-03GP Upgrade Fails at Table » Summit Group Software Blog
- 2011-07-18SQL Script for Vendor EFT Information | Interesting Findings & Knowledge Sharing
- 2011-06-27SQL Script for Purchase Order Line Items Not Yet Received | Interesting Findings & Knowledge Sharing
- 2011-06-27Information about Check Links for Analytical Accounting in Microsoft Dynamics GP – Dynamics GP Support and Services Blog
- 2011-06-16Permissions Issue with SQL Reporting Services on Vista | Interesting Findings & Knowledge Sharing
- 2011-06-13Weekly Dynamic: Asset ID’s Beginning With “Z” Don’t Appear on Some Reports
- 2011-06-13SQL Script to Report against multiple GP Companies | iSolutions
- 2011-06-13Belinda, the GP CSI: GL Summary Trial Balance made easy with Excel Pivot Tables
- 2011-05-31PragmaticWorks Webinar–Free SQL Training
- 2011-05-31Updated SQL Script for fixing Primary Key Errors in Analytical Accounting | Interesting Findings & Knowledge Sharing
- 2011-05-23SQL Script for POP Receiving Transactions with AA Information | Interesting Findings & Knowledge Sharing
- 2011-05-17Interesting Findings & Knowledge Sharing » Table Structure Definitions – Fiscal Period Setup
- 2011-05-16Interesting Findings & Knowledge Sharing » Missing Object Explorer in SQL Server Management Studio
- 2011-05-11Interesting Findings & Knowledge Sharing » SQL View for Purchase Order Details with AA Information
- 2011-04-11Feature of the Day: Additional SQL Reporting Services Metrics – Inside Microsoft Dynamics GP
- 2011-04-07Weekly Review: Restarting Project Accounting
- 2011-03-28GP 2010 R2 Feature of the Day: List View Performance Enhancements – Inside Microsoft Dynamics GP
- 2011-03-09SQL Script to Assign ALL GP Items to ALL Warehouses – iSolutions Partners
- 2011-03-04Feature of the Day: New SQL Reporting Services Reports – Inside Microsoft Dynamics GP
- 2011-03-03Feature of the Day: Drilldown from SQL Reporting Services Reports – Inside Microsoft Dynamics GP
- 2011-02-28Mohammad R. Daoud: Management Reporter–Load Database is not loading my database?!?
- 2011-01-25SQL Server Backup and Maintenance Solution – andy.nifong
- 2011-01-17Update tax table for Illinois State Income Tax rate change!
- 2011-01-17SQL View to extract Analytical Accounting Budget Data With Accounts in Dynamics GP
- 2011-01-03Weekly Dynamic: GL/MDA SQL
2010
- 2010-12-20FIX SQL Orphaned Users (Create SQL Users exists in a restored database in SQL Users)
- 2010-11-23SQL Script for Last Purchase Cost of Items
- 2010-11-18Weekly Review: Match Case in SmartList
- 2010-11-18SQL Query for GL Trial Balance – GP 2010
- 2010-11-11SQL Script for Checkbook Balance
- 2010-11-10SQL Queries for AA Summary Balances in Dynamics GP
- 2010-11-08SQL Query – Sales Accounts Due Report
- 2010-11-08Receivables HATB Report–SQL Script
- 2010-11-01Weekly Dynamic:Default SmartLists and Table Scans
- 2010-11-01Budget Analysis Query for Dynamics GP
- 2010-07-26Exam Dumps – Emerging Trend in Dynamics Community
- 2010-07-15Weekly Review: Table Import
- 2010-06-28Weekly Dynamic: Counting AP Transactions
- 2010-06-16Updated Downloads and SQL Scripts
- 2010-06-07Weekly Dynamic: Run A/R Aging from SQL
- 2010-05-25Dynamics GP 2010 Excel Based Table Reference
- 2010-05-17SQL Script to delete stranded activity for a specific user
- 2010-05-04Smart List Tree View Space
- 2010-04-27Weekly Dynamic: Portable Excel Reports, the Best of Both Worlds Part 1
- 2010-04-23Weekly Review: Help | About
- 2010-03-25Weekly Review: Access SQL Reporting Services from GP
- 2010-02-25Excel Pivot Table Builder in GP 2010
2009
- 2009-11-12Weekly Review: Scheduling Backups in Dynamics GP
- 2009-10-19Weekly Dynamic: Copy Headings and Data from SQL
- 2009-05-04Weekly Dynamic: SQL to Show Transactions for a Certain Account
- 2009-02-09Weekly Dynamic: Restart Project Accounting
- 2009-01-04Backup, Backup, Backup
2008
- 2008-11-23Dynamics GP and SQL Table Maintenance
- 2008-10-27Running a SQL Script Agains All GP Companies
- 2008-10-10Lots of Dynamics GP Table Resources
- 2008-09-08Weekly Dynamic: Add (and Check) “Match Case” in 8.0 and 9.0 Smartlists
- 2008-08-06SQL Server 2008 Is In the Can
- 2008-07-28Weekly Dynamic: Contract Secrets
- 2008-07-09Mary Jo Foley says SQL Server 2008 in August
- 2008-04-30Query for Customers Who HAVEN’T Bought a Particular Item
- 2008-03-28I’m Speaking at SQL Saturday Jax
- 2008-03-25Early Thoughts on Dynamics GP and SQL Server 2008
- 2008-01-28Don’t Hold Your Breath For SQL Server 2008
- 2008-01-21Smartlists, Tables, Joins and Reporting Resources
2007
- 2007-12-19Basic SSIS Tuning
- 2007-12-14SQL Server 2008 Virtual Event
- 2007-12-13SQL 2008 Podcast
- 2007-11-21Getting the Size of Your Dynamics GP Database
- 2007-11-13Cleaning Out the SQL Closet
- 2007-11-13SQL Reporting Services 1st Tips
- 2007-11-13Reporting Practices
- 2007-11-05GP 10 Table Reference is Done
- 2007-11-05Dynamics GP 10 Table Reference Fixes
- 2007-09-28Weekly Dynamic: Table Import
- 2007-09-13Weekly Dynamic: Inventory Value via SQL
- 2007-07-12You’ve Got Another Year on SQL Server 2005
- 2007-06-07SQL Server 2005 Performance Dashboard
- 2007-05-10SQL Server 2008?
2006
- 2006-11-28Oracle has more flaws than SQL Server
- 2006-11-20Weekly Dynamic: Help-About
- 2006-10-10Weekly Dynamic: Access SQL Reporting Services from GP
- 2006-06-30Weekly Dynamic:Support Administrator Console
- 2006-05-16Weekly Dynamic: Schedule Backups in 9.0
- 2006-05-14RAID 0+1 and RAID 1+0
- 2006-03-26SQL Server 2005
- 2006-03-26SQL Reporting Services Full
- 2006-03-26Upgrading to GP 9.0
- 2006-03-21Policy Manual and Calculator Downloads
- 2006-03-16DynamicsGP Table Reference is Now Available
- 2006-01-06SQl 2005 and Dynamics GP Compatibility info
2005
- 2005-12-08SQL Server 2005 Orlando Launch Event
- 2005-10-28SQL Server 2005 Released to Manufacturing
Links to other writers
2023
2020
- 2020-08-24SQL script to create macro to delete items in Microsoft Dynamics GP – azurecurve
- 2020-08-24SQL Stored Procedure to remove Jet Reports’ Report Run History – azurecurve
- 2020-08-03Error trying to combine sites in the PSTL tool: You cannot combine the sites as it is the same on a transfer record in the history table. – Microsoft Dynamics GP Community
- 2020-06-16SQL script to insert test email address to all customers – azurecurve
- 2020-06-15SQL script to populate the Payables Distribution Type SETP (PM40103) table – azurecurve
- 2020-06-15Use SQL to generate a macro to create Vendor Items – azurecurve
- 2020-04-27HOW TO USE SQL TO TROUBLESHOOT A GP SOP ORDER THAT DID NOT MOVE TO HISTORY WHEN IT WAS FULLY INVOICED – Microsoft Dynamics GP Community
- 2020-04-01SQL Script to update vendor and customer email addresses – azurecurve
- 2020-04-01SQL View to return most recent five purchase orders by vendor – azurecurve
- 2020-04-01SQL Script to get all accounts set as available in Purchasing lookups – azurecurve
- 2020-02-11SQL View to return Microsoft Dynamics GP Workflow step approvers – azurecurve
- 2020-02-11SQL Stored Procedure to delete old Microsoft Dynamics GP Document Attachments – azurecurve
2019
- 2019-10-03Microsoft Dynamics GP and Year-End Update: The Database Upgrade – Microsoft Dynamics GP Community
- 2019-09-11SSRS requires that you use local SQL Server relational databases… error – azurecurve
- 2019-09-03Microsoft Dynamics GP Error: “A Countrecords operation on table ‘[Not Found]’ (45).” – azurecurve
- 2019-05-29SQL Function to Remove Alphanumeric Characters – azurecurve
- 2019-05-15Find Table in All Microsoft Dynamics GP Databases – azurecurve
- 2019-05-14SQL Script to Delete Unused Segments – azurecurve
- 2019-05-14SQL Script to Insert Vendors – azurecurve
- 2019-04-24SQL View to Report on Fixed Allocation Accounts – azurecurve
- 2019-03-28SQL Server Management Studio Tips
- 2019-03-20Create SmartConnect Journal – Standard Map: Series Index
- 2019-03-18Steve Endow – The Blog: Troubleshooting a Dynamics GP SQL Posting Error
- 2019-03-12What’s included in those SQL rpt roles? – JenKuntz.ca
- 2019-03-07Formatting SQL
- 2019-02-06Implementing SmartConnect: Series Index
2018
- 2018-12-27Clear Companies script & custom tables
- 2018-12-06eConnect Performance: Using GetNextDocNumbers vs taGetNext stored procedures
- 2018-11-26Upgrading to Jet 2019: Series Index
- 2018-10-08Hands On with Microsoft Dynamics GP 2018 R2: Series Index
- 2018-09-20#GP2018R2 Feature of the Day – Vendor Document Number added to Purchasing All-in-One View
- 2018-09-12SQL Snippet: Get Dates for Accruals
- 2018-09-12Jo’s Did You Know “You can set your AR Aging Routine to Run Automatically in All GP Databases”
- 2018-08-28SQL Script to Notify When Upgrade Complete
- 2018-08-28SQL Script to Change Compatibility of All Databases
- 2018-08-27SQL Script to Disable Business Analyzer Fact Pane
- 2018-08-27Calling SQL Server stored procedures from Microsoft Dexterity – revisited
- 2018-07-19Enabling Secure Connection for Web Services: Series Index
- 2018-06-25Jo’s Did You Know “There Are Multiple Tables in GP Containing Email Setup and Use Information”
- 2018-06-25GP Transaction Search: Series Index
- 2018-06-11Sample SQL Views for Smartlists
- 2018-06-11Using SQL to review Analytical Accounting information in Dynamics GP (the Basics) – Microsoft Dynamics GP Community
- 2018-05-22Get Next Dynamics GP SOP Transaction Number Using SQL
- 2018-05-03Get Next Dynamics GP RM Payment Number Using SQL
- 2018-05-02Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance – Part 3/3
- 2018-04-30Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance – Part 2/3
- 2018-04-30Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance – Part 1/3
- 2018-04-19Error : “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company”
- 2018-04-11Logical File Name SQL Scripts: SQL Script to Create Restore Scripts for all Dynamics Databases
- 2018-04-09Logical File Name SQL Scripts: SQL Script to Alter Logical Filenames of all Dynamics GP Company Databases
- 2018-04-04Logical File Name SQL Scripts: Series Index
- 2018-03-27SQL View to Return Prior Day Logins
- 2018-03-27Alex Meyer “Recently Microsoft retired their AX 2012 ERD”
- 2018-02-28Microsoft Dynamics GP: Running System and Company Databases
- 2018-01-03Do you know when a SQL trigger is dropped?
2017
- 2017-12-18Year End Payroll Data – SQL View for Dynamics GP
- 2017-12-18GP #LifeHacks 119: Year End Wage Data in a Smartlist using a SQL View
- 2017-12-13Dynamics GP 2018 – Attachment Report – All Attachments ( Updated SQL Script )
- 2017-11-27Microsoft Dynamics GP Macros: Macro By SQL
- 2017-11-16Microsoft Dynamics GP Macros: Series Index | azurecurve azurecurve
- 2017-11-15MDGP 2018 RTM Feature of the Day: Series Index | azurecurve azurecurve
- 2017-11-14Manufacturing Data Collection Process and Tables – Microsoft Dynamics GP Community
- 2017-11-10SQL Script To Verify Sales Invoice Extended Cost Against Subtotal | azurecurve azurecurve
- 2017-11-10SQL View to Return Purchases By Vendor By Fiscal Year | azurecurve azurecurve
- 2017-10-18Microsoft Dynamics GP 2018 and Year-End Update – The Database Upgrade – Microsoft Dynamics GP Community
- 2017-10-05Dynamics GP Land: Back up your Dynamics GP SQL Server databases directly to Azure Storage in minutes!
- 2017-09-22SQL Query Optimization for Mere Mortals! – MSDynamicsWorld.com
- 2017-09-19SQL View turned Excel Report for Fiscal Period Closing data – GP Life Hacks
- 2017-09-04SQL view for unposted checks in Dynamics GP | Victoria Yudin
- 2017-08-17SQL View to Return Sales By Customer By Year | azurecurve azurecurve
- 2017-08-17SQL Script to Prefix Email Message Subjects with Test | azurecurve azurecurve
- 2017-08-17SQL View to Return Purchases By Vendor By Year | azurecurve azurecurve
- 2017-08-17Dynamics GP Land: Adding or dropping SQL indexes temporarily on production database tables
- 2017-08-17Dynamics GP Land: Tales of Dynamics GP backups and ransomware
- 2017-07-10How to move your Management Reporter 2012 database to a new server – Microsoft Dynamics GP Community
- 2017-07-10SQL Connectivity Errors seen in Microsoft Dynamics GP – Microsoft Dynamics GP Community
- 2017-06-29Short URLs Available on Microsoft Dynamics GP Table Reference | azurecurve
- 2017-06-29Workaround to Workflow Notification View/Edit Link Doesn’t Work on Outlook 365 Online | azurecurve
- 2017-06-22Microsoft Dynamics GP Table Reference | azurecurve
- 2017-06-05Did you know…Backups – Microsoft Dynamics GP Community
- 2017-05-31Stored Procedure To Get Next Purchase Receipt Number | azurecurve azurecurve
- 2017-05-31SQL View to Return Budgets By Month | azurecurve azurecurve
- 2017-05-31Deploy SQL View to All Databases | azurecurve azurecurve
- 2017-05-16Dynamics GP Land: Very impressive SQL script for running multi-company Dynamics GP queries
- 2017-05-16SQL Script To Return Functional Currencies For All Companies Without a Cursor | azurecurve
- 2017-05-16Dynamics GP Land: Extract Dynamics GP Document Attach Files From SQL Server and Save To Disk
- 2017-04-20SQL Function To Return Workflow Approval Status | azurecurve azurecurve
- 2017-04-13Dynamics Confessions Blogspot: T-SQL View to create Dynamics GP GL Summary Trial Balance
- 2017-03-31MS Connect Suggestion: Allow SQL Views to be Included in Workflow Conditions | azurecurve
- 2017-03-08Delete or Remove Range Errors on ‘SY_Current_Activity’ table after GP 2015 R2 | David Musgrave’s Winthrop Development Consultants Blog
- 2017-03-08SQL Script To Activate Horizontal Scroll Arrows | azurecurve azurecurve
- 2017-03-08Can’t View Payables Document Attachments?? Never Fear, We’ve Got You Covered!! – Microsoft Dynamics GP Community
- 2017-03-08Dynamics GP Land: SQL Script to verify Dynamics GP GL batch control totals
- 2017-03-06SQL Script To Update EFT Payment Register Report | azurecurve
- 2017-02-23Dynamics GP Essentials: Dynamics GP – Price List Details SQL Script
- 2017-02-16Dynamics GP Land: Don’t Forget- Standard GP SQL Views
- 2017-02-14The Dynamics GP Blogster: You receive “Unhandled Script Exception: Invalid Product ID 258” when attempting drill-down into an invoice from Purchasing All-In-One view
- 2017-01-18Dynamics GP Land: 6 Tips to Help You Get More Out of SQL Server Management Studio
- 2017-01-04Microsoft’s SQL Server Database Was the Surprise Software Hit of the Year | WIRED
2016
- 2016-12-08Hands On With Microsoft Dynamics GP 2016 R2: Deploy System Database | azurecurve azurecurve
- 2016-12-05After Removing Fixed Asset Management Tables Add Entry To DB_Upgrade | azurecurve azurecurve
- 2016-12-05Hands On With Microsoft Dynamics GP 2016 R2: Series Index
- 2016-11-15Dynamics GP Essentials: General Ledger Journals with Analytical Accounting Details (with Drill Down Capabilities from Excel) –SQL Script
- 2016-11-10Dynamics GP Land: Dynamics GP FP: Can’t close Table! and FP: Couldn’t close table! error messages
- 2016-10-26Dynamics GP Land: Two lesser known SQL Server performance tips: Appropriate for Dynamics GP?
- 2016-10-26Table and Column Changes in Microsoft Dynamics GP 2016 R2 and Year-End Update – Microsoft Dynamics GP Community
- 2016-10-24Microsoft Dynamics GP 2016 R2 and Year-End Update upgrade: The Database Upgrade – Microsoft Dynamics GP Community
- 2016-10-03Dynamics GP Land: Dynamics GP GPConnNet.dll is not compatible with SQL Server high availability setup or DNS aliases
- 2016-08-08Update Table Reference with Canadian Payroll
- 2016-08-08Find SQL Trigger In All Databases | azurecurve
- 2016-08-03Find Column In SQL | azurecurve
- 2016-07-12Dynamics GP Essentials: Purchase Requisition Workflow History – SQL View
- 2016-07-05Microsoft Dynamics GP 2016 – Inventory All-in-One View – Microsoft Dynamics GP Community
- 2016-07-05Microsoft Dynamics GP 2016 – Sales All-in-One View – Microsoft Dynamics GP Community
- 2016-06-09Dynamics GP Land: Back to Basics: What is a SQL Server Instance Name?
- 2016-06-06Dynamics GP Essentials: Dynamics GP 2016 – Sales All in One View
- 2016-06-06Dynamics GP Land: The Mysterious Myth of SQL Server stored procedure header comments
- 2016-05-25Employee Self Service – Managers can View Employee Available Time – Microsoft Dynamics GP Community
- 2016-05-23Employee Self Service – Human Resource Attendance Time Available View – Microsoft Dynamics GP Community
- 2016-05-04Hands On With Microsoft Dynamics GP 2016 R1: Deploy System Database | azurecurve
- 2016-05-02Hands On With Microsoft Dynamics GP 2016 R1: Series Index | azurecurve
- 2016-04-13Microsoft Dynamics GP 2016 – The Database Upgrade – Microsoft Dynamics GP Community
- 2016-04-11Support for SQL Server 2005 ends Tuesday – are you ready? | PCWorld
- 2016-03-21Dynamics GP Land: Query the functional currency for all Dynamics GP company databases
- 2016-02-29Dynamics Confessions Blogspot: What?! Referential Integrity Checked on a Clear Data Table.
- 2016-02-29Dynamics GP Land: Trace database triggers using SQL Server Profiler
- 2016-02-29Dynamics GP Land: Updating a Dynamics GP binary database field in SQL Management Studio
- 2016-02-29Dynamics GP Land: Retrieving a value from every Dynamics GP company database
- 2016-02-15View To Return Sales Orders (Work Status) Requiring An Assembly | azurecurve
- 2016-02-09SQL Script To Bulk Alter Users With Logins | azurecurve
- 2016-02-03Creating a Microsoft SQL Server view from 2 Microsoft Dynamics GP Databases
- 2016-02-02Dynamics GP Essentials: Requisition Management – Data Flow and Associated Tables
- 2016-01-14Dynamics GP Land: Dynamics GP Error: Selected company is not configured as a company of the current system database
2015
- 2015-12-29Error Registering Table GL_Account_MSTR | azurecurve
- 2015-12-21Liberating the DBA from SQL Authentication with AD Groups – SQLServerCentral
- 2015-12-15SQL Trigger To Delete EFT Bank Information When The Vendor Is Deleted | azurecurve
- 2015-12-10Failure on the UPR00905 (Payroll Master Employee ACA) table: The conversion process encountered an error and the temporary table did not get removed. – Microsoft Dynamics GP Community
- 2015-12-10Dynamics GP Essentials: Mass Assign Items to Vendors – SQL Script
- 2015-11-24MR Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 2 – SQL Timeout
- 2015-11-24Dynamics GP Essentials: Vendor EFT Bank Details – SQL Script
- 2015-11-23Dynamics GP Essentials: Fixed Assets – Account Group (Part 2) | SQL Macro Generator
- 2015-11-23SQL View To Allow Customer/Item Link In SmartList Builder
- 2015-11-19SQL Error: “The query uses non-ANSI outer join operators”
- 2015-11-17SQL Script To Copy Tax Setup To A New Company | azurecurve
- 2015-11-17Dynamics GP Essentials: Purchase Order Receiving and Invoices Details (with Requisitions) – SQL Script
- 2015-11-16Security Tips in Microsoft Dynamics GP – Victoria Yudin
- 2015-11-16SQL Trigger To Automatically Enable Email Documents In Purchasing – All | azurecurve
- 2015-11-09SQL Trigger To Automatically Enable Email Documents In Purchasing – Remittance | azurecurve
- 2015-11-09Microsoft Dynamics GP Year-End Release 2015: Table and Column Changes in US Year-End Update – Microsoft Dynamics GP Community
- 2015-11-09SQL View To Return Purchasing Transactions With Multicurrency | azurecurve
- 2015-11-09SQL View For Payables Transaction Distribution Accounts | azurecurve
- 2015-11-04SQL Script To Return Functional Currencies For All Companies | azurecurve
- 2015-11-02Dynamics GP Essentials: SalesPerson and Sales Territory details – Customer Card and Customer Address Maintenance (Part 2) | SQL Correction Method
- 2015-10-28SQL View On Vendor EFT | azurecurve
- 2015-10-22Dynamics GP Land: eConnect Error: Voucher Number already exists in PM Keys Master Table PM00400
- 2015-10-22SQL Script To Set Budget Transaction History To Be Kept In All Companies | azurecurve
- 2015-10-19SQL View For Remittance Enabled | azurecurve
- 2015-10-13SQL View For Vendor Email Addresses | azurecurve
- 2015-10-12SQL View For Customer Item Link From SOP Transaction Line | azurecurve
- 2015-10-05Dynamics GP Land: Finding batches with errors across all Dynamics GP company databases
- 2015-09-10Dynamics GP Land: Unable to run SQL query on GP data with dates – Conversion of a varchar to a datetime error
- 2015-08-31The Dynamics GP Blogster: You receive “Could’n retrieve the list of available databases: The connection attempt failed” error when updating Management Reporter 2012
- 2015-08-24Dynamics GP Land: Using the Dynamics GP PM00400 table for Payables Imports
- 2015-08-17#GPPT What’s New: Database Validation, copying databases and upgrades | David Musgraves Winthrop Development Consultants Blog
- 2015-08-05Workflow 2.0 tables, what each one does, and what information you can get from them for reporting purposes. – Microsoft Dynamics GP Community
- 2015-07-14Dynamics GP – Knowledge Share: Dynamics GP SQL Password – Something Interesting must test it !!!
- 2015-07-08Dynamics GP Essentials: Document Attachment Error with GP 2015 R2 – “A Save Operation on table ‘coAttachMSTR’ has created a duplicate key error”
- 2015-06-29Hands On With Microsoft Dynamics GP 2015 R2: Install System Database | azurecurve
- 2015-06-29Microsoft Dynamics GP 2015 R2 – SmartList Designer View Workflow – Microsoft Dynamics GP Community
- 2015-06-24Hands On With Microsoft Dynamics GP 2015 R2: Series Index | azurecurve
- 2015-06-22Dynamics GP Essentials: Analytical Accounting Distribution Query Wizard “Login Failed for User” – Resolved with GP 2015 R2
- 2015-06-15Microsoft Dynamics GP 2015 R2 – Purchasing All-in-One View – Microsoft Dynamics GP Community
- 2015-06-09Dynamics GP Essentials: SmartList Designer Search Columns Error – “TableError. GetFromFieldDefinition() of form aaSmartlist “
- 2015-05-18Using the Support Debugging Tool to create user accessible SQL Scripts – Part 3 | David Musgrave’s Winthrop Development Consultants Blog
- 2015-05-18Microsoft Dynamics GP 2015 R2 Feature of the Day: SmartList Designer Create View – Microsoft Dynamics GP Community
- 2015-05-18Microsoft Dynamics GP 2015 R2 Featur of the Day: SmartList Designer View Workflow Type – Microsoft Dynamics GP Community
- 2015-05-18Dynamics GP Essentials: When Writing an SQL Query, Performance Really Matters. “Dynamics GP Custom Report – Practical Case”
- 2015-05-18Microsoft Dynamics GP 2015 – The Database Upgrade – Microsoft Dynamics GP Community
- 2015-05-13All in One Document View – Options – Microsoft Dynamics GP Community
- 2015-05-13Using the Support Debugging Tool to create user accessible SQL Scripts – Part 2 | David Musgrave’s Winthrop Development Consultants Blog
- 2015-05-11Microsoft Dynamics GP 2015 R2 Feature of the Day: All in One Document View – Filter – Microsoft Dynamics GP Community
- 2015-05-11Microsoft Dynamics GP 2015 R2 Feature of the Day: All in One Document View – Checkbox
- 2015-04-22Dynamics GP Essentials: “Unposted” General Ledger Journals with Analytical Accounting Details –SQL Script
- 2015-04-20Great SQL Script for getting which users have access to which accounts when using account level security. – Microsoft Dynamics GP Community
- 2015-04-16Install SQL Server 2014: SSRS Configuration for Microsoft Dynamics GP | azurecurve
- 2015-04-01Having both Purchase Requisition Approval and Purchase Order Approval workflow types active in the same company database for Microsoft Dynamics GP 2013 R2 and Dynamics GP 2015 in Workflow 2.0. – Microsoft Dynamics GP Community
- 2015-03-31Install SQL Server 2014: Series Index | azurecurve
- 2015-03-31Install SQL Server 2014: SQL Server Installation | azurecurve
- 2015-03-31Dynamics GP Land: Get GPConnNet to connect to SQL Server instance with a TCP port number using SQL Alias
- 2015-02-19Upgrade to Microsoft Dynamics GP 2015 fails on company table APR_BSSBEN02 – Microsoft Dynamics GP Community
- 2015-02-03Dynamics GP Essentials: General Ledger Journals with Multi Dimensional Analysis Details – SQL Script
- 2015-01-22SQL view for total payments to 1099 vendors in the prior year | Victoria Yudin
- 2015-01-19Dynamics GP Land: Installing missing Professional Services Tools Library stored procedures
- 2015-01-15Power Query for Excel: Combine multiple files of different file types « PowerPivotPro
- 2015-01-08ERP, Databases, Report Design and Business Intelligence: Actuals vs Budget using Tableau
- 2015-01-08Dynamics GP Land: Apparent bug in eConnect taSopSerial stored procedure for invoice with negative quantities
2014
- 2014-12-29The eOne Dynamics GP and CRM Blog: Tech Tuesday: Importing into Extender Tables
- 2014-12-23Dynamics GP Essentials: Pure “Bank Transactions and Transfers” with General Ledger Journal Details – SQL Script
- 2014-12-17Table and Column Changes in Dynamics GP 2015 – Microsoft Dynamics GP Community
- 2014-12-17The Dynamics GP Blogster: Microsoft Dynamics GP backups with Windows Azure Blob Storage Service – Follow up
- 2014-12-16The Dynamics GP Blogster: Microsoft Dynamics GP backups with Windows Azure Blob Storage Service
- 2014-12-16Dynamics GP Land: Executing SQL DDL scripts from a Dynamics GP VS Tools AddIn
- 2014-12-04Hands On With Microsoft Dynamics GP 2015 RTM: Series Index | azurecurve
- 2014-12-02SQL View To Select User, Company and Security Role Assignment | azurecurve
- 2014-12-02Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask
- 2014-12-01Management Reporter Tips and Tricks – 17. Web View “Go To” Option | Boyer & Associates
- 2014-11-19Red Gate books: SQL Server Transaction Log Management
- 2014-11-13Power BI and Tableau: Best Friends Forever « PowerPivotPro
- 2014-11-13Table and Column Changes in 2014 Year End Update – Microsoft Dynamics GP Community
- 2014-11-11Dynamics GP Essentials: Attachment Report – Vendor Card
- 2014-11-03Database Disabler returns the following error: You are not registered for the selected utility. – Microsoft Dynamics GP Community
- 2014-10-23Exploring Your SQL Server Databases with T-SQL
- 2014-10-13Upgrading Management Reporter 2012: Series Index | azurecurve
- 2014-09-29Dynamics GP Essentials: Purchase Order Receiving and Invoices Details – SQL Script
- 2014-09-15SQL view to verify unposted SOP transaction totals in Dynamics GP | Victoria Yudin
- 2014-09-09Importance of Recovery Model in SQL Server — DatabaseJournal.com
- 2014-09-08After restarting SQL Server, only sa user can log into Microsoft Dynamics GP – Developing for Dynamics GP
- 2014-09-08SQL view for easier General Ledger transaction searches in Dynamics GP | Victoria Yudin
- 2014-09-08Dynamics GP Land: Dealing with 1/1/1900 with GP and SQL Reports
- 2014-09-03FAQ Open apply table (PM20100) in Payables Management – Microsoft Dynamics GP Community
- 2014-09-02VBA: DUOS data stored in the wrong database after switching companies – Developing for Dynamics GP
- 2014-09-02Could the end of Microsoft Dynamics SMB ERP exams be a good thing? An alternative view urges focus on other channel issues | MSDynamicsWorld.com
- 2014-08-18Dynamics GP Essentials: TSQL Fun (Pivot Function) – Analytical Accounting Dimensions
- 2014-08-04Dynamics GP Essentials: Reconcile Check books to General Ledger – SQL Script
- 2014-07-31Dynamics GP Land: How will Dynamics GP Document Attach affect my database size?
- 2014-07-28Dynamics GP Land: Importing Dynamics GP AR Apply records using SQL
- 2014-07-21Dynamics Confessions Blogspot: Backup Withholding on 1099 Payments
- 2014-07-21Dynamics GP Essentials: Attachments Report
- 2014-07-17SQL view for Dynamics GP vendors with last activity date | Victoria Yudin
- 2014-07-16Dynamics GP Essentials: Payment Document Management – Post Dated Checks Report, SQL Script
- 2014-07-14Dynamics GP Land: Help!!! My Dynamics GP SQL Server is out of disk space!!!
- 2014-07-14Set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, or SQL Server 2012 – Microsoft Dynamics GP DBA
- 2014-07-09SQL view for Dynamics GP open year GL trial balance with month end balances | Victoria Yudin
- 2014-07-07Dynamics GP Land: Dynamics GP takes over 10 minutes to login or switch companies (aka Don’t blame Mekorma MICR)
- 2014-07-03Dynamics GP Land: SQL Server WHERE clause wildcards
- 2014-07-02Dynamics GP Land: Does Dynamics GP use the tempdb database? No? Yes? Prove it!
- 2014-06-16SQL Query To Determine Quantity To Order | azurecurve
- 2014-06-10Implementing Fastpath’s Config AD: Introduction & Index | azurecurve
- 2014-06-09Mohammad R. Daoud: Update Company ID field across all company database
- 2014-06-04Microsoft Dynamics GP 2013 R2 Feature of the Day: Encumbrance SQL Reporting Services Reports – Inside Microsoft Dynamics GP
- 2014-06-04Dynamics GP Land: Recommended Reading: Dynamics GP and SQL Server Connection Issues and Disconnects
- 2014-05-29Table and Column Changes in Dynamics GP 2013 R2 – Dynamics GP Support and Services Blog
- 2014-05-19Currency ID missing in the Currency Translation Default Exchange Table ID’s section of the Multicurrency Setup window – Developing for Dynamics
- 2014-05-14MICROSOFT DYNAMICS GP 2013 R2 – The Database Upgrade – Dynamics GP Support and Services Blog
- 2014-05-12Dynamics GP Land: Why is my Dynamics GP database growing / getting so large / taking up so much space?
- 2014-05-05Dynamics GP Essentials: Which are the Posting Accounts in my GP Company ! – SQL Script
- 2014-04-30Dynamics GP Essentials: Cost Layers Analysis – SQL Script
- 2014-04-02SQL Server 2014
- 2014-03-31Dynamics GP Essentials: Fiscal Period Setup – SQL Script
- 2014-03-24Dynamics GP Essentials: General Ledger Journals with Analytical Accounting Details –SQL Script
- 2014-03-20Dynamics GP Essentials: Reconciling Quantity on Hand – SQL Script
- 2014-03-19SQL view for Dynamics GP open year GL trial balance | Victoria Yudin
- 2014-03-19Web Client Wednesday: Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Series Index | azurecurve
- 2014-03-17Dynamics GP Essentials: Analytical Accounting GL Accounts and Dimensions Assignment Details –SQL View
- 2014-03-10The Ultimate Date Table–Revisited « PowerPivotPro
- 2014-03-10Weekly Dynamic: Excel Pivot Tables, Clear Old Items
- 2014-02-18Calendar Tables – SQLServerCentral
- 2014-02-03Dynamics Confessions Blogspot: TSQL – Fun with Dates!
- 2014-01-20Dynamics Confessions Blogspot: 2014 Payroll Tax Tables–how to fill out manually
2013
- 2013-12-30Weekly Dynamic: Dynamics Innovations Free Exchange Rate Feed
- 2013-12-02Rollback your SQL script w/o restoring the database
- 2013-12-02Understanding Microsoft Power BI – Self Service Solutions — DatabaseJournal.com
- 2013-12-02The Dynamics GP Blogster: Running Windows 8.x Business Analyzer app on a laptop with SQL Reporting Services
- 2013-11-18Recursive Querying in SQL Server – Developing for Dynamics GP
- 2013-11-13The eOne Dynamics GP and CRM Blog: Tech Tuesday: How to Add an Extender View to a SmartList
- 2013-11-06Quick Tip: Unusual behaviour when working with SQL Server from Dexterity – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2013-11-06Dynamics GP Essentials: Business Portal Requisitions – Approval Hierarchy SQL View
- 2013-10-28Dynamics GP Essentials: Business Portal Requisitions – Tables, and All Requisitions SQL View
- 2013-10-28Dynamics GP Land: When good backups just aren’t enough
- 2013-10-22Dynamics GP Essentials: HITB Essentials Series– HITB Reset Tool and SEE Tables
- 2013-10-16Dynamics GP Land: Year Over Year Comparison in SQL
- 2013-10-15SQL view for Dynamics GP sales quantities and amounts by item by site by month | Victoria Yudin
- 2013-10-14Access Database Engine Redistributable for FRx Migration Wizard | azurecurve
- 2013-09-30Dynamics GP Land: A most EPIC tale of troubleshooting a Dynamics GP SQL performance issue
- 2013-09-30Dynamics GP Land: Dynamics GP SQL Server Composite Primary Key Trivia
- 2013-09-30A Slicer and a Macro Walk Into a Bar: Filtering Multiple Pivot Tables With a Click of a Button | Dynamics Care Services
- 2013-09-17Power View and Power Pivot videos – Excel – Office.com
- 2013-09-09Dynamics GP Land: Technical Airlift Here We Come! SQL Tips and Tricks
- 2013-08-19Extending the Default eConnect Business Logic with ‘Pre’ and ‘Post’ Stored Procedures | MSDynamicsWorld.com
- 2013-08-1210 Myths about Backups in SQL Server – SQLServerCentral
- 2013-08-12How the Periodic tables are updated in Project Accounting for Microsoft Dynamics GP – Dynamics GP Support and Services Blog – Microsoft Dynamics GP – Microsoft Dynamics Community
- 2013-08-05Mastering the Microsoft Dynamics GP 2013 Web Client: An introspective view | MSDynamicsWorld.com
- 2013-08-01Updated: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2013-07-24SQL view for vendor yearly totals in Dynamics GP | Victoria Yudin
- 2013-07-09SQL view for Payables invoices originating from POP in Dynamics GP | Victoria Yudin
- 2013-07-02Mohammad R. Daoud: Update SQL Server Collation for a Clustered Installation
- 2013-06-24Dynamics GP Land: Not an eConnect Bug: taPMTransactionInsert Error 313: Tax table detail does not equal the tax amount
- 2013-06-17SQL view for sales quantities by item by site by month in Dynamics GP | Victoria Yudin
- 2013-06-10SQL view for SOP sales by customer by month | Victoria Yudin
- 2013-06-10The Dynamics GP Blogster: Microsoft SQL Server security roles and Microsoft Dynamics GP SSRS reports
- 2013-05-28Using Sparklines & Data Bars to Visualize Data in SQL Server Reporting Services Reports | Dynamics GP Insights
- 2013-05-22Using Maps to Visualize Data in SQL Server Reporting Services Reports | Dynamics GP Insights
- 2013-05-21How Maintenance Plans are a Big Plus for SQL Server Administration
- 2013-05-20Two ways to Export data from SSMS to Excel
- 2013-05-08Assign sequential numbers in SQL Server | Victoria Yudin
- 2013-05-02Mohammad R. Daoud: Duplicated GL Transactions between Work and Open tables
- 2013-04-30Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth
- 2013-04-29SSIS: Sequence Containers and Error 0×80004005 in SQL 2008R2 | Dynamics Care Services
- 2013-04-29Dynamics Confessions Blogspot: A Get/Change Operation on Table gpAppEnabled cannot find the table
- 2013-04-29SQL view for Current Payables Aging Details
- 2013-04-25Vote for Management Reporter View Subtotals and I’ll Buy You a Beer | FRxBuzz
- 2013-04-10Microsoft Dynamics GP 2013 – The Database Upgrade – Dynamics GP Support and Services Blog – Microsoft Dynamics GP – Microsoft Dynamics Community
- 2013-04-08Dynamics Confessions Blogspot: T-SQL 2012: CHOOSE and IIF
- 2013-04-08Dynamics Confessions Blogspot: T-SQL 2012: LAG & LEAD
- 2013-04-08Weekly Dynamic: Stored Procedures in Excel
- 2013-03-11Using CTEs with SQL Reporting Services & Dynamics GP | Dynamics GP Insights
- 2013-03-11Changing part of a string in SQL Server using REPLACE | Victoria Yudin
- 2013-03-04SQL view for sales quantities by item by site by year | Victoria Yudin
- 2013-02-26Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel
- 2013-02-21Dex – Illegal address for field ‘System Database Name’ exception – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2013-02-11Excel Blog – Open Excel workbooks in separate windows and view them side by side
- 2013-02-06Quick Tip: Accessing Third Party Table Buffers using anonymous tables – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2013-02-04From Data to Insight & Impact: Building a Manufacturing Summary with Power View
- 2013-01-29The Dynamics GP Blogster: Listing all eConnect Modified PRE and POST stored procedures
- 2013-01-24SQL view for Fixed Allocation Accounts in Dynamics GP | Victoria Yudin
- 2013-01-16Microsoft Dynamics GP 2013 and Tablets: Where is Business Analyzer? | MSDynamicsWorld.com
- 2013-01-10What happens if I update Payroll tax tables and…
- 2013-01-03Excel Based Table and Field Reference for Dynamics GP 2013
2012
- 2012-12-20Get the Microsoft Dynamics GP 2013 Table and Field Reference Now!
- 2012-12-19Dynamics GP Land: SQL Server Management Studio IntelliSense Doesn’t Work
- 2012-12-03DYNSA and SQL Maintenance for Dynamics GP
- 2012-11-27Error Restoring SQL Database | azurecurve
- 2012-11-06Creating Financial Reports with SQL Server Reporting Services | Dynamics GP Insights
- 2012-10-17Differences with SQL Transaction Rollback behaviour for eConnect for Microsoft Dynamics GP 2010 – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2012-10-11Further Update: Obscuring Table Data Fields using the Support Debugging Tool – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2012-09-26Using the Named System Database Feature for Microsoft Dynamics GP 2013 – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2012-09-18Dynamics Confessor Blogspot: When things go Wrong – Error registering table GL_Account_MSTR
- 2012-09-17Mohammad R. Daoud: Microsoft Dynamics GP 2013 – Named DYNAMICS Database
- 2012-08-30Creating a Dynamics GP Backup Plan | Dynamics GP Insights
- 2012-08-28SQL view for rolling 12 months of sales by item in Dynamics GP | Victoria Yudin
- 2012-08-27SQL view for Variable Allocation Accounts in Dynamics GP | Victoria Yudin
- 2012-08-27Understanding the Microsoft Access Database Engine Prerequisite – Dynamics Corporate Performance Management – Site Home – MSDN Blogs
- 2012-08-21Update: Encrypting Table Data Fields using the Support Debugging Tool – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2012-08-06Weekly Dynamic: Line Numbers in SQL Server
- 2012-08-02Encrypting Table Data Fields using the Support Debugging Tool – Developing for Dynamics GP
- 2012-07-23SQL view for commissions details in Dynamics GP | Victoria Yudin
- 2012-07-17Dynamic Future – Vote – Multiple Company Support in a Single GP Database
- 2012-07-12Email Functionality in Dynamics GP – Some Table Definitions
- 2012-07-05Dynamics GP Land: Report Builder 3.0 WITHOUT SQL Reporting Services?
- 2012-07-05SQL Script for Account Level Security – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2012-07-03The Dynamics GP Blogster: Extracting data from Microsoft Dynamics GP company databases using SQL Server FOR XML and XMLNAMESPACES
- 2012-06-12How To Recreate SQL Objects Using PSTL | azurecurve
- 2012-05-22Concatenating strings in SQL Server | Victoria Yudin
- 2012-05-15The eOne Dynamics GP and CRM Blog: Tech Tuesday – SQL Timeouts
- 2012-05-10Rebooting because of an Automatic Update does interrupt SQL job execution. – Microsoft Dynamics GP DBA
- 2012-05-09Microsoft Dynamics GP Discussion » SQL view for unpaid SOP Transaction with no. overdue days
- 2012-05-03SQL Error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2012-05-03RAID and Its impact on your SQL performance – SQLServerCentral
- 2012-04-26Getting data from ISV tables onto reports without needing to create alternate reports – Developing for Dynamics GP
- 2012-04-25How To Disable A Database Using PSTL | azurecurve
- 2012-04-23How to format Microsoft Dynamics GP SQL Stored Procedures – Developing for Dynamics GP
- 2012-04-19Dynamics GP Land: Clearing remembered / default login for SQL Server Management Studio
- 2012-04-10WAQAS BUTT – Microsoft Dynamics ERP’S Blog: SQL Server 2012 & Dynamics GP Compatibility
- 2012-04-09Free ebook: Introducing Microsoft SQL Server 2012 – Microsoft Press
- 2012-03-29Data Analytics with SQL Server 2012
- 2012-03-12SQL view for sales quantities by customer by item by year | Victoria Yudin
- 2012-03-01Winston-Salem SQL PASS Meeting « The Death of Reason
- 2012-02-29Dynamics GP – Learn & Discuss: GP Homepage Layout Mass Update – Thru’ SQL
- 2012-02-27Dynamics GP Land: Forecaster Database Transfer Tool Permissions
- 2012-02-22Script History Table and Procedures – Microsoft Dynamics GP DBA – GP Technical Blogs – Microsoft Dynamics Community
- 2012-02-22How to correct errors in the PM00400 keys master table in MS Dynamics GP. | MS Dynamics GP
- 2012-02-21Quick Tip: Copying larger amounts of data in SQL Server quickly
- 2012-02-20MS Dynamics Index 0 of array PM Transaction Abbreviation error. | MS Dynamics GP
- 2012-02-14Quick Tip: Copying small amounts of data in SQL Server quickly – Developing for Dynamics GP
- 2012-02-13Dynamics GP Land: Update Dynamics GP Notes Using SQL
- 2012-02-13eConnect error – The stored procedure doesn’t exist – Developing for Dynamics GP
- 2012-02-07Restoring A Database Without Encountering A Locking Issue | azurecurve
- 2012-02-06Dynamics Confessor Blogspot: Change the name of the SQL Server
- 2012-01-26SQL view for current Receivables aging in Dynamics GP | Victoria Yudin
- 2012-01-24SQL view for sales quantities by item by year | Victoria Yudin
- 2012-01-17How to configure SQL Profile Tracing using the Support Debugging Tool – Developing for Dynamics GP
- 2012-01-11SQL view for customer yearly totals in Dynamics GP | Victoria Yudin
- 2012-01-05SQL view for vendor yearly totals in Dynamics GP | Victoria Yudin
2011
- 2011-12-28Dynamics Confessor Blogspot: Beware the 2012 Tax Tables!
- 2011-12-20How To Change The SQL Server Backup Folder | azurecurve
- 2011-12-19Quick Tip: Passing Date and Time Variables to SQL Server – Developing for Dynamics GP
- 2011-12-15Standardize SQL Server backups and maintain existing job schedules
- 2011-12-15Quick Tip: Passing Variables to SQL Server – Developing for Dynamics GP
- 2011-12-12Automate SQL Server Monitoring with Email Alerts
- 2011-12-12SQL view to show monthly totals for Dynamics GP Vendors | Victoria Yudin
- 2011-12-12SQL Server Error: Cannot resolve the collation conflict – Developing for Dynamics GP
- 2011-12-06Granting Access and Binding Defaults when recreating SQL Tables – Developing for Dynamics GP
- 2011-12-06The Dynamics GP Blogster: Granting Access and Binding Defaults when recreating SQL Tables: a follow up
- 2011-12-05Dynamics GP Land: GP Developer Tip: List All Parameters for a SQL Server Stored Procedure
- 2011-11-307 Preventable Backup Errors
- 2011-11-28SQL Server stored procedure to generate random passwords
- 2011-11-17How To Rename A SQL Server | azurecurve
- 2011-11-16Do not use the DEX_ROW_ID table column in your Customizations and Integrations
- 2011-11-15Quick Tip: Using SQL to return the number of records in a Table – Developing for Dynamics GP
- 2011-11-14Creating SSRS Reports Using Common Table Expressions | Dynamics GP Insights
- 2011-11-07Fixing A Corrupt Account Index Master | azurecurve
- 2011-11-03Language settings for Windows client must match SQL Server Language – Developing for Dynamics GP
- 2011-11-01Selecting The Correct Microsoft SQL Server 2000 Collation For Microsoft Dynamics GP | azurecurve
- 2011-10-27Pivot Tables with SQL? The Sum of Payments Posted Per Vendor Per Month
- 2011-10-26About Dynamics, Development and Life: Dynamics GP Business Analyzer on a Windows Touch Tablet
- 2011-10-25SQL view for SOP email setup in GP 2010 | Victoria Yudin
- 2011-10-24Value of 0 is not valid for Selected Index (Analysis Cubes Install)
- 2011-10-10SQL view for bank deposits and receipts in Dynamics GP | Victoria Yudin
- 2011-10-10Mohammad R. Daoud: Dynamics GP Workflow Backup
- 2011-09-26The Dynamics GP Blogster: Year-to-year Inventory Margin Report using the PIVOT operator in T-SQL
- 2011-09-21Get Change Next operation on table GL_Account_Master Invalid Key « DynamicsGP.ie – Global Insights from Ireland
- 2011-09-15SQL Scripts–Vendor Invoice Pricing Discrepancy « Real Life Dynamics User
- 2011-09-14SQL Scripts–Invoices Coming Due Next Week « Real Life Dynamics User
- 2011-09-14SQL view for user activity in Dynamics GP | Victoria Yudin
- 2011-09-14SQL Scripts–SOP to POP Freight Analysis « Real Life Dynamics User
- 2011-09-12Dynamics GP Land: Mysterious eConnect Error: The stored procedure does not exist. Watch your schemas!
- 2011-09-08Using Derived Tables to Create SRS Reports for Dynamics GP | Dynamics GP Insights
- 2011-09-07SQL Scripts–Order Count–YTD By User « Real Life Dynamics User
- 2011-09-07Quick Tip: Best practice for using sum range table command – Developing for Dynamics GP – Site Home – MSDN Blogs
- 2011-09-06SQL Scripts–Order Count–Previous Week By User « Real Life Dynamics User
- 2011-08-30SQL view for sales by item by month | Victoria Yudin
- 2011-08-22SQL Script – Orders Needing Purchase « Real Life Dynamics User
- 2011-08-18Dynamics GP Land: Payroll 941 Mystery Solved (or The Case of Missing Table)
- 2011-08-16Excel Report Builder – bug in SQL views created – Blog – Kuntz Consulting
- 2011-08-15SQL view for sales by item by year | Victoria Yudin
- 2011-08-11Using Extender to Create SQL Views | Dynamics GP Insights
- 2011-08-10Dynamics GP – Learn & Discuss: Replicate Multi-Currency & Exchange Table Access Information From Existing Company
- 2011-08-10The Dynamics GP Blogster: SQL: Assigning Microsoft Dynamics GP Users to SSRS Database Roles
- 2011-08-10Dynamics GP Land: Reporting Puzzle (1 of 2)- Dynamics GP SQL Financial Trial Balances
- 2011-08-08Dynamics GP – Learn & Discuss: SQL Server Services – Do Not Set To “Automatic (Delayed Start)”
- 2011-08-04Quick Tip: Table Hierarchy Inconsistency Errors in Runtime Mode – Developing for Dynamics GP
- 2011-08-03Updated SQL Scripts and Downloads
- 2011-08-01Weekly Dynamic: Filtering a Pivot Table with a Formula – Technology
- 2011-07-11Use Dynamic SQL To Generate a Dynamics GP Login Macro | Aaron Berquist – High Dynamic Range
- 2011-06-08Stored Procedure as Data Source in PowerPivot – Issue & Solution – Microsoft Dynamics GP Learn & Discuss –
- 2011-05-24Getting the name of a month from the month number in SQL Server | Victoria Yudin
- 2011-05-23Dynamics GP Land: And a One, And a Two, SQL Report Security
- 2011-05-23The Dynamics GP Blogster: Upgrade Strategies for Microsoft SQL Server 2008
- 2011-05-23Mohammad R. Daoud: Empty “Table Name” when doing Import/Export for EFT File Format
- 2011-05-23Dynamics GP – Learn & Discuss: Analytical Accounting Menu Master Table (SY07110) Records Multiplying – Bug & Workaround
- 2011-05-19The Dynamics GP Blogster: Microsoft Dynamics GP Database Installation and Upgrade Statuses
- 2011-05-12Weekly Review: SQL Data Mining Add In.
- 2011-05-11Easier Administration: Discovering Free SQL Tools and Tips for Microsoft Dynamics GP | MSDynamicsWorld.com
- 2011-05-11Dynamics GP – Learn & Discuss: Getting Month Numbers between two dates in T-SQL
- 2011-05-09Weekly Dynamic: Why Won’t the SQL Transaction Log Clear?
- 2011-05-02SQL view for all GL transactions in Dynamics GP | Victoria Yudin
- 2011-05-02SQL View–Sales Document Holds « Real Life Dynamics User
- 2011-04-27Find databases where SQL Server log file is too large
- 2011-04-26SQL Script – Standard Cost Less Than Valuation Cost « Real Life Dynamics User
- 2011-04-06The eOne Dynamics GP and CRM Blog: New Feature: SQL Destination
- 2011-04-06Dynamics GP – Learn & Discuss: Changing a Smartlist Favorite’s visibility thru’ SQL
- 2011-03-31The Dynamics GP Blogster: Customizations for the View Indented Bill (bmViewIndentedBillInquiry) window failing for GP 2010
- 2011-03-31SQL view for last sale date of item | Victoria Yudin
- 2011-03-30SQL view for last sale by customer and item | Victoria Yudin
- 2011-03-08Dynamics GP Land: SQL Reporting Services and Dynamics GP and Report Models
- 2011-02-28Top Tips for Effective SQL Server Database Maintenance
- 2011-02-21The Dynamics GP Blogster: Microsoft SQL Server performance boosting settings for Microsoft Dynamics GP – Part 1
- 2011-02-15The Dynamics GP Blogster: Why shouldn’t I shrink my Microsoft Dynamics GP databases?
- 2011-02-10Excel Pivot Table – Filling Blank Cells
- 2011-02-07Creating Customer Invoices using Sql Server Reporting Services 2008 R2
- 2011-02-01SQL Server DNS Configuration
- 2011-01-31Change GP fiscal period names using SQL Server « Victoria Yudin
- 2011-01-20Tame Pivot Table Sequencing
- 2011-01-17Multiple SQL Views for Analytical Accounting
- 2011-01-11Validating SSN against High Group list from Social Security Administration for SQL Server
- 2011-01-04How to Speed up MS SQL Reporting Services on First Run
- 2011-01-03Year-End Closing: Backup And Backup Data
2010
- 2010-12-20An open operation on table XXX failed because path does not exist
- 2010-12-08Top 10 Secrets of a SQL Server Expert
- 2010-12-02Forecaster 7 and the amazing expanding Z_RAW table
- 2010-12-01Custom Stored Procedure to copy Dynamics GP business alerts from one company to another
- 2010-11-29SQL queries for fiscal years and periods in Dynamics GP
- 2010-11-24SQL Script for Posting Accounts in Dynamics GP
- 2010-11-23Granting Microsoft Dynamics GP user minimal access at the database level to setup additional users
- 2010-11-18Why do memory tables seem to be slower in Dexterity 11.0?
- 2010-11-11Spreadsheets: Why Pivot Tables Won’t Sum
- 2010-11-11Moving Dynamics GP databases to a new SQL Server
- 2010-11-09Wennsoft Table Reference
- 2010-11-08Dexterity: Cannot See Table Buffer Values in 10.0 SP5 or 2010 SP1
- 2010-11-08GL Reconciliation SQL Script – Payables and Receivables
- 2010-11-03Learning Dynamics GP Database Table Names
- 2010-11-03Backing up and Restoring data when recreating SQL Tables in Dynamics GP
- 2010-11-02Recovering missing eConnect stored procedures in Dynamics GP
- 2010-10-26Working with Temporary Tables in Dexterity with Dynamics GP
- 2010-10-18SQL Roles for DYNSA in Dynamics GP
- 2010-10-15SQL view for Dynamics GP Checkbook Register
- 2010-10-07How to free a marked batch without SQL in Dynamics GP
- 2010-09-29Dynamics GP Dynamics Database and Company Information.
- 2010-09-28SQL Server Express Failing To Start Revisited
- 2010-09-27SQL view for Payables apply detail and GL distributions in Dynamics GP
- 2010-09-21SQL Server Transaction Log Grows And Fills Up Drive
- 2010-09-14Coding specific dates in SQL Server
- 2010-09-13What are all those GPSFOINTEGRATIONID columns in some tables
- 2010-09-07A Dynamics GP Blast From The Past: Local Temp Tables
- 2010-09-02SQL view for Payables invoices originating from POP in Dynamics GP
- 2010-08-31FRx : Error 3617
- 2010-08-30Using T-SQL and recursive CTE to find related sales documents in Dynamics GP
- 2010-08-24Row by row analysis and execution with Cursors in SQL Server and Dynamics GP
- 2010-08-23Using SQL Server CLR stored procedures to integrate Microsoft Dynamics GP and Microsoft CRM: Configuring SQL Server and creating table triggers
- 2010-08-16Using SQL CLR stored procedures to integrate Microsoft Dynamics GP and Microsoft CRM
- 2010-08-11SQL view for asset account numbers in Dynamics GP
- 2010-08-10SQL view for Inventory Price Levels in Dynamics GP
- 2010-08-10Matched Tables – Viewing Open & History Documents on the same SmartList in Builder (just like the default Lists!)
- 2010-08-09Distribution Tables – adding the GL accounts to Builder Lists
- 2010-07-30Dex – Ctree temp tables versus SQL Server temp tables in Dynamics GP
- 2010-07-29Weekly Review: Auto Shrink for SQL Server is Evil
- 2010-07-29Finding Tables in Dynamics GP
- 2010-07-28How do I find out the password policy when using Advanced SQL Server Options in Dynamics GP?
- 2010-07-23Excel Report Builder Pivot Tables in Dynamics GP 2010 Pivot Tables
- 2010-07-22Analytical Accounting Error – After Restoring a Company Database
- 2010-07-21Renaming tables in Crystal Reports
- 2010-07-19SQL Temp Table Opening As Ctree in Dynamics GP
- 2010-07-19SQL view to show yearly totals for Dynamics GP Vendors
- 2010-07-15SQL Server Backups: A Public Service Announcement
- 2010-07-13Dynamics GP Backup? I don’t need no stinking Backup!
- 2010-07-07Getting Table and Field Data out of Dexterity Dictionaries in Dynamics GP
- 2010-07-06Use Extender Views, not Tables, in Dynamics GP
- 2010-07-06Dynamics GP Table Names from Leslie Vail
- 2010-06-28Updates to SQL view to show all GL distributions for AP transactions
- 2010-06-24Using ORDER BY in a SQL Server 2005 or SQL Server 2008 View
- 2010-06-24SQL View – Customers
- 2010-06-23SQL Script – Default Item Class GL Accounts
- 2010-06-23SmartList Builder based on SQL View not returning data
- 2010-06-22SQL Views – Active Chart of Accounts
- 2010-06-21SQL Scripts – Clear Users and Activity Locks
- 2010-06-15View Smartlists with SQL Tables
- 2010-06-15Dex – How to work with a passed anonymous table without changing table buffer contents
- 2010-06-14SQL DB Insert Trigger Breaks Dexterity Active Locking
- 2010-06-14Upgrading 150+ company databases
- 2010-06-03Microsoft SQL Server 2008 Upgrade Advisor
- 2010-05-28SQL Mail to be deprecated in Microsoft SQL Server 2008 R2
- 2010-05-14SQL view with security and SmartList details in GP
- 2010-05-03How to Use SQL Views
- 2010-04-21SQL Views – Inventory Mulitbin
- 2010-04-21Unexplained Temp Table Errors
- 2010-04-09SQL View – SOP to POP Links
- 2010-04-09IM Error – Argument ‘Index’ is not a valid value.
- 2010-03-31SQL Views – Inventory In All Locations
- 2010-03-31Formatting Dynamics GP Phone Numbers in a SQL Query
- 2010-03-16Improving Performance Accessing Tables in Dexterity
- 2010-03-12A Word About Backups
2009
- 2009-12-10Weekly Review: Support Administrators Console
- 2009-08-18SQL Maintenance Blooper
- 2009-07-13SQL Magic at Rose Business Solutions
- 2009-06-19How Does Check Links Work?
- 2009-06-15Transferring GP Data with SQL Import and Export Wizard
- 2009-06-04Dynamics GP Notes and Note Index
- 2009-05-26The Ins and Outs of Dynamics GP on SQL Server
- 2009-05-18Dynamics GP SOP Table Posting Statuses
- 2009-05-18SQL View with All Dynamics GP SOP Lines
- 2009-02-05SQL View to Show SOP POP Link
- 2009-01-26Logging and Recovery in SQL Server
- 2009-01-19Dynamics GP Bank Rec Table Info
- 2009-01-07SQL View to Show Customer Specific Pricing
- 2009-01-02SQL Server Management Studio for Beginners
2008
- 2008-12-17SQL Server 2005 SP3 is Now Available
- 2008-12-12Dynamics GP and Dex_Row_ID
- 2008-12-03Find Tables that are in a View
- 2008-11-25Simple SQL Exports to Text
- 2008-11-24Dynamics GP Fixed Assets Table Info
- 2008-11-14SQL Server Virtualization
- 2008-11-12Word Wrap in SQL Server Management Studio
- 2008-11-05SQL User Defined Functions
- 2008-11-04Running a SQL Command Against All DB’s
- 2008-10-28Table Import
- 2008-10-22Auto-Apply in AR via SQL
- 2008-10-22Automated GP Database Backups with SQL Express
- 2008-10-21SQL Saturday Orlando is this Saturday, Oct. 25
- 2008-10-17Dynamics GP SQL View to Show What Check Paid a PO
- 2008-10-13zDP_ Auto Generated Stored Procedures and Dynamics GP
- 2008-10-08SOP Table Info
- 2008-10-06More GP Table Info from Victoria Yudin
- 2008-08-26Technet Radio -Performance Improvements SQL 2008 Analysis Services
- 2008-08-25Proclarity and SQL Server 2008
- 2008-08-20SQL Saturday Orlando in October
- 2008-08-16MRP Sales Forecasting Tables
- 2008-08-144Penny 4 SQL
- 2008-08-10Database Maintenance for “Involuntary DBA’s”
- 2008-07-21Make Sure You Are Reading David Musgrave’s Blog
- 2008-07-11SQL Server Consolidation
- 2008-07-07Filtering in Excel 2007 Pivot Tables
- 2008-06-255 Free Hours of BI Training
- 2008-05-26SQL Server 2008 Slippage?
- 2008-05-06Reporting in Dynamics GP
- 2008-04-28SQL Resources
- 2008-04-10New MSDynamicsWorld Article on GP Backup
- 2008-03-29“Operation must use an updateable query” error in IM
- 2008-03-05TechNet Radio: Paul Randall, Kim Tripp SQL Server 2008
- 2008-03-03SQL Server Unplugged – FREE!
- 2008-02-28SQL Saturday Jax
- 2008-02-07SQL Saturday in Tampa – Feb. 16
- 2008-01-30Disable Home Page in Dynamics GP 10
- 2008-01-04GP 10+SQL 2005+Intercompany+2008 = Opportunity for Improvement
2007
- 2007-12-18For the Dynamics GP/SQL Junkie
- 2007-12-12Location Independent SSIS Packages
- 2007-12-06SQL Code – SOP Document Lock
- 2007-11-13Auto Shrink and SQL Index Fragmentation
- 2007-11-12SQL Saturday Follow Up
- 2007-11-01SQL Saturday November 10 in Orlando
- 2007-10-24SQL Server 2008: The Times They are a Changin’
- 2007-10-16Steve Gray Takes on SQL Optimization
- 2007-10-15Restore Your SQL Server DB Using Transaction Logs
- 2007-10-11Database Humor, God I’m a Nerd
- 2007-10-11GP 10 Table Reference – 1st Pass
- 2007-09-19SQL 2005 Upgrade Resource
- 2007-09-17Bleeding Edge – SQL 2008 CTP
- 2007-07-10Support for SQL 2000 SP3a Ending Today
- 2007-04-25SQL Maintenance Plans
- 2007-04-10Killer SQL/GP Resource
- 2007-03-28Kim Tripp’s Compilation of SQL Whitepapers
- 2007-02-22SQL Server 2005 Best Practices Analyzer Now Available
- 2007-02-20SQL Server 2005 SP2 is Now Available!
- 2007-01-31SQL Server 2005 High Availability on DotNetRocks