NAV Italian People Blog

Programming in C# Jump Start

Roberto Stefanetti — Mon, 20 May 2013 07:36:44 +0100

Microsoft Virtual Academy - Programming in C# Jump Start Course

https://www.microsoftvirtualacademy.com/training-courses/developer-training-with-programming-in-c

This developer training course covers C#, Microsoft’s managed C-style language for the .Net Framework. In typical Jump Start fashion, this session will be engaging and demo rich. Microsoft Technical Evangelist Jerry Nixon and the co-founder of Crank211, Daren May, provide sample after sample to show simple and complex techniques you can take back to your workplace.
Because this course loosely follows the criteria for exam 70-483, it is tailored for intermediary to seasoned developers looking to bulk up on C# or for a refresher on core concepts and features.

Instructors | Jerry Nixon | Microsoft Developer Evangelist; Daren May | President & Co-founder, Crank211

good for am 70-483: Programming in C#; Course 20483: Programming in C#

Sql Server Optimizer - nice tool

Roberto Stefanetti — Sun, 19 May 2013 11:38:08 +0100

nice Sql Server tool from arthurgraus

http://www.sqlserveroptimizer.com/

Blog

http://www.sqlserveroptimizer.com/category/blog/

Microsoft® SQL Server® 2012 Performance Dashboard Reports

Roberto Stefanetti — Sat, 18 May 2013 14:46:43 +0100

Microsoft® SQL Server® 2012 Performance Dashboard Reports

The SQL Server 2012 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature of SQL Server Management Studio.

The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a bottleneck is present, capture additional diagnostic data that may be necessary to resolve the problem.

Common performance problems that the dashboard reports may help to resolve include:

- CPU bottlenecks (and what queries are consuming the most CPU)

- IO bottlenecks (and what queries are performing the most IO)

- Index recommendations generated by the query optimizer (missing indexes)

- Blocking

- Latch contention

How To:

The information captured in the reports is retrieved from SQL Server's dynamic management views.

There is no additional tracing or data capture required, which means the information is always available and this is a very inexpensive means of monitoring your server.

"Reporting Services is not required to be installed to use the Performance Dashboard Reports"

Download@ http://www.microsoft.com/en-us/download/details.aspx?id=29063

Another great free tool from Microsoft !

Accessing Objects in Other Databases or on Linked Servers

Roberto Stefanetti — Fri, 17 May 2013 11:09:39 +0100

Accessing Objects in Other Databases or on Linked Servers

You can access objects outside the current database or server from Microsoft Dynamics NAV by linking to an appropriately defined view in the current database. You can create a view definition outside of Microsoft Dynamics NAV that accesses data on SQL Server linked servers, which can access heterogeneous data sources. This could, for example, involve performing a join of an Oracle table, a Microsoft Office Access table, or a Microsoft Office Excel spreadsheet.

To access objects in other databases or on linked servers you must comply with the following rules:

You must set the LinkedInTransaction table property to No in order to use a view referring to objects outside of the current database. The ability to modify data in these objects is dependent on the data providers that the objects refer to.
You must be a member of the db_owner fixed database role in the current database to access objects in other databases or on linked servers.
All security permissions for objects in another database or on linked servers must be granted outside Microsoft Dynamics NAV to the appropriate SQL Server logins.
If a linked object refers to a view that accesses objects that are stored in another database on the same server, this view must be treated as though it were accessing a linked server.
MSDN Link
- http://msdn.microsoft.com/en-us/library/dd355092.aspx

NAV 2013 RDLC Advanced Reporting Workshop

Roberto Stefanetti — Mon, 13 May 2013 21:28:39 +0100

@Microsoft Innovation Campus, NAV 2013 RDLC Reporting Workshop

3 days fulltime immersion on NAV 2013 Reporting

nice course, nice site..