Browse by Tags
Have you ever had to move your master database? Or have you ever opened the folder which contains your master database? Both cases - if that ever happened to you, you should already know about the Resource Database - a hidden, read-only database introduced
Read More...
Whilst surfing on the web last week, I've found this very nice blog from Vipul Shah, which happens to be a Microsoft colleague, which explains which are the key performance counters to monitor for your SQL Server instances and most importantly summarizes
Read More...
For those which live or work close to Reading - there will be a UserGroup on the 20th Evening held in TVP - Microsoft Offices. Agenda: 6pm – 6:30 Registration and networking + Tea/Coffee with biscuits. Meet and greet. 6:30pm – 7 Round Table discussion
Read More...
PPT Plex is a new tool - or more precisely - a new add on for Microsoft Power Point - which will change the way you will deliver your presentations. In short, what it allows is a different navigation experience trough your slide deck . Instead of having
Read More...
Here we are, as promised, with some rumblings on SQL Server 2008 Resource Governor . I've played a lot with the various options which this features provides, especially in preparation of my TechEd presentation last week! Did I ever mention how much I
Read More...
Just discovered whilst at TechEd that Microsoft policies for SQL Server products that are running in a hardware virtualization environment are not much known as yet to the majority of the public. Therefore the PFE in me :-) wants to be sure that when
Read More...
Wow! Presenting at TechEd yesterday had been one of the best experiences of my life! Being in front of different customers, which work with SQL Server every day, and being able to share my experience on the field with the new great features included with
Read More...
This week I'm presenting on SQL Server 2008 Resource Governor @TechEd Barcelona http://www.microsoft.com/emea/teched2008/itpro ! My session is on Tuesday, 10:45 - 12:00 , make sure to come along if you want to learn about this cool new feature in SQL
Read More...
SQL Server 2005 Service Pack 3 (SP3) is now available for public testing ; a final release version will be available in the future (Near future. Before the end of this calendar year ;-)). The SP3 Beta version addresses issues reported through the SQL
Read More...
I've posted some time ago about Slipstream of Service Packs on SQL Server 2005 - which was and is still not available - so basically with 2005 it is not possible to have the Update/SP and the RTM included together in a single package. This was a feature
Read More...
Latest Microsoft Security Bulletin ( MS08-052 - Vulnerabilities in GDI+ Could Allow Remote Code Execution ) changes once again Microsoft recommended builds for SQL Server as follows: SQL 2000 is not touched from the Security Update, so minimum build remains
Read More...
It's a long time since I wanted to post some info concerning memory on this blog, but I always been confused on where to start from. To take away any doubt, let's start from scratch. Even amongst the most seasoned DBAs there is some confusion about memory
Read More...
A general misconception when it comes to transaction log management, is that the transaction log gets automatically TRUNCATED (underlined, as I am not saying SHRINKED!!!) when a full database backup is performed. This is completely untrue , and if you
Read More...
J ust being discussing recently the Backup\Restore best practices (related to corruption) and wanted to share some information. SQL Server Backup\Restore in SQL (when actually done directly from SQL, not from a 3rd party application - I come to that in
Read More...
I've posted a blog entry some time ago about Microsoft recommendation for SQL Server SP2 builds: SQL Server 2005 SP2 - Recommended Build ? Last week Microsoft has released a new SecurityBullettin ( MS08-040 - Vulnerabilities in Microsoft SQL Server Could
Read More...
