Uncategorized
Tips
MAILING SQL SERVER
Below a post aimed to alert you if a volume is exceeded on your SQL Server, for example, the basic transaction data may exceed certain thresholds for that access your agent SQL SERVER, configure it in such a way as to send mails.
Audit SQL SERVER
You gave rights to a user, you want to know if that user has rights has spread another user, simple to make, use SQL SERVER Audit, create an audit specification
“SERVER_ROLE_MEMBER_CHANGE_GROUP”
You use both nodes Audit (audit and Create output formatting) & Specification (Create the specification)
Link : https://technet.microsoft.com/en-us/library/cc280500(v=sql.105).aspx
For your security management of your database, choose the concept of Role personalized, permission on a schema, add users to your role (Just as it would have been done with the Principal, Identity, Permission, Claims in C # ). Associating the scheme now to the role and not to different users.
Policy Management & Tips
It is interesting how implement code standards for stored procedures in Sql Server, stored procedures system are prefixed with “sp_”, for our user stored procedures, let the prefix of “usp_”, this is done with Policy Management (see SSMS – the object explorer, root).
Right-click on Policy Management and select New Condition, Type a name and condition as well as the body of your condition, we have decided to select the Name filter expression LIKE (‘usp_%’).
The next step is to create a policy associated with this codition, right-click Policy Management and select New Policy, select the Check Condition list, the condition created previously, the evaluation mode must be set to “On change: prevent prevention “, the default mode is” on Demand “and policies can not be enabled in this mode, for the Target, make sure you select all the databases and all stored procedures.
SQL Server – Slow Finish
As part of optimizing your SQL queries, if you want to line of code to include the execution plan, drag this instruction before execution.
SET STATISTICS SHOWPLAN_XML ON
If you want to optimize the recovery of your data in an environment with a default isolation level of Read Committed or SERIALIZBLE, slide this instruction before execution.
SET TRANSACTION ISOLATION LEVEL SNAPSHOT
As part of query optimization, you can associate a clean SQL query execution plan for you so to override the behavior of the query optimizer, see reference Plan in SQL Server Management Studio, you can create your SEEK FORCE clauses on your favorite index etc.
link : https://technet.microsoft.com/fr-fr/library/bb895390(v=sql.105).aspx
You can sometimes just be an update statistics 🙂
For the database novice, the positioning of the index is very important and is based on real data collecting tools (Production Environment)
As for the SQL Server after try: Database Engine Tuning Advisor, included in SSMS since the 2012 version.
GC.Collect
Tips Net
Below is a set of frequently asked questions as part of a .Net development platform, this post is also inspired some topics discussed in the Microsoft Best Practise
How to validate the compliance of a development compared to an architecture with a Build? (Ultimate License Requirements)
Create diagram Layer empty, move layers from solution on diagram and add dependencies, Create Gated CheckIn Build (Based on Shelveset), and in arguments of Build add : /p:ValidateArchitecture=true
How to detect copy and paste source code? (VS Prerequisites 2013)
Use Analyse Solution for Code Clones available under the section ANALYSIS
How to force the update of SSRS reports in a TFS platform (available under the Portal Server )?
Access to Administration console TFS, select Reporting tab, click on Start Rebuild link
Diagnosing a proxy TFS source control ?
Use web service ProxyStatistics available on application layer
GC.Collect
Tips .Net
Below is a set of frequently asked questions as part of a development .Net platform associated with TFS infrastructure, this post is also inspired on topics of Best Practise Microsoft:
How to set the distribution of a series of tests as they run?
Define Weighting property of test agent
How to reuse test cases fairly easily?
Use the Clone feature Test Plan on a root test suite
How to configure an access TFS url for your site?
Using TFS administration console and set the property in the section URL Notification Change URIs
How to recover accidentally deleted files in TFS Source Control?
Go to the Tools section, select Options, and click the link Show deleted items in the Source Control Explorer, right-click and select the option Undelete
How to export a complete test case suites beyond WIQL requests?
Use Apis Test Management, below some snippets to operate.
List the active test plans with filter end date
ITestPlanCollection testPlanCollection = projet.TestPlans.Query("Select * from TestPlan where PlanState = 'Active' AND EndDate < ‘2015-10-22’ ");
Retrieve the results of the execution of a test case
ITestManagementService testManagementService = teamProjectCollection.GetService<ITestManagementService>();
// Get run
IEnumerable<ITestRun> testRunList = testManagementService.QueryTestRuns(string.Format("select * From TestRun where TestRunID={0} AND IsAutomated=0", runId));
// Get first
ITestRun testRunTarget = testRunList.FirstOrDefault();
//Get results
ITestCaseResultCollection restCaseResultCollection = testRunTarget.QueryResults();
How Builds interrupt for a change process and run them later, once the finished modification?
Pausing set the property on the General tab of the Build definition, the builds are accumulated in a queue processing
To Build Not Finished
- ← Previous
- 1
- 2
