Grant Truncate Table Permissions in SQL Server without ALTER Table
How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip.
David Bird has years of IT Experience working as a DBA and programmer on Windows, UNIX, and mainframe. Since 2003, most of his DBA emphasis has been on SQL Server while still working with other database engines. Being a programmer at heart and always aiming to be proactive, David continues to look for new ways to automate DBA tasks and prevent issues.
Automate Bringing SQL Server Cluster Resources Online After Failover is Unsuccessful
Have you noticed that when a failover is initiated on a SQL Server cluster it does not always do so successfully? Often nothing is wrong, it's just taking too long to confirm a resource or Windows id. The cause may vary but the solution is the same. You l
Exporting SSRS Report Definitions from the Web Site
You need to edit a SSRS report, but you do not have the source code. How do you get it?
Scheduling a SQL Server Profiler Trace
You want to schedule a trace, but SQL Profiler does not have a built-in scheduling option. So how do you use SQL Agent to schedule a SQL Profiler trace?
How to setup SQL Server alerts and email operator notifications
In this tip we look at how to create a SQL Server alert to be emailed to the database team.