Pages

▼
Tuesday, 15 August 2017

Altering SQL Jobs without granting SysAdmin privilege

›
What would you do if you were asked to grant a few users the permission for altering SQL Jobs? It is a tricky task to carry out although man...
Tuesday, 8 August 2017

Dealing with physical database corruptions

›
Beyond all doubt, not every single database in the world has a DBA dedicated to monitoring it 24x7 hours. Moreover, many database environmen...
Friday, 4 August 2017

Troubleshooting timeout expired errors

›
Having .NET Applications working with SQL Server, some unforeseen timeout errors can be raised for two possible causes: bad-written SQL code...
Tuesday, 1 August 2017

Updating so-called 'column statistics' for the whole SQL Server database

›
Definitely, statistics in SQL Server are vital to ensure stable database performance as a whole. Every DBA must know the importance of keepi...
Tuesday, 25 July 2017

Testing database connectivity by using a Universal Data Link file

›
After installing a SQL instance, we may need to test the database connectivity from a client host to make sure that everything is working ve...
Thursday, 20 July 2017

Detecting excessive compilation and recompilation issues

›
Undoubtedly, recompilation is a big topic to reckon with, more importantly, in database environments processing data that is changing rapidl...
2 comments:
Friday, 14 July 2017

Ports and Protocols Used by Microsoft SQL Server

›
Naturally, I have been asked many times about ports used by SQL Server services and to be honest sometimes I took me some time to reply beca...
Sunday, 25 June 2017

Getting the full name of SQL Jobs including the steps in execution

›
While monitoring a database server, we may need to know some details about the sessions, connections and requests that migh be causing perf...