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...]
How to Get Names of All Tables in SQL Server
Here's a list of sql commands (T-SQL) to get the names of all tables, views, sprocs and triggers in SQL Server: If you want to see all objects within the database, use the following SQL command: Try this one to also include all column names info: Further Reading sys.objects (Transact-SQL) … [Read more...]