Database Corruption

SQL Server Database Corruption! Understanding and Diagnosing

Of all the things that can ruin your day as a DBA and possibly get you fired, database corruption ranks right up there with backups and security enforcement of the database. Database corruption can be a resume generating event! A corrupt database can affect system stability, lead to unnecessary downtime, and possibly the loss of some data. To manage the risk you must know what database corruption is, how to diagnose, how to fix, and how to prevent.

Read on to learn how to understand and diagnose database corruption.

Read More »

Scrabble Bully

How to Survive the Office Bully

Featured image photo credit: TheDyslexicBook.com. Licensed: https://creativecommons.org/licenses/by/4.0/

Being a software person has advantages and disadvantages. On the plus side you probably “speak machine” with ease. However we often struggle to interface well with the other humans. One of the ills of the office that I have experienced is the office bully. Over the years I have compiled an effective strategy and tactics to deal with them.

The best resource I’ve read is a book called “Beating the Workplace Bully” by Lynne Curry (twitter). The book does an exemplary job of describing the situation and prescribing treatment for dealing with the workplace bully. I share the content below. Read on to see the details and my analysis!

Read More »

SQL Saturday Houston #766

I’m Speaking – SQL Saturday Houston 2018!

On Saturday June 9th I’ll be speaking at SQL Saturday Houston. I am excited to be presenting a lively and practical session about Environmental SQL Server Troubleshooting.

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment.

Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!

 

RDU to IAH

If you want a preview of the talk and some supplemental info please look at these:

 

Read More »

SQL Saturday #773 Los Angeles

I’m Speaking – SQL Saturday Los Angeles 2018!

On Saturday June 9th I’ll be speaking at SQL Saturday Los Angeles. I am excited to be presenting a lively and practical session about Environmental SQL Server Troubleshooting.

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment.

Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!

RDU to LAX

If you want a preview of the talk and some supplemental info please look at these:

 

Read More »

SQL Saturday Raleigh 2018 Logo

I’m Speaking – SQL Saturday Raleigh 2018!

On Saturday April 14th I’ll be speaking at SQL Saturday Raleigh. I am excited to be presenting a lively and practical session about Environmental SQL Server Troubleshooting.

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment.

Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!

If you want a preview of the talk and some supplemental info please look at these:

There are about 40 different sessions scheduled ranging from beginner to advanced – something for everyone.

I wrote about last year’s event: Raleigh SQL Saturday 2017 – Amazing Professional Community

Read More »

T-SQL Tuesday Logo

T-SQL Tuesday #100 – The Future of SQL Server 2026

The topic for this months T-SQL Tuesday #100 (hosted by Adam Machanic Blog/Twitter) is:

“…put on your speculative shades and forecast the bright future ahead. Tell us what the world will be like when T-SQL Tuesday #200 comes to pass.”

Big thanks to Adam for starting this monthly blog party and keeping the energy going!

Let’s predict the future of SQL Server! I will share with you my best guesswork about how it will be to work with SQL Server 2026.

Read More »