What Limits Do You Want in 2019?
With SQL Server 2019 getting closer to release, Steve asks about the hardware limitations that we should have in Standard Edition.
2019-05-20
85 reads
Editorials
Why Tools Can Help You Do Your Job
Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was a problem with one instance that wasn’t currently being monitored, I would have to stop monitoring another instance […]
2019-05-18
87 reads
The Other Jobs
This week Steve is asking what jobs you might choose if you had the chance, as well as those you enjoyed, or perhaps dreaded.
2019-05-17
146 reads
2019-05-16
261 reads
Microsoft and Minecraft and Training Kids
Today we have a guest editorial from Andy Warren, looking at learning.
2019-05-15 (first published: 2015-02-23)
304 reads
Where Do You End Up as a DBA?
Steve Jones talks about careers, and where you might take your career over time.
2019-05-14 (first published: 2015-02-20)
658 reads
Communicate Smarter Not More
After installing Microsoft Teams, Steve has a bit of communication overload.
2019-05-13
172 reads
2019-05-11
87 reads
The Impediments to Change
SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]
2019-05-10
215 reads
The Death of the GDPR
The GDPR is struggling with enforcement against some of the larger tech companies. Steve thinks this is a problem, but it might not matter for smaller companies.
2019-05-09
334 reads
Blogs
Learning Containers
I find that I’m using containers more and more to get things done with...
Bad Idea Cowboy Hat: Using a foreign key to prevent updates
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series...
Inspector V1.4 now available
The SQL Installation script can be found here The Inspector sample report has been...
Forums
Lock Request Timeout period Exceeded Error 1222
A long running job is doing a SELECT INTO a table, so the table...
Primary Keys
What is a good way to determine which combinations of fields should make up...
Net Earned in Triangles without a Triangular Join?
Something I've been trying to figure today is can I achieve a figure for...
Ask SSC