Search: none
Add a search phrase to search resource page titles and descriptions. Different keywords are ANDed with tags.
 

MSDN Archive

Target and filter your gallery search using the following dynamic dialogues.
1-7 of 7Resources < Previous 1 Next >
Resource Page Name and Description Current Release
Take admin rights to your local SQL Server Express with a simple command-line script. This command line script allows any user to easily add themselves to the sysadmin role of a local SQL Server i...
Take admin rights to your local SQL Server Express with a simple command-line script. This command line script allows any user to easily add themselves to the sysadmin role of a local SQL Server instance. The user must be a member of the local Administrators group, or have access to credentials of a user who is. The script is most useful when a developer tries using SQL Server 2008 Express that was installed by somebody else. In this situation the developer won't have admin rights to the SQL Server 2008 Express instance, since by default only the person installing SQL Server 2008 is granted administrative privileges. This script fixes the problem in a single click! WARNING: This script will restart a SQL Server instance (by default, SQLEXPRESS). All active connections to this instance will be lost. It should not be used against production servers.
Popular tags: SQL Express, SQL Server, Project Server 2010, SQL Server 2008, SQL Server 2008 R2, SQL Server 2005, sqlexpress
Downloads: 0 | Started: Feb 24 2010  | Contributors: 2
SQL Server Master Data Services Employee Sample Model
SQL Server Master Data Services Employee Sample Model
Popular tags: SQL Server 2008 R2, SQL Server, Master Data Services
Downloads: 0 | Started: Apr 29 2010  | Contributors: 1
Version 1.0
Apr 29 2010
SQL Server Master Data Services Account Sample Model
SQL Server Master Data Services Account Sample Model
Popular tags: Master Data Services, SQL Server, SQL Server 2008 R2
Downloads: 0 | Started: May 3 2010  | Contributors: 1
Version 1.0
May 3 2010
SQL Server Master Data Services Model Deployment API Sample The .zip file contains a sample console application illustrating the use of common operations of the model deployment API. To install...
SQL Server Master Data Services Model Deployment API Sample The .zip file contains a sample console application illustrating the use of common operations of the model deployment API. To install the sample: 1. Download and expand the .zip file to extract the Visual Studio solution and the readme. 2. Follow the steps in the readme to build and run the sample.
Popular tags: SQL Server 2008 R2, SQL Server, Master Data Services
Downloads: 0 | Started: May 11 2010  | Contributors: 1
Version 1
May 11 2010
The samples environment includes ReportViewer samples that highlight the features of the ReportViewer controls in Visual Studio, as well as demonstrate how to implement the typical scenarios using ...
The samples environment includes ReportViewer samples that highlight the features of the ReportViewer controls in Visual Studio, as well as demonstrate how to implement the typical scenarios using the ReportViewer controls.
Popular tags: AJAX, ASP.NET, SQL Server, SQL Server 2008 R2, SQL Server 2008, Reporting Services, ReportViewer
Downloads: 0 | Started: Sep 22 2010  | Contributors: 1
This GUI tool will help users determine whether the SQLVDI.DLL is functioning correctly and where you need to concentrate your troubleshooting efforts in case of SQL backup/restore operations are f...
This GUI tool will help users determine whether the SQLVDI.DLL is functioning correctly and where you need to concentrate your troubleshooting efforts in case of SQL backup/restore operations are failing due to VDI errors.
Popular tags: VDI, VSS, restore, SQL Server 2008, SQL Server 2008 R2, SQL Server 2005, SQL Server
Downloads: 0 | Started: Oct 22 2010  | Contributors: 2
SQLBackupSimv2.0
Jun 18 2011
Query Hash Statistics collects Microsoft SQL Server query performance statistics and uploads the data to a central warehouse. The solution also includes a set of reports to analyze and visualize t...
Query Hash Statistics collects Microsoft SQL Server query performance statistics and uploads the data to a central warehouse. The solution also includes a set of reports to analyze and visualize this data within SQL Server Management Studio (SSMS). Query Hash Statistics differs from most other query cost analysis tools in that it builds on the "query fingerprint" and "query plan fingerprint" features that were added in SQL Server 2008. These features make it possible to calculate the cumulative cost of all executions of a query, even when the application doesn't parameterize its queries. A solution like Query Hash Statistics that builds on these features can do low-overhead query cost monitoring with a degree of accuracy that was impossible in prior releases of SQL Server. Because the solution relies on new SQL engine features that were added in SQL Server 2008, it only works with SQL Server 2008 and later. Source code is included, to demonstrate how to build similar solutions. In addition to highlighting the engine's query and query plan fingerprint features, the project shows how to use extensibility features in Data Collector and SSMS. By following the patterns demonstrated in this project, you can learn how to: * Use the SQL Server "plan fingerprint" and "query fingerprint" features to identify cumulative query cost without a profiler trace. * Use Data Collector to upload data from SQL Server Dynamic Management Views (DMVs) to a central management database. * Build reports that can be hosted within SQL Server Management Studio (SSMS) to analyze the data in your central management database.
Popular tags: Performance, SQL Server, T-SQL, SQL Server 2008 R2, SQL Server 2008
Downloads: 0 | Started: Nov 3 2010  | Contributors: 2
QueryHashStats v0.14
Feb 22 2013
Updating...
Page view tracker