Blog Posts

PASS Community And Mentorship

• Database Superhero’s Blog

Mentorship is the influence, guidance, or direction given by a mentor as defined by Webster’s dictionary.  I believe it involved a little more than that.  It also involves investing…

taboggianogmailcom

2019-04-01

Presentation 5: Presenting Performance Tuning with Memory Grants

• Arthur's Blog

So it’s about a week after SQL Saturday Chicago 2019. The event was amazing, tons of great people and in a great venue. Here’s the details of what happened…

Arthur-Daniels

2019-04-01

Jobs That Beat The Caring Out Of You

• The Scary DBA

I was inspired by Jen McCown’s story here. Read that first. It’s WAY better than mine. This is not an April Fools post. Fools are involved, but none were…

Grant Fritchey

2019-04-01

Making a life change

• SQLStudies

It is with a very heavy heart that I announce I will no longer be working with SQL Server. In … Continue reading

Kenneth Fisher

2019-04-01

Indexed Views – Performance Panacea or Plight

• SQL RNNR

An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many…

Jason Brimhall

2019-04-01

Upgrading SQL Server on Linux

• Klaus Aschenbrenner

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance…

Klaus Aschenbrenner

2019-04-01

Customizing Statistics Histogram in SQL Server 2019

• The Voice of the DBA

The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL…

Steve Jones

2019-04-01

Weekly reading #9

• Coding Family

Good morning, today is 1st April. Maybe it is a good time to say that for example SQL Server was acquired by its main competitor on the market? No,…

damianwidera

2019-03-31

Information Measurement with SQL Server Part 4.4: Sørensen Distance and Its Relatives

• Multidimensional Mayhem

By Steve Bolton …………As I discussed in more depth in the last three articles (not counting last month’s digression into Fisher Information, which is out of numerical order), theoreticians…

SQLServerSteve

2019-03-30

SSMS GUI not working? Try to use T-SQL!

• Cláudio Silva

One of the good things, when we have new clients, is that sometimes they have needs that you never heard before. This does not necessarily mean that they are…

Cludio-Silva

2019-03-29