SQL Server tempdb database and disk space issues

As SQL administrator you are responsible not only for SQL Server part but also you are part responsible for the resources used by SQL Server and also how much resources are used and why. Who knows the activity on the server and have an idea of best practices on SQL Server can still be surprised by…

1

What is the estimate time for stopping an SQL Server Instance?

If the environment you administer is in production, it is quite possible that you wondered, at least once, how much time it will take if I have to stop the SQL Server Instance? And the answer is : depends. When you send the command to stop an SQL Server instance, the following steps are performed by the…

0

SQL Server Clustering and mirroring/log shipping

SQL Server provides a variety of high availability solutions that you could implement on your environment. Depending on your needs and of what type of hardware and software you dispose you can choose the best solution of high availability for your applications and productions.  With SQL Server you have the possibility even to combine different…

3

Execution plan for stored procedures chosen by SQL Server Database Engine

Execution plan for stored procedures chosen by SQL Server Database Engine I think everybody wondered why we have different execution plans chosen by the SQL Server Database Engine for the same stored procedure. You can find the answer in the following blog.  Because the SQL Server Engine does a recompilation, taking into consideration the current…

0

SQL Server Service Broker and AlwaysOn

SQL Server Service Broker provides native support for messaging and queuing applications in the SQL Server Database Engine. The reference documentation for Service Broker is included in the SQL Server 2012 documentation. This reference documentation includes the following sections: Data Definition Language (DDL) Statements (Transact-SQL) for CREATE, ALTER, and DROP statements Service Broker Statements  Service…

0

Reports of database activity information using SQL Server Management Studio

In one of my previous blogs I presented some of the tools you can use to start troubleshooting your performance issue or monitor the activity on your SQL Server . If the tools presented in that blog are a little too complicated for you, or you do not have the time to read and analyze…

0

Steps to troubleshoot SQL Server connectivity issues

Steps to troubleshoot SQL Server connectivity issues   When you have a connectivity issue with SQL Server you can use the following steps to verify some of the possible causes:  1. First you must identify the exact error message you receive : in SQL Server Management Studio or while starting a specific SQL Service; 2….

0

Receiving error message when trying to connect with Master Data Services Add-in For Microsoft Excel outside the domain where MDS is configured

Receiving error message when trying to connect with Master Data Services Add-in For Microsoft Excel outside the domain where Master Data Services is configured:   Error messages: If Windows Authentication is enabled on IIS side, you will receive the following error message on Excel side: “The HTTP request is unauthorized with client authentication scheme ‘Negotiate’….

4

SQL Server best practices for: installation, delete files after service pack installation, applications on instances and security

Questions and answers regarding SQL Server installation best practices, the files we can delete after a service pack is installed, user rights and how many instances are necessary for different application. 1. After you installed a Service Pack for SQL Server 2008 R2, is it possible to delete part of the files without altering the…

0

Master Data Services issue with ‘https’, error message:”[HttpWebRequest_WebException_Remoteserver] Arguments: NotFound Debugging resource strings are unavailable.”

Master Data Services issue with ‘https’, error message:”[HttpWebRequest_WebException_Remoteserver] Arguments: NotFound Debugging resource strings are unavailable.” Environment Description: Windows Server 2008 R2 x64 SP1 with SQL Server 2012 SP1 and IIS configured on the same machine. Master Data Services configured on the same machine.   Scenario: In the Master Data Services Configuration Manager – you create…

1