Detecting and Removing Duplicate Indexes
Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...
2012-09-14
1,833 reads
Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...
2012-09-14
1,833 reads
In my last article “Introduction to Windows Azure SQL Database Services (Part 1)“, I’ve provided an overview of Microsoft Windows...
2012-09-06
1,259 reads
Microsoft SQL Server provides a variety of different options to monitor deadlocks. This includes Trace flags 1204 and 1222, SQL...
2012-09-03
1,541 reads
One of the security recommendation inside SQL Server Security Best Practice white paper for guest user is that, to disable...
2012-08-31 (first published: 2012-08-28)
5,294 reads
Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases...
2012-08-23
2,494 reads
Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain...
2012-08-23
1,761 reads
Today, my first article (ie. Different ways to audit SQL Server security) published on SearchSQLServer.com. In this article, I discussed...
2012-08-17
1,103 reads
Windows Azure SQL Database also known as SQL Server Data Services or simply SQL Azure is a Microsoft’s cloud services...
2012-08-16
1,956 reads
Today, I’m sharing the following T-SQL script which you can use to find which SQL Server Agent Jobs failed yesterday....
2012-08-15
2,318 reads
We can either use SQL Server Management Studio or use Transact-SQL query to find any SQL Agent jobs that have...
2012-08-12
2,676 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers