Month: March 2013

Choosing a Presentation Tool

Last Updated March 29, 2013

If your New Year’s resolution is to start presenting at user groups and conferences, congratulations! You’re about to embark on a fulfilling journey that will enrich the lives of thousands of people. It’s a blast. Now let’s put some thought into the tool you’re going to use. You’re going to be working on these same…

Saving Session State (video)

Last Updated February 13, 2017

Jeremiah Peschka

Architecture

Session state frequently ends up on a busy SQL Server. What seemed like a good idea in development turns into a problem in production. While there are valid business reasons for persisting session state to permanent storage; there are equally valid reasons to avoid using SQL Server as the permanent storage. We’ll investigate why session…

An Introduction to SQL Server IO for Developers (video)

Last Updated March 22, 2013

Kendra Little

SQL Server, Videos

Developers frequently make a big mistake: they tune out on discussions of storage performance and IO. Don’t fall into this trap! Understanding how storage impacts SQL Server performance helps you tune the right parts of your code and focus on what really matters. In this 30 minute video, Microsoft Certified Master Kendra Little demonstrates why…

Log Shipping FAQ

Last Updated March 18, 2017

Jes Schultz

Log Shipping, SQL Server

390

I’ve been working with and talking about SQL Server Log Shipping a lot lately! One way to ship logs… I’ve gotten a lot of great questions about log shipping, so I’ve put together an FAQ. What editions of SQL Server is log shipping available in? 2012 – Enterprise, Business Intelligence, Standard, and Web 2008R2 –…

Databases Five Years from Today

Last Updated April 24, 2018

Brent Ozar

Architecture

Five years from now, in March 2018, what will be different about databases? I’m a Microsoft SQL Server guy, so keep that in mind when reading my thoughts. Looking Back at 2008-2013 The big story here for me was virtualization. In mid-2008, Microsoft added support for SQL Server running under Hyper-V, and later they added…

You don’t have a Big Data problem.

Last Updated March 7, 2013

Brent Ozar

SQL Server

Let’s bust the buzzword bubble. Big Data is a sexy problem to have, so everybody’s claiming it. I’m sick of people using this phrase to gloss over their real challenges. You have a Small Server problem. If you haven’t bought a new server in the last two years, you’re not allowed to complain about the…

Developers: Check Your SQL Server’s Health

Last Updated March 6, 2013

Brent Ozar Unlimited Team

SQL Server, Videos

Before you join us in Atlanta for our 2-day training class (or if you’re just thinking about it), let’s talk about your environment. In this 30-minute session, we’ll give you some vital statistics to check in your SQL Server before you leave work, and we’ll explain how our upcoming training class will help you improve…

Six Scary SQL Surprises

Last Updated March 2, 2013

Brent Ozar

SQL Server

In the Happy Database movies, SQL Server is benign and friendly, with no scary surprises lurking around the next corner. In these movies: People work together No-one but the DBA can make changes to production People tell us in advance when they want to change something When query performance degrades, we’re notified about it Third…