about 2 months ago - No comments
I recently wrote an article for MSSQLTips on this topic of creating a trace template in Profiler. SQL users who know about the profiler tool do not need what are the benefits of profiler. Read the tip on MSSQLTips here … Creating a Trace Template in SQL Server Profiler –Bru Medishetty
about 3 months ago - 1 comment
This blog is the 50th blog on LearnSQLWithBru. I am surprised to see that I was able to write 50 blogs in such a short time. I feel the blogs that I publish are informative and easily understandable. I have received lot of feedback from many readers and I implemented few of them such as
about 3 months ago - 4 comments
Last weekend I traveled to Atlantic City, NJ to watch Pete Sampras playing an exhibition match. I was very much excited and was looking forward to watch Pete live for the first time in my life. Never before had I watched a Tennis match featuring Pete Sampras live in a Stadium, I was very happy
about 4 months ago - No comments
This is an article that was published yesterday in MSSQLTips. The article describes the steps to perform few Administration tasks related to SQL Server from Services Management Console. Read the complete article on MSSQLTips site here http://www.mssqltips.com/tip.asp?tip=1969&home
about 4 months ago - 3 comments
I wanted to share some news about this Blog. Last week this blog was added to the list of blogs in SQL PASS Blog Directory. I am thrilled to have this blog listed in it, since the list contains highly regarded SQL Server experts. Follow the Blog Directory at SQL PASS here http://www.sqlpass.org/Community/BlogDirectory.aspx – Bru
about 6 months ago - No comments
One of the frequently asked questions in forums, interviews and during general discussions, is performance tuning. In fact, a friend of mine, (who knows a little bit of SQL Server) when speaking about my blogs, asked me why I had not written any blog on performance tuning. I gave a pause and said, do you
about 8 months ago - No comments
In this article we will look at the steps to enable AWE Option in SQL Server. When enabled, the Advanced Windowing Extensions gives the ability to SQL Server to utilize Memory more than 4 GB. AWE enabling for SQL Server is valid in 32 Bit Systems only, on 64 bit systems AWE is not required
about 8 months ago - No comments
Cursors in SQL Server enable you to work with each of records in a record set, so that you can sequentially work with those records and carry out the required task. The best example that I can recollect to quote here is when you have a table with 100 rows, with one of the columns
about 10 months ago - 1 comment
I would like to explain the steps involved in implementing Database Partitioning in SQL Server 2005. If you had already implemented Very Large Databases using federated Databases, you would be relieved that Database Partitioning is very easy to configure and work with and the pain to maintain is gone with this wonderful feature. Implementing Database Partitioning