Menu

Author: izechWlynP

SQLSaturday Automatic Messages

0 Comment

For those who haven’t used the admin tools for SQLSaturday when an event is created there are a set of messages loaded automatically. It’s up the event admin if they want to approve them, edit them, or delete them (one at a time). It’s one of the parts I wrote a long time ago and […]

Notes from Jacksonville, Atlanta, and South Florida

0 Comment

Misc notes: Jax. Ice cream break in the afternoon is nice, but the waffle cones on site make all the difference, the smell is hard to miss! Jax. Rooms in two different locations is harder. This isn’t uncommon (Tampa had a variation of this) and it’s worth extra effort to help people to find the […]

SQLSaturday Orlando 2019 Begins

0 Comment

We’ll be event number 911, set for September 28th at our usual location at Seminole State College. Maybe something interesting to do there as far as a theme. Call for speakers is open and we’re looking for pre-cons (send quickly, we’ll be deciding in the next week or so). I have two personal goals for […]

As a DBA, how do I offload some of my work?

0 Comment

I don’t have time for this “I am a DBA, I am busy, too busy. Developers keep pushing changes to production without me reviewing the code, and now I am stuck again, over the weekend fixing performance issues while the developers are on the beach with a pina colada and a cigar” Sound familiar? Maybe […]

Get the Source of PREEMPTIVE_OS_PIPEOPS Waits

0 Comment

A client reached out to me for help about a wait_type they were seeing. That’s not terribly uncommon, but the specific wait_type was something that was fairly obscure. Every day, they could see the delta on this wait_type continue to climb higher and higher. The problem was not in their ability to capture the deltas […]

Query machine name of the sql server instance – the hard or the harder way

0 Comment

I was at a client where they are using non-Microsoft clustering technology to achieve the high availability of SQL Server instances. This was party because of legacy reasons and partly because it supports clustering across all major hardware, operating system and applications including SQL Server. SQL Server instances are setup in either 2 or 3 […]

Does the case statement short circuit?

0 Comment

Let’s start with definitions: CASE Statement: This is basically an inline IF .. ELSE IF .. ELSE IF ….. etc statement. In other languages you might see it called a switch statement. CASE WHEN boolean statement THEN value WHEN boolean statement THEN value … ELSE value END Since this is inline you can’t just run […]

Simulating Load

0 Comment

I needed to generate some load for a demo and wasn’t looking forward to doing it. I was in a hurry, and didn’t want to deal with a lot of setup. Fortunately, I’d seen a technique for doing this in one of Brent Ozar’s classes. I’d taken a couple, and they’re good. One of the […]

Leadership Part 2: Talent acquisition and Employee Retention

0 Comment

The two most costly human capital expenses an organization will have is the onboarding and offboarding of staff. Just take a moment to think about that and if your scratching your head or think I’m crazy let’s take a moment to explore both of these costs. Loss of staff costs: (Loss of intrinsic knowledge) + […]

Amazon’s Concept of Ownership and Technical Debt

0 Comment

I’m reading Think Like Amazon: 50 1/2 Ideas to Become a Digital Leader. In talking about Amazon’s pursuit of a second headquarters, John Rossman wrote the following regarding ownership: Amazon’s second leadership principle is “Ownership,” by which leaders at Amazon strive to never sacrifice long-term value for short-term results. Where I think this is appropriate is the issue […]