Home
»
Microsoft Dynamics GP
»
Microsoft Dynamics GP DBA
»
All Tags
»
SQL Server
Browse by Tags
Application Management
CBI
Code
Consolidated Business Intelligence
Data Warehouse
DBA
Dynamics
Dynamics GP
Dynamics GP Users Group
EDW
Enterprise Data Warehouse
FYI
GP
GPUG
GPUG SIG - BI and Reporting
GPUG SIG - DBA
Maintenance
Microsoft
Microsoft Dynamics
Microsoft Dynamics GP
Payroll
SQL
SQL Administration
SQL Code
SQL Maintenance
Related Posts
Blog Post:
Two ways to Export data from SSMS to Excel
John Lowther
One of the things a DBA does is run some sort of query in Microsoft SQL Server Management Studio (SSMS) and export the results for someone else to use in Microsoft Excel. So let us look into two of the ways to do just that. In both cases, we will be executing a select statement in SSMS, and to keep...
on
16 May 2013
Blog Post:
Deprecated Database Engine Features in SQL Server 2012
John Lowther
I do not know if everyone has seen this but you really should go take a look! You can find it here ==> Deprecated Database Engine Features in SQL Server 2012 Now, for me there is not too many things that list that make that much of a difference to me. Things change, that is life. The only constant...
on
28 Dec 2012
Blog Post:
Disk and File Layout for SQL Server - SQL Server Team Blog - Site Home - TechNet Blogs
John Lowther
Here is an excellent post on Disk and File Layout for SQL Server till later,
on
26 Dec 2012
Blog Post:
Finding out what the values mean in a static field in a Dynamics GP Database
John Lowther
Check out what one of my coworkers figured out! Additional Field Information Just goes to show to never get too old to learn Till later,
on
27 Nov 2012
Blog Post:
Getting entire databases from one point to another.
John Lowther
This is an addendum to the Getting Data from Point A to Point B series. When I first started this line of thought I was thinking more about SQL Queries, Triggers, etc.; however, as time when by I realized that there was an incredible need to get massive amounts of data from one place to another. ...
on
5 Sep 2012
Blog Post:
About Dynamics, Development and Life: Data Warehouse / Business Intelligence Solution for Dynamics GP–Part 1 Overview
John Lowther
MVP Jivtesh Singh starts a series of post on building a Data Warehouse using Kimball’s approach . Check out his first post of the series located ==> Data Warehouse / Business Intelligence Solution for Dynamics GP–Part 1 Overview And here is his second post of the series ==> Data Warehouse / Business...
on
22 Aug 2012
Blog Post:
GPUG DBA SIG (2012 - 09- 20) Topic Request
John Lowther
To enter your request for the list of topics to be voted on please take this quick three question survey located here . After the results are in I will post the list of general topics for everyone to vote for their favorite. You can register for the webinar here . till later,
on
21 Aug 2012
Blog Post:
Cleaning up after a Payroll Error
John Lowther
If during the Payroll Process the Payroll Clerk gets an error to the effect of "an Open Operation error, a Get/Change error, or a Save Operation error " Then give these scripts a try: --Find let us find out where the error actually is: -- I like to know what I am about to delete! Select * From...
on
20 Aug 2012
Blog Post:
SQL Script for Account Level Security - Developing for Dynamics GP - Site Home - MSDN Blogs
John Lowther
Check out Sivakumar's post on SQL Script for Account Level Security till later,
on
13 Jul 2012
Blog Post:
Notes on Performance for Microsoft Dynamics GP
John Lowther
When it comes to the performance of Microsoft Dynamics GP one of my favorite links is to the Optimizing and Maintaining Performance for Microsoft Dynamics GP 2010 white paper on Customer Source. But rather than just downloading the file I keep a link to it because it is updated as new things...
on
11 Jul 2012
Blog Post:
Deadlocks caused by Implicit Conversion
John Lowther
Sans SQL has a good post on how implicit Conversion can call deadlocks in SQL Server. Check out their post at Sans SQL: Deadlock - Implicit Conversion I would also like to thank Vaidy for letting us know about this in his post Implicit Conversions Causing Deadlocks in SQL Server . Till later,
on
29 Jun 2012
Blog Post:
Table Links in Extender - Microsoft Dynamics GP Support Blog - Site Home - MSDN Blogs
John Lowther
The Microsoft Dynamics GP Support Team takes a look at deleting Extender data when Dynamics GP data is deleted via Table Links in Extender .
on
31 May 2012
Blog Post:
In Recovery... | Using fn_dblog, fn_dump_dblog, and restoring with STOPBEFOREMARK to an LSN
John Lowther
Paul Randal digs into how to recover from someone dropping a table in your database. Read all about here In Recovery... till later,
on
30 May 2012
Blog Post:
Dynamics GP Land: Clearing remembered / default login for SQL Server Management Studio
John Lowther
If you have every had this problem then you know exactly how annoying it can be. Check out Christina Phillips post on getting rid of the default login in SQL Server Management Studio. Dynamics GP Land: Clearing remembered / default login for SQL Server Management Studio till later,
on
17 May 2012
Blog Post:
Single Insert with Union versus Multiple Inserts
John Lowther
This is an addendum to the Getting Data from Point A to Point B series. Wow, has it been that long since I first thought about writing this post? I wonder if work as many hours a week as I do has anything to do with that. J Anyway, as I promised longer ago that I care to admit, in this post we...
on
10 May 2012
Blog Post:
Rebooting because of an Automatic Update does interrupt SQL job execution.
John Lowther
I am not sure where I got it from, if it was incorrect information, if it is just outdated information, or if it is one of those "It Depends" things. But I have always been under the impression that a reboot caused by automatic updates would not occur if the SQL Server was busy. However as...
on
9 May 2012
Blog Post:
Problem with SQL Server 2008 and Exchange 2010
John Lowther
First please keep in mind that I know almost nothing about Exchange or how it works. The parts about Exchange that I will be discussing I am just paraphrasing from my Exchange Server Admin. Here is what happened: For years we have been using Exchange 2003 with no problems. And for years I have had SQL...
on
23 Apr 2012
Blog Post:
Backing up the Tail of the Log
John Lowther
One of the secrets to recovering that last piece of data that has changed since your last backup when disaster strikes is to backup the tail of the log. To find out multiple ways to backup the tail of the log when disaster strikes, check out this post from Pau Randall. In Recovery... | Disaster recovery...
on
17 Apr 2012
Blog Post:
Database Snapshots - Something's do not always work the way you think they should.
John Lowther
While there are a lot of good things about database snapshots, and a lot of good reasons for using them. Under certain circumstances they can cause problems. In his Blog ( In Recovery ) Paul Randall goes over a bug when you are reverting back from a database snapshot. You can get all the details from...
on
17 Apr 2012
Blog Post:
Some great scripts that I recently found
John Lowther
A few days ago I was searching for something and ran across this post from Jivtesh Singh . One of the scripts that he points out is a post from Mariano Gomez and lets you search for all tables for columns with the same name. Another one is a stored procedure to search the entire database for a specific...
on
10 Apr 2012
Blog Post:
Best Jobs in America 2011 - Money Magazine on CNNMoney
John Lowther
Hey Folks, Considering that I wear multiple hats were I work, like most people these days, this years list of the Best Jobs in America does a person good. You can check out the Best Jobs in America for 2011 here: Best Jobs in America 2011 - Money Magazine on CNNMoney Till later & hope to see you...
on
6 Mar 2012
Blog Post:
Changing your Dynamics GP - SQL Server Reporting Services from Native Mode to SharePoint Integrated Mode?
John Lowther
Like most people when I first setup SQL Server Reporting Services I used the Native mode. For awhile I have been toying with the idea of switching to SharePoint Integrated Mode but with so many things on my task list, this idea just kind of sits on the back burner. However, I was looking for something...
on
1 Mar 2012
Blog Post:
Resetting the users passwords after updating your test system
John Lowther
Ok, when you have multiple test servers and you have to refresh them more than just once in a while, or if you only have one test server but lots of users, resetting everyone’s password can become a pain point fairly fast. Now, mind you, I actually do like the way Dynamics GP handles security....
on
17 Feb 2012
Blog Post:
Where to put “my” stuff?
John Lowther
It has been a while since my last post as I have been really busy, but as I sit here during an install staring at a blue bar slowly going across the screen, I might as well multitask. So, as a DBA we are constantly getting this stored procedure from here or that one from somewhere else, all of which...
on
1 Feb 2012
Blog Post:
Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 7 – Putting it all together.
John Lowther
RECAP As the last post in this series, I wanted to recap and try to give a high level of what we wish to accomplish. If you remember on the first post we wanted to achieve two things, and that was not to hurt the performance of the Applications or of the BI Solution. In the second post , we...
on
16 Jan 2012
1
2