With many mistakes made by developers and DBAs alike firing a query in a wrong environment, there is one easy thing that can be done to alleviate this problem. That is by using the color coding on the status bar and you can set this up in the server registration on your SQL Server Management Studio (SSMS). This feature is so easy to overlook because many people just don't bother to look at the … [Read more...]
How to Create a SQL Server Agent Proxy Account
When you need to execute job steps under a specific security context, proxy account can be used to allow users who are not sysadmin to run them. Before you can create a proxy account, you first need to create a credential that needs to be linked later. This can be a window service account or a user's active directory id. Creating a Credential In the Object Explorer, expand Security … [Read more...]
How to Change Default Database Driver in Visio
Other than creating a flowchart, Microsoft Visio is also a very good tool for data modeling. The default database driver set on the software though is for Microsoft Access. Here are the steps to change the target database driver to SQL Server or any other available databases: Make sure you have other database driver you want to use installed on your computer first. Go to the Database menu, … [Read more...]
Upgrading SQL Express to Other Edition
In SQL Server 2012, upgrading edition is actually easier than ever since the data is stored under the same directory. Backup your data data. For default installation, the data can be found in the following directory: C:\Program Files\Microsoft SQL Server Have a local copy of SQL 2012 setup files as it will make the installation process much faster. Run setup.exe When SQL Server Installation … [Read more...]
Useful Scripts for SQL Server Performance Tuning
A couple of useful scripts of sql commands to aid performance tuning in SQL Server (T-SQL). This handy T-SQL script was from SQL Authority shows all queries that are currently running on your server. Any running query in the result can be killed by using the KILL command followed by the session id. Database I/O Information This one is taken from the book: Professional Microsoft SQL … [Read more...]