Hello everyone! As a first practical post, today I will talk about disk partition alignment to configure storage system to achieve best performance out of SQL Server. It should not come as a surprise that tuning IO subsystem of any database engine...

Some of you might have faced the situation when there is an error in the SQL Server error log or Windows Event logs but you do not know what to do about it. Examples of possible errors are below, Error 1101 “Could not allocate a new page for database...

Hello everyone! My name is Yuriy Toropov. I am a SQL Server Premier Field Engineer (PFE) at Microsoft. Before joining Microsoft Services, I worked as an Engineer on SQL Server relational engine development team in Redmond, Washington on SQL Server...