4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Thomas_LaRock.jpg

Thomas LaRock

Thomas LaRock is a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and a Microsoft Certified Trainer with over 15 years experience in the IT industry in various roles such as programmer, developer, analyst, and database administrator. He is also the author of "DBA Survivor: Become a Rock Star DBA" and has participated in the technical review of several other books. Currently, Thomas is a Head Geek for SolarWinds.
http://thomaslarock.com http://thomaslarock.com/feed

Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance.
Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.

Blog posts RSS

Changing Default Database File Locations in SQL Server 24 Feb 2015
When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties. You can see these properties for yourself by right-clicking on the instance name inside of SQL ...

Using Templates With SQL Server Management Studio 22 Jan 2015
I love learning new things. I feel like a kid again at times, my eyes get wide as I imagine new possibilities using whatever things it is I have found. This is how I felt last week when I came across a feature of SQL Server Management Studio (SSMS) that I had not seen before(...)Using Templates ...

HOW TO: Recycle the SQL Server Analysis Services msmdsrv.log File 14 Jan 2015
I found this question over at DBA StackExchange the other day and it left me shaking my head. How is it possible that there is no way to automatically recycle, or reset, the SQL Server Analysis Services (SSAS) error log in a similar manner to SQL Server? After all, it’s not like the ...

5 Things You Didn’t Know About SQL Agent 07 Jan 2015
Microsoft SQL Server comes with a boatload of additional components. One component is the SQL Agent service. The purpose of the SQL Agent is to serve as a job scheduler. Many experienced DBAs use jobs running inside the SQL Agent to perform routine tasks such as backups, updating statistics, and ...

14 Things That Didn’t Happen To Me In 2014 30 Dec 2014
It’s that time of year again. The time when we find many “year-2014-in-review” and “what-to-expect-when-you’re-expecting-2015? articles littered about the series of tubes known as the internet. It’s only natural for folks to wax nostalgic as 2014 fades into the sunset one final time. I, however, ...