Browse by Tags
All Tags » SQL ( RSS)
-
|
A busy long weekend with various project deployments coming my way. The best pick out of those was AX Retail/POS Deployment as it had various components and various teams working on the deployment and it was a long one which spanned over more than 7 hours...
|
-
|
We have implemented Dynamics AX 2009 EP portal for one of our business. Users log on to the EP to create/edit/view their timesheets. Recently, we got this issue where suddenly the Edit timesheet page got disappeared. Whenever the user goes to view/edit...
|
-
|
This comes in handy when you need to check the SQL Server Version, Service Pack which your Enterprise is running, It shows the different versions and sp's for SQL Server rite from version 6.5 to SQL Server 2008, A handy link to be stored in your favorites...
|
-
|
SQL Server 2008 http://blogs.msdn.com/microsoft_press/archive/2009/11/16/free-e-book-introducing-microsoft-sql-server-2008.aspx Windows Server 2008 http://ow.ly/Hbjy
|
-
|
I thought I will blog about my recent experience on configuring Sharepoint 2010. So, here it goes.. a. Downloaded Sharepoint Server 2010 from Technet. If you are a Technet subscriber, you can download it from here https://technet.microsoft.com/en-us/subscriptions...
|
-
|
A few days ago, we were brainstorming on the reporting architecture for a new implementation. We had the following options on the table: 1. SSRS fetching data through EP Pros: Ax Security (Configuration key, Security key etc.) set at table levels can...
|
-
|
Recently, I was troubleshooting an issue related to user settings. i.e. There was a requirement to migrate the user settings from one environment to another. As we all know, User related setups for queries, forms, reports etc are stored in SysLastValue...
|
-
|
Issue: Recently, we had an issue with a production schedule report running in Dynamics AX PROD Environment, which was taking around more than 30-40 mins to display on the screen. The same report used to come in 2 mins or 3 mins time before. This is a...
|
-
|
Problem: Recently, I came across this issue when I had to restore a AX Database backup. Initially, I did copy the database which was of 25 gb size to the server where I wanted to restore, but I ran out of space. So the only option left me with was to...
|
-
|
A handy query to let you know the version with the service pack of the SQL Server you are running. Just log on to the instance, open the query editor and run this query select @@version Output - Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86...
|
-
|
Looking to query database metadata info like files, physical path, size, state etc. then you should try querying sys.database_files table. It will retreive the information relating to the current database from where you are querying (Assuming here that...
|
-
|
You may need your partnersource logon to view this. It shows which version of AX 3.0 and 4.0 are compatible with SQL versions of 2000 & 2005. https://mbs.microsoft.com/partnersource/resources/support/selfsupport/hottopics/axapta/AX_Database_SupportMatrix...
|
-
|
http://blog.sqlauthority.com/2007/01/31/sql-server-reindexing-database-tables-and-update-statistics-on-tables/
|
|
|
|
|
|
|
|