This morning at the PASS Summit, we have the pleasure of listening to Professor David DeWitt talk about Hekaton internals.
I'm actually not going to liveblog this - I'm going to sit back and take in the presentation as an attendee because it's going to be so damn good, and I'm not going to be able to do justice to it in a live blog post. I need to explain why.
Charlotte, NC - Your intrepid reporter is onsite at the convention center, settling in at the Blogger's Table. At 8:15AM Eastern time, PASS President Bill Graziano will take the stage, discuss PASS, and then hand things over to Microsoft's Quentin Clark for product announcements.Some of the things I'm looking for include:Attendance numbers on the Summit…
You're a Database Administrator who gets the job done day in and day out-- but you're worried that maybe your skills aren't quite up to par. How do you know if you've fallen behind? Join Kendra in this free webcast for a simple test to learn if your DBA knives are as sharp as they need to be.
Two years ago this week, I took to the stage at the PASS Summit 2011 and unveiled sp_Blitz®, my free health check stored procedure that helps you rapidly take over SQL Servers you've never seen before.
Some historical highlights include:
The database comes with a manual, but let's be honest: nobody's got time for that. DBAs - help me distill the most important concepts and rules down to 140-character chunks. I'll work with Dell to compile the best tips into a free ebook for developers.
There's three ways you can contribute:
Problem: your database server’s performance stinks like Limburger cheese.
Solution: find the queries that are making that smell.
Hiding in Plain Sight
Your database server knows exactly which queries are performing the worst. When queries are executed, the execution plans – and associated execution statistics – are stored in memory (with a few exceptions). This information is stored in the plan cache, and you can access it by querying a couple of DMVs.
In the e-discovery business, kCura Relativity is the big gorilla, and I've been working with kCura and their clients since 2011. I think it's one of the most interesting businesses I've ever worked with - up there with StackOverflow - and like Stack, they're really open with their customers. Today marks my second year being…
You've been working with SQL Server for a couple of years, but you're not really sure what's going on in the System Databases folder. What gets stored in Master, Model, and MSDB? What processes use them? In the event of a crash, should you restore them? Brent Ozar will give you an introductory tour in this half-hour video:
This Wednesday night, come join me at DevMynd. Here's the topic I'll be presenting:
How StackOverflow Uses (And Doesn't Use) SQL Server
You’ve been nursing your SQL Server through day after day of increasing load. Stored procedures are taking longer and longer to run. There are timeouts on the client side. Both customers and management are getting upset. As you’re bemoaning the terrible code that the developers wrote, it hits you: you don’t have a code problem, you have a scalability problem.
I could be talking about the tables in my database - I do make them skinny by using the right data types - but in this case I'm talking about SQL Server Reporting Services tables. You've seen them before. The average table is bland and boring, with nothing to distinguish it from the next, and no reason for you to remember the data in it.
I get to work with everybody. Developers need to push data in and out of the database. End users want to get reports out. Executives want to make better decisions. Vendors need to update code. Anytime something's happening in the company, I'm one of the first to know. I get to play with new technologies…
Last week, after blogging about What Server Should You Buy, I partnered with Microsoft and Dell to host a Twitter chat about choosing the right server hardware. (Disclaimer: Dell and Microsoft paid me for my time.)
Some of the interesting questions and answers included:
We work with SQL Server every day, happily sending and receiving millions of packets of data across the network. Have you stopped to think about what happens when something goes wrong?
The Situation
You were helping a sysadmin understand the details of a request for a new virtual server. You whiteboarded a diagram to show how SQL Server uses memory. You got so excited when the sysadmin asked a hard question that you spilled coffee everywhere.We were tuning queries on a video conference with developers from That Software…
Are you still rebuilding all of your indexes every week - or heaven forbid, every night - and still having performance problems? Odds are, you're not actually making things better - you're making them worse! I explain why in this video:
https://www.youtube.com/watch?v=fD1CZVc6oUk
When you get a new laptop, you don't just pick Small, Medium, or Large. You look at all kinds of specs - screen resolution and size, memory size, storage, weight, and of course, price. Eventually you pick the one that's perfect for you, and then you shake your fist at the skies because you can't…
The PASS Board of Directors election is coming up, so I sat down with Allen Kinsel (Blog - @AllenKinsel) to get some insight. Allen knows first-hand.
Brent: The PASS Board of Directors election is coming. What exactly do Board members do?
Storage vendors brag about the IOPS that their hardware can provide. Cloud providers have offered guaranteed IOPS for a while now. It seems that no matter where we turn, we can't get away from IOPS.What Are You Measuring?When someone says IOPS, what are they referring to? IOPS is an acronym for Input/Output Operations Per Second.…
You're making excuses.The database application is slow, and you're throwing something under the bus, but we've got bad news. Changing it probably isn't going to make your server faster. Here's some of our favorite excuses.Kendra SAYS, "Your Problem Isn't GUIDs."Unique identifiers may or may not be globally unique, but they are one thing: the universal…
