Showing posts with label Tools. Show all posts
Showing posts with label Tools. Show all posts

Friday 20 June 2014

SQL Server 2008 Extended Events SSMS Addin

 

Project Description
SQL 2008 Extended Events are a powerful new way of troubleshooting problems with SQL Server. One short coming is that there is no UI support for this new feature. The Extended Events Manager is a SSMS Addin to bridge this gap.
Originally an external application, this project has undergone numerous updates to get it to the point where it is now a SSMS Addin that integrates directly into Management Studio. The latest build of the external application is still available for download, but all new development efforts will target the SSMS Addin only.
Functionality:
  • View Extended Events Metadata for all Available Objects
  • View Event Sessions on a Server
  • Start/Stop Events Sessions
  • Create new Event Sessions
  • Alter existing Event Sessions
  • Drop Event Session
  • Script all operations
  • View information stored in targets for active Event Sessions
  • Configurable UI options that add flexibility to the application.
    • Ability to set Defaults to override the Library Event Session Options Defaults.
    • Provide options for Warnings on certain Events like Dropping an Active Event Session.
Coming Attractions
  • Add Predicate value and Target Option value validation to ensure that input values are compatible by datatype with the objects value datatype.
  • Convert GridViews to function closer to SSMS PBM Condition Grid.
SQL Server 2008 Extended Events Manager Current Bug List:

No currently known bugs exist. If you happen upon a bug, please log it in the Issue Tracker for this Project. All future bugs will be tracked through this tool only.
If you have a request for a feature, please open a discussion or a Issue in the Issue Tracker so that the request can be considered for inclusion in the project. A number of the most recent changes have been based on feedback that has been received from people regarding the tool and how it could be better. Many thanks go out to Adam Machanic for all of his recommendations and beta testing, without which the current state of the application would not exist.

http://extendedeventmanager.codeplex.com/

Friday 13 June 2014

Check-in Check-out options missing in solution explorer

Team Explorer can connect and shows the server and projects.  Source Control Explorer shows the source files and the state of check in/out.  But in Solution Explorer, there is nothing!  The red check marks are gone, the blue locks are gone.  Right click a solution or project or file and there are no source control options.

Solution:

http://social.msdn.microsoft.com/Forums/vstudio/en-US/58987d05-38d0-4056-82d7-f036adb7b2f3/lost-contact-with-tfs-in-solution-explorer?forum=tfsgeneral

Change Source Control prompts: "The current solution is associated with source control but is offline.  Would you like to completely disassociate the solution from source control?" , because you did not perform the go online in Source Explorer.

If you select  Yes, then the solution will not related with TFS server, in the .sln file, there will have no  the item: SccTeamFoundationServer = http://cathykong:8080/tfs/defaultcollection, when you go online, the solution will need to add the source control again, and not related with the Previous versions.

When you right click the solution name in the Source Explore, can you select Go Online item? If you can, you can perform such as the check in/out operations.

Offline means if you cannot connect the TFS Server, you can also edit your solution, and when you connect the TFS Server, you can go online and perform the check in /check out.

There is a video about work offline with TFS, you can see: http://msdn.microsoft.com/en-us/vstudio/bb898913.aspx

For more information, you can refer to

http://blogs.msdn.com/b/benryan/archive/2007/12/12/when-and-how-does-my-solution-go-offline.aspx

http://msmvps.com/blogs/p3net/pages/tfs-2010-in-offline-mode.aspx

http://msdn.microsoft.com/en-us/library/cc667405(VS.90).aspx

Azure AzCopy Command in Action

Azure AzCopy Command  in Action -  Install - Module - Name Az - Scope CurrentUser - Repository PSGallery - Force # This simple PowerShell ...