SQL Matters Home

Popular pages

• Adding a db_executor role - SQLMatters

  SQL Server has several fixed database roles such as db_datareader and db_datawriter, which grants the user read and write access respectively to all the tables in the database. Curiously there is no r...

• SQL Matters Home

  SQL Server articles, tips, information, blogs, quiz questions and other information for developers, architects and DBAs. This includes SSIS, SSRS and SSAS (Integration Services, Reporting Services and...

• Amazon RDS - Common Issues with native SQL Server backup and restore - SQLMatters

  In my introductory article I outlined details of how to create and restore SQL Server backup files to and from on-premise SQL Servers. In this follow up article I’m going to discuss some common issues...

• Connecting to multiple servers in a Query Window using SQLCMD - SQLMatters

  By switching on SQLCMD mode in SQL Server Management Studio you can add some useful extra scripting functionality that is not available with T-SQL. One particularly useful feature is the ability to sw...

• Scripting all Agent Jobs Using SQL Server Management Studio - SQLMatters

  It’s possible to script up all the agent jobs on a database instance, or a selection of the agent jobs using SQL Server Management Studio and the Object Explorer Details screen. Where there are lots o...

• sp_who2 - filtering and sorting the results - SQLMatters

  Sp_who2 is one of the most useful and widely used stored procedures, along with its predecessor sp_who. However it is also one of the most frustrating as it only takes a single parameter and the resul...