The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially true if the DBA is not checking and monitoring the databases for obvious things such as database corruption, and disk space. However, the really scary surprises are less obvious and provide fewer warning signs. Brent Ozar gives six scary surprises that can be avoided by the shrewd DBA.
2017-10-31
7,099 reads
SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding.
2017-08-25
5,735 reads
Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.
2017-08-22
4,419 reads
2017-06-01
1,048 reads
Bhavesh Patel shows how to validate specific use-cases for integer and decimal values in SQL Server.
2017-05-31
3,649 reads
2017-05-30
1,142 reads
A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.
2017-04-27
7,260 reads
Keeps a memory leak under control until the bug fix is developed and applied. Short term band aid.
2017-04-25 (first published: 2017-04-13)
549 reads
2017-04-12
7,089 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
4,400 reads
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Jl. Metro Pondok Indah No.10 Lt 2, RT.3/RW.17, Pd. Pinang, Kec. Kebayoran Lama, Kota...
Tlpn/wa0853.7373-7551 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL,...
Comments posted to this topic are about the item There's Too Much to Learn
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers