The SHRINKDATABASE Evil

I mentioned in my previous Fragmentation post to not use the SRHINKDATABASE during the maintenance, and to switch off auto-shrink option. Some of you probably believe me and just don’t use it, but some of you wait an explanation and don’t accept advises based on promises 🙂 Well, let me prove you what the shrinkdatabase…

2

Welcome to my new blog!

Here we go, I have just created a blog! I didn’t know that it will take too long for me. My friends often say: What’s going on with you? Why don’t you publish? Well, everything is just on time. I suppose now I know and I feel that there is something I can share with…

1

Fragmentation – the database performance killer

Fragmentation is something that we don’t usually pay enough attention but it causes a very large percents of cases with performance degradation. Sometimes it plays a main destructive role for the overall performance of our database. Disk fragmentation There are different kinds of fragmentation. One type of fragmentation is a disk fragmentation, where the disk…

1

SharePoint 2010 for SQL Server Professionals

Yesterday we had a regular SQL User Group meeting this time the topic was SharePoint 2010 over SQL Server. And we were 2 Certified Masters presenting the topic (Radi and me ). What to say – it was enjoyable! It was a great experience for me and hopefully to the people in the audience, because…

1

Inside Hash and Sort Warnings

Recently I dove into Query Performance and troubleshooting topic. I delivered a couple of 400+ Performance and Tuning Workshops as part of my SQL Master Academy Training Initiative. All of those very intensive and incredibly useful workshops focused my attention on several topics. I made an experiment presenting a session  named Detecting Problems in Query…

1

The Greatest MS Days Ever!

MS Days has just passed. It has been a great event, actually the greatest one I’ve ever attended as a presenter. And it is not just because of the award I received from Ogi as a recognition for leading the Bulgarian SQL Community (It was very kind, but I accept it not only as an…

1

Back in SQL Life

Hi again and sorry for such a long pause from blogging. During the past year I was focused on things with highest priorities only, including SQL User Group Meetings and some important trainings for my customers. It was a year of stress and fears about our little baby. Thanks God everything went well and I…

0

SQL Denali CTP1 Installation

Just Installed the Denali CTP1. Some experience shared here. I used iso file and installed the Denali CTP in a Virtual Machine with Windows 2008 Standard, along with SQL Server 2008 Dev Edition with all components installed. There are two requirements for the Denali CTP1 installation that you better pass before you got two separate…

0

SQL Denali CTP1 Released!

Another PASS Announcement (it must be a great conference, I am really sorry I couldn’t make it): SQL Denali CTP1 released! At last! 🙂 I was so inpatient to share  the new features coming and I hardly kept my mouth shut. The HADR-on features are coming. Even with partial functionality enabled at CTP1 we are…

0

SQL Server Masters Certification Changes

A PASS Announcement for SQL Master Certification and couple of links. Shortly you can reach SQL Master by taking the exams at 9 available certified Prometric Centers Worldwide. You are not required to go to Redmond for a 3 weeks training. You can choose by yourself how to prepare for the exams. There are two…

0