There are drawbacks to assembling your own toolbox by gathering tools from different sources. Steve mentioned one, maintaining the tools over time. There's also the inevitable inconsistency from one tool...

• This reply was modified 2 years, 2 months ago by  Wingenious.
• This reply was modified 2 years, 2 months ago by  Wingenious.

The missing index suggestions are not connected to specific queries in versions prior to SQL Server 2019. SQL Server 2019 added the sys.dm_db_missing_index_group_stats_query DMV. This DMV tells you...

The missing index suggestions are not connected to specific queries in versions prior to SQL Server 2019. SQL Server 2019 added the sys.dm_db_missing_index_group_stats_query DMV. This DMV tells you which queries...

I can make the msdb.dbo.agent_datetime function fail by supplying an invalid date value, such as 0 (zero). If you have invalid date values in your job history, and I'm not...

I will add a check to avoid the problem, but it does not happen for me on SQL Server 2012 SP4 or SQL Server 2019. The Microsoft function simply returns...

I miss the 8-inch floppy disks of the Altair and Ohio Scientific computers. Although, I suppose it would be a bit unwieldy to carry 14,000,000 of them to match the...

A new version of SQLFacts (http://SQLFacts.com) has been released.

The new version includes additional license information in the README file, and a reference to the license information in each file.

The...

people almost feverishly try to learn a whole lot of new stuff when they haven't actually learned to use the old stuff or even the basics well enough to...

Great editorial!

• This reply was modified 3 years, 1 month ago by  Wingenious.

In my 40+ years of IT experience, there are far more IT people demonstrating the Dunning-Kruger effect than Impostor syndrome. For one thing, Impostor syndrome seems to require a certain...

• This reply was modified 4 years, 3 months ago by  Wingenious.

I must be missing something very important with all the "cloud" (remote hosting) options.

If I'm over here (such as in an office) and my data is over there...

Of course, that's always the reason given. The people who give such a reason are usually managers...

If we were all deeply pessimistic about redeveloping software then we might still be using VisiCalc.

Sure, redeveloping software involves costs and risks, but so does running a business on a...

David.Poole (12/7/2016)

---

If I was to choose the nuclear option it would be based on the underlying tech being obsolete, the needs of the end users not being met and possibly...

I would run out of fingers if I tried to count the number of times I have inherited a database mess with a new job. The new employer always promised...