SQL Server Education (by the geeks, for the geeks)
This white paper will navigate you through the process of exposing SQL Server Analysis Services cubes over port 80 Prequisites : SQL Server Analysis Services server must have IIS installed (if both the servers …
Read MoreIt’s a known fact that an ideal Production DBA is like a parent to 100’s of children. By children I mean database servers, and yes, they are like babies to DBAs. …
Read MoreHello Guys, We all are aware that monitoring a database server for that matter any server is of prime importance in order to ensure business continuity. I will be talking only …
Read MoreIt often happens that DBA’s/Developers end up creating database objects(mostly tables) during development phase for various reasons like intermediate testing or backup. Such objects often end up on production databases. DBA’s/Developers often …
Read MoreI always say that database sizing is one of the prime tasks and concern for any DBA. As a DBA you should ensure that there is no single record claiming space …
Read Moresql server identify long running queries It is always a big challenge to maintain application’s performance optimum. Increasing data on regular basis is often the cause for performance degrades. In most …
Read MoreScenario: Database sizing is one of the most critical tasks for any DBA. One of the DBA’s tasks is to also ensure optimum performance. Database/table size is one of the key …
Read More