Setting for Recently Used Files in SQL Server Management Studio
I noticed in SSMS that there is the ability to show recently used files. In this tip we cover how this value can be set to show more or less files.
Biography Jugal Shah is the founder of SQLDBPool.com, where he is writes articles on SQL Server Administration and Development. Jugal has 8+ years of extensive experience in SQL Server Database administration and development. Jugal has worked on SQL Server 2000, 2005, 2008 and 2008 R2. In his current assignment, Jugal is managing large critical databases. His expertise is in database security, performance tuning and implementing high availability solutions. He can be contacted at jugal.shah@sqldbpool.com. He has been recognized as a SQL Server MVP since 2010.
- MSSQLTips Awards: Trendsetter (25+ tips) - 2013
Resolving could not open a connection to SQL Server errors
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.
Steps to clear the server list in SQL Server Management Studio
Generally we connect to several SQL Server instances. Once connected successfully, this server history is shown in the server connection drop down list. In some cases we might have similar names for servers as such as using P for production, D for Devel
Step By Step SQL Server Log Shipping
In this tip we walk through the steps to setup SQL Server Log Shipping.
Enabling IntelliSense and Refreshing IntelliSense Data in SSMS 2008
There may be times when IntelliSense in SQL Server Management Studio 2008 is not working or does not display the latest schema changes. In this tip we look at a how to check the status and how to update the IntelliSense data.
Different ways to secure the SQL Server SA Login
What are the different ways to secure the SA login? Everyone is aware of the SA login and its administrator rights, so it is very risky if some unwanted users try to use the SA account or hack the SA account. It is also not advisable to use the SA account
How to check SQL Server Authentication Mode using T SQL and SSMS
Many times developers want to put logic into their code or SSIS/DTS package to check the SQL Server authentication mode. In this tip we take a look at a couple of ways that this can be done.
New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string
Many times we want to split a string into an array and get a list of each word separately. The sys.dm_fts_parser function will help us in these cases. More over, this function will also differentiate the noise words and exact match words. The sys.dm_fts_
Issues with Run As to Start SQL Server Management Studio with a Different Login
As a best practice in the industry, a DBA often has two logins that are used to access SQL Server; one is their normal Windows login and the other is an admin level login account which has sysAdmin rights on the SQL Server boxes. In addition, most of the
SQL Server Login Issue With Default Database
Every once in a while you may run into an issue where a user cannot login to SQL Server, because the logins default database may not be available. This could be for several reason such as that database was dropped, the database may be corrupt, the databa
Start, Stop, Pause and Query Windows SQL Server Services Remotely
Sometimes SQL Server services or any other Windows service does not start due to some issue after a server reboot. When you try to login to the server you find that you do not have remote login rights to that server or remote login is disabled for that se
SQL Server restart validation checklist
Many times there is the need to restart the SQL Server services, this could be a reboot of the server after patching, service pack installation or due to some other reason. Sometimes we may face issues after the restart for example the SPN is not register
Monitor, Start and Stop SQL Server services using xp_servicecontrol
As you know SQL Server runs using a bunch of different services in order for it to operate. These can be monitored, started and stopped using SQL Server Configuration Manager or Windows Services, but this is not always the most convenient way of checking
Remotely Shutdown, Restart or Log Off the local or network computers
When installing a SQL Server cluster, Services Packs, Hotfixes, etc.. there may be a need to reboot both the nodes for changes to take affect and to reboot the server we have to login to each node which is time consuming. Also, there may be a time when yo
Terminal Server has Exceeded Maximum Number of Allowed Connections
Learn how to still make RDP connection with error Remote Desktop Error terminal server has exceeded the maximum number of allowed connections.
Insert Extended Characters into a SQL Server Table Using OSQL and TSQL
The OSQL utility uses ODBC to communicate with SQL Server. The user’s problem is that the ODBC driver he is using to connect to the database is performing translations on the character data in the T-SQL script. Extended characters, which are not in the st
SQL Server Database Migration Checklist
Many times we get requests to migrate a single user database or multiple user databases to different server. At the time of migrating databases, there are chances that we can miss some important steps. In this tip, I cover tasks that should be followed w