Hi friends I am working with SQL Server , Analysis service and Reporting service since last 7 years.I have worked with development and maintenance activity , cubes and reports on some of worlds large datasets.
We are providing training on all SQL Server related technology. For this you can contact me at shahamishm at gmail.com.
Cheers
Amish Shah
SQL Server Forum
Popular Posts
-
sp_addlinkedsrvlogin To modify or add new login for linked server
-
Recently we had hardware and performance issues on SQL Server,with our client , so while monitoring the system we also looked at error ...
-
Recently I got a problem where Builtin\Administrators Account was deleted . How can we recreate it? Here is a solution for this Run th...
-
Recently I got a mail for following problem While the client tries to open registered server window in Mbanagement Studio he gets follow...
-
Many time we need to do runing sum of value. In SQL 2oo5 we can do it with use of CTE
-
sp_purge_jobhistory We can use this procedure to delete old history for jobs.
-
Various way to calculate running total from All period to currentmember As MDX is a very vast and dynamic language we can write same quer...
-
For every Developer and DBA index maintenance is very important task. Since the changing ...
-
Index are very important part for any database. We need to regularly monitor index and maintain index for better performance of the system...
-
In SQL Server 2008 when we open activity monitor we can see SPID and information related for that SPID . But what if we want to get detail...