יום שני, 27 בדצמבר 2010

MoreVRP Keeps your SQL Server DB in Shape without Cramping your Business Users



We all know that the secret to staying healthy and fit depends on regular, routine exercise and good maintenance habits. The same is true for our database. But how can we ensure that our routine database workouts not interfere with or delay our business?


Throughout the work week different end-users interact with the database to conduct their urgent business activities. They insert new data and run numerous varied complex transactions using a variety of applications that combine and integrate data from different sources. Sales teams enter new customer and pricing data; engineering teams change product attributes and configurations. Logistics clerks repeatedly update the database with RFID devices that transmit loads of status information from the warehouse. Consuming this varied and heavy diet while running back and forth and at the same time concentrating on difficult calculations would give anyone indigestion, especially our MS SQL Server database, with its very sensitive stomach, special dietary requirements and lean frame….



So each week we invite our SQL Server database to the fitness center for a long workout. The DBA carefully goes through the checklist, executing index and stats maintenance procedures, checking for index fragmentation or duplication that are likely to tire the database and slow it down.


Usually the DBA carries out the weekly maintenance routine on the weekend when fewer end-users need the database active. Nevertheless, we all recall the times that the database hasn’t finished its maintenance workout on-time, causing many anxious end-users to congregate around the coffee machines on Monday morning waiting for the tired database to let them get their new work week started.



What can you do to empower your database to better mobilize its resources in order to carry out all the urgent business tasks you need to do in parallel to its time-consuming yet vital maintenance routines? More IT offers you the unique wonder drug that will revitalize your database – MoreVRP! Only MoreVRP, sometimes referred to as “APM on Steroids”, can get inside the database to reallocate its resources and prevent the loads that cause database indigestion, letting it concurrently execute end-user transactions while more slowly doing its maintenance routines without interrupting your business.


There are many vendors that offer a wealth of health check monitors that will measure how tired your database is, as well as sophisticated exercise machines that let your DBAs assign more and more routine exercises and training to keep your database fit.


Only MoreVRP gives your SQL Server db the resource management “muscle” you need to keep your business going strong! For more details, check out our solution on

www.morevrp.com


יום רביעי, 22 בדצמבר 2010

להתמודד עם אופיס 2010

שלום לכם

אמנם זה לא קשור ל- DB, אבל זה מאוד שימושי :)



לכל המנסים את גרסאות האופיס של 2010 ומתמודדים עם השאלה - לאן נעלמו הלחצנים המוכרים??

אל דאגה, יש דרך למצוא אותם!

מיקרוסופט חשבה עלינו והכינה לנו ממשק פשוט ונוח:

הקישו על הלינק הבא:

http://office.microsoft.com/en-us/outlook-help/learn-where-menu-and-toolbar-commands-are-in-office-2010-HA101794130.aspx

יש לבחור את האפליקציה הרלוונטית, לאחר הבחירה נראה מסך של 2003, נבחר את הכפתור \ הפונקציה הרלוונטית, ומה שנקבל זה חלון של סביבת 2010 שבו נראה היכן הכפתור ממוקם בגרסה זו.

בהצלחה

נ.ב. קרדיט לאושרי כהן מנהל אבטחת מידע במכתשים .

יום ראשון, 19 בדצמבר 2010

Microsoft SQL Server 2005 Service Pack 4 RTM

שלום רב,

מייקרוסופט שחררה עדכון sp4 לגרסת sql server 2005 .

Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP4 . You can use these packages to upgrade any of the following SQL Server 2005 editions:

Enterprise
Enterprise Evaluation
Developer
Standard
Workgroup


SQL Server 2005 SP4 includes SQL Server 2005 SP3 cumulative update 1 to 11, customer requested fixes, along with instances of the SQL Server 2005 SP4 database Engine support for DAC operations.

להלן רשימת הבאגים שנפתרו:

http://support.microsoft.com/kb/2463332

להורדת הקובץ:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece


בהצלחה