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 …
SQL Server Analysis Services – Expose OLAP Cube over HTTP port 80 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. …
SQL Server Monitoring – Automating SQL Server Health Checks (SQL Server 2005 & Above) 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 …
SQL Server Monitoring Counters Important 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 …
SQL Server Identify Unused Tables & Indexes 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 …
SQL Server – Get TOP 5 Tables Consuming Maximum 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 …
SQL Server Identify Long Running Queries 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 …
SQL Server: SQL-Getting rid of unused space in table Read More