Month: November 2012

SSMS is the standard tool for working with SQL Server databases. It does the job well. But if you’re using the default settings, you’re missing out! You can enable word wrap and number the lines. Change the settings when you script objects out. Filter through objects. Let Jes guide you through the world of hidden…

How to Set SQL Server Max Memory for VMware

Last Updated February 13, 2017

SQL Server, Virtualization

SQL Server has two settings that kinda-sorta govern how much memory we’ll use to cache data: min server memory and max server memory. I explain the basics of how they work in my Sysadmin’s Guide to SQL Server Memory, but things are a little different under virtualization. VMware does a great job of sharing memory…

Long Term Backup Storage With Amazon Glacier

Last Updated February 9, 2017

Jeremiah Peschka

Amazon Web Services (AWS)

A while back, Jes asked who’s taking your backups. Making sure you have good backups is important. How much thought are you giving to handling historical backups? Right now, there’s a really good chance that you’re using a solution based on tape. While tape backups work, there’s a better way. How Are You Archiving Backups Right…

Introducing the SQL Server Plan Cache (and a Better sp_Blitz®)

Last Updated February 13, 2017

Execution Plans, SQL Server, Videos

When you send your beautifully hand-crafted organic T-SQL statement to SQL Server, the database engine takes a moment to appreciate the poetry of your work. Before it turns your request into results, it has to build an execution plan. SQL Server considers: Which tables it needs to join together What subqueries it needs to execute…

Creating Objects on a Specific Filegroup with Policy Based Management

Last Updated November 15, 2012

At PASS Summit last week, I presented “The What, Why, And How of Filegroups” to a packed room. It was great to see so many people eager to learn about something that is fundamental to every SQL Server database, but often not understood well enough. As always, during and after the session, there were a…

What DBAs Need to Know About Hardware

Last Updated November 11, 2012

If you became a database administrator by rising through the ranks of software developers, you probably haven’t built your own servers from the ground up. That’s totally okay – but you’re missing some important information that will make you a better database administrator. In this 20-minute session, Brent Ozar will help you get started exploring…

#SQLPASS Women in Technology Luncheon Live Blog

Last Updated February 12, 2017

#SQLPass

Hello from Seattle! I’m excited to be sitting front and center of the 10th Women in Technology Luncheon at PASS Summit! This year’s topic is “Women in Technology: Where Have We Been and Where Are We Going?” We’ll be hearing from an excellent panel! Stefanie Higgins, a Sr. DBA for Disney and former PASS board…

#SQLPASS Summit Keynote Liveblog Day 2

Last Updated February 12, 2017

#SQLPass, SQL Server

Good morning ladies and gentlemen! The conference hall is filling up in Seattle, and it’s time to crank up another blow-by-blow commentary. I’ll be updating this blog every few minutes with what’s happening here at the PASS Summit. For a refresher, check out the liveblog of yesterday’s keynote. PASS Summit Keynote Stage 8:20AM – People…

#SQLPASS Summit Keynote Liveblog – Day 1

Last Updated February 12, 2017

#SQLPass, SQL Server

PASS Summit Keynote Day 1 Good morning, folks! Lights, camera, action – it’s time for the first keynote presentation at the Professional Association for SQL Server Summit. It’s the annual international conference for Microsoft database folks. This year it’s in Seattle, Washington again. Over the next two hours, I’ll be expanding this post with minute-by-minute…

Books, the Dewey Decimal System, and…SQL Server?

Last Updated May 13, 2014

I have been in love with books and libraries most of my life. I remember some of my earliest favorites: Little House on the Prairie, Anne of Green Gables, Bridge to Terebithia, The Chronicles of Narnia. I remember feeling grown up when my sixth grade teacher handed me Gone With the Wind. I would read…

Our PASS Summit 2012 Schedule

Last Updated February 12, 2017