Error when applying Service Pack

You should be carefull when apllying changes to the producion system. This is especially true for applying Service Packs. The main steps before patching SQL Server are: Backup all the user and system databases (with checking integrity of the backup) Check the health status of the user databases (DBCC CHECKDB) Check if this specific SP…

0

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

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…

0

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

MS Days 2011 site is open for early bird registrations

??? ?? ?????????? 2011 ?? ???? ?????????? ?? ????????? ???????? ?? ? ???????? ?? ???????????? ?? ??????? ????????? ???????, ???????????? ? ????????????? ?? ??????????? ?? ?? ????????????????, ???????? ? ???? ?? ?????, ????? ? ? ????? ????? ???????. ?? ?? ?? ???????? ? ??????????? ?? ?????? ? ??? ??-?????? ?????? ? ??????????? ?????????? ?? ??…

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 happy…

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

SQL Server Unplugged Follow Up

As I promised recently I am following up some questions from the MS Days 2010 SQL Server Unplugged Session.   Q: RBS and FILESTREAM Usage, why using the FILESTREAM/RBS functionality in SharePoint delayed? A: FILESTREAM and RBS are complementary approaches for storage and management of BLOBs and we see them both continuing to evolve. FILESTREAM…

0

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