PREMNAIR'S Blog

"..Unnatural work produces too much stress.."

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

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.

Few report examples

May 20, 2012 Posted by | Microsoft, Performance Dashboard, Software, SQL Server | , | Leave a comment

Microsoft SQL Server 2012

Editions overview

The SQL Server 2012 Editions have been streamlined to better align with how customers are deploying applications and solutions.  SQL Server 2012 will be released in 3 main editions*:

  • Enterprise for mission critical applications and large scale data warehousing
  • Business Intelligence, a new product edition, providing premium corporate and self-service BI
  • Standard for basic database, reporting and analytics capabilities

Refer to Datasheet and FAQ for more details

Top Features

  • AlwaysOn Availability Groups
  • Windows Server Core Support
  • Columnstore Indexes
  • BI Semantic Model
  • User-Defined Server Roles
  • Enhanced Auditing Features
  • Sequence Objects
  • Enhanced PowerShell Support
  • Distributed Replay
  • PowerView
  • SQL Azure Enhancements
  • Big Data Support

 

 

 

May 8, 2012 Posted by | Microsoft, Microsoft Azure, Software, SQL Server | , , | Leave a comment

SQL Server Code Name “Denali”

 SQL Server Code Name Denali‖ is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud backed by mission critical confidence. 

Extend the reach of data virtually anywhere across server and/or cloud with expansive developer technologies, Enable new scenarios with SQL Azure DataSync, a cloud service that provides bi-directional data synchronization between databases across datacenter and cloud,  Provide a consistent and open data-feed to power multiple user experiences across the web.

 

SQL Server code name “DENALI” CTP3 ..click here to download it

SQL Server code name “DENALI” Datasheet..download here from Microsoft

August 9, 2011 Posted by | Cloud, Microsoft, Software, SQL Server | , | 1 Comment

Elcome International – Productivity goes up using latest Microsoft Technology

As a system integrator, My company, Elcome is well aware of the technologies available to make our clients lives easier…The deployment of Microsoft Dynamics has also had a major impact on the company’s ability to operate. “One big area that we’ve been able to focus on is reporting, in terms of KPIs and business intelligence. There have been a lot of advances in Dynamics and the supporting tools to make it easier to produce different types of reports, and the ability to allow end users to customise, specifically things like SQL reporting services that are part of SQL 2008. We were using an old version of Microsoft Dynamics GP. Two versions old in fact,” we realises. “When we upgraded to the latest version – and I think we were one of their first customers to go live with the latest version which is Microsoft Dynamics GP 2010 – we also moved to the latest versions of all the underlying technology. That includes the latest version of Microsoft SQL Server 2010. We’ve also moved from 32-bit to 64-bit servers. Everything is now running on 64bit hardware and software.” – explains executive director at Elcome International, Jimmy Grewal…more information read the following article published by ITP publishers on ACN Magazine By Ben Furfie Published May 10, 2011, May 2011 issue..click here to read more

June 1, 2011 Posted by | Active Sync, Articles, Dynamics CRM, Dynamics GP, Exchange Online, Exchange server 2010, GreatPlains 2010, Licensing cloud services, Microsoft, Office, Office 2010, Office 2011, Sharepoint 2010, Software, SQL Server, Terminal Server, Windows 7, Windows 7 phone, Windows phone, Windows Server 2008 R2 | , , , | Leave a comment

Microsoft® SQL Server® 2008 R2 SP1 Community Technology Preview Feature Pack

The Microsoft® SQL Server® 2008 R2 SP1 Feature Pack CTP1 is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. It includes the latest versions of:

  • Redistributable components for Microsoft® SQL Server® 2008 R2 SP1 CTP
  • Add-on providers for Microsoft® SQL Server® 2008 R2 SP1 CTP

Note: Some components in the Microsoft® SQL Server® 2008 R2 SP1 CTP Feature Pack of SQL Server® have certain Internet-enabled features, including the Customer Experience Improvement Program and Error and Usage Reporting component, enabled by default to help us identify and address issues that you may encounter while using SQL Server®. For more information and instructions on how to disable these features, see the SQL Server® Privacy Statement

Note:Some components in the Microsoft® SQL Server® 2008 R2 SP1 CTP Feature Pack of SQL Server® have two different methods to complete the installation process:

  • Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.
  • Un-attend Installation – this is a DOS command Line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.

More info click here

April 30, 2011 Posted by | Microsoft, Software, SQL Server | , | Leave a comment

Microsoft Dynamics Greatplains 2010 R2 Feature list

This conference, has been on March 1–3, 2011 at the Microsoft Fargo Campus, which provide insight, skills and knowledge that will help move the business forward..and its for Microsoft Partners only

Highlights include:

  • Interactive concurrent sessions – learn more about the solution from the Microsoft Dynamics GP team
  • Roundtable discussions – visit with a small group on a variety of topics
  • ISV Expo and reception – learn about the latest add-on solutions

Agenda as follows

Lot of thing happen in this conference. More info, Read David Musgrave Blog and Mariano Gomez Blog

The Road Map itself will give you how the GP future looks like…can’t wait to get hands on…

One of the good article about the The Evolution of the Microsoft Dynamics GP Roadmap from Mariano Gomez, Click here to read it

Again the coolest part is Microsoft Dynamics GP “12″  will have a light deployment client as well as the current rich client, a web based client which will be capable of reproducing any Dexterity based window in an browser….cool naa..can’t wait to get hold of it..

I’m still wondering, when are they going to integrate the Active Directory integration of GP !!!

Here are some of the feature list of GP 2010 R2 highlighted in this conference

Waiting for the release!!!

March 6, 2011 Posted by | Dynamics GP, GreatPlains 2010, Internet Explorer, Microsoft, Software, SQL Server | , , , , | Leave a comment

Customization – Quality vs On Time

A good blog from my colegue..I agree to that there should be customization quality, so that the upgrades/rollups are easy and the time comes after. Read more

Clicke here Vaidy Mohan’s Greatplains Blog

Enjoy!!!

January 15, 2011 Posted by | Analytical Accounting, Dynamics GP, Field Service, GreatPlains 10, GreatPlains 2010, Microsoft, SQL Server, Visual Basic | , | Leave a comment

Great Plains 2010 gone live in 15 days!!!

Attend a Microsoft Dynamics GP 2010 Launch Event – The new way to do business

This year was a challenging year for us when it comes to ERP. Microsoft GP 8, we moved to GP10 and Microsoft released Great Plains 2010 and we decided to move to GP2010 because of the new features and collaborations. In 15 days we achieve this task by pulling the data from GP10 database, which is SQL2008 to GP2010 database. 15days with major customization on field service module, New codings on Analytical accounting and our in-house team is able to manage it well, within the time frame..and we are using all the below modules as well…

Now we are in Great Plains 2010…Congratulation to our team

October 12, 2010 Posted by | Analytical Accounting, Dynamics GP, Field Service, GreatPlains 10, GreatPlains 2010, Microsoft, New Service Pack, SQL Server, Windows Server 2008 R2 | , , , , | Leave a comment

Why can’t I run Microsoft Dynamics GP via ODBC over a WAN?

GP2010 beautiful article…from David Musgrave…click here to read more

July 28, 2010 Posted by | Dynamics GP, GreatPlains 10, GreatPlains 2010, Microsoft, Software, SQL Server | , | Leave a comment

Great Plains 10 -Analytical Accounting Error

This message was quite annoying when my colleague created a Test Company in GP10 and restored a Production DB for R&D and Testing purpose. Analytical Accounting windows didn’t get opened and was throwing the following error message: There were several articles which cautioned / warned off from restoring only Company DB, which he is quite aware of. Because restoring another Company’s DB on to a Test Company will not have any issues unless it has got some products, like AA, depending heavily and real-time on DYNAMICS DB.

 

Read more..click Vaidy’s blog

July 22, 2010 Posted by | Analytical Accounting, Dynamics GP, GreatPlains 10, GreatPlains 2010, Microsoft, Software, SQL Server, Visual Basic | , , , | Leave a comment

Follow

Get every new post delivered to your Inbox.

Join 420 other followers

%d bloggers like this: