The 10 (.5) Commandments for IT Professionals
A list of the commandments, or at least suggestions, that Simon Holzman sees as important for IT professionals.
2014-09-18
505 reads
Editorials
A Dearth of Comments
Steve Jones talks about one of the least favorite things for IT people: documentation. How much do you really need to do?
2014-09-17 (first published: 2009-01-05)
517 reads
The Need for Auditing
Is C2 auditing widely used? Should it be more widely used? Steve Jones talks about the subject of auditing in today's editorial.
2014-09-16 (first published: 2008-12-08)
659 reads
Swallowing the Camel
There is a paradox in the nature of the abstractions that many developers want when dealing with databases. They will strain at the gnat, but swallow a camel (Matthew 23:24). Whereas they will recoil with horror when a DBA suggests that an abstraction layer based on views, functions and procedures in a separate database schema […]
2014-09-15
184 reads
The Ten Commandments for DBAs
What should a good DBA do? Steve Jones came across a list he likes that showcases those things that should guide your efforts on a daily basis.
2014-09-15
403 reads
Data Vices
Steve Jones asks about what you might change about yourself at work for this Friday's poll.
2014-09-12 (first published: 2008-12-05)
155 reads
The DBA Team Wants You!
There's a new contest going on, giving you the chance to win some software, SQL training, and a vacation, all at once.
2014-09-11
169 reads
Prepping for 2015
Steve Jones looks ahead at the new year and how you might want to begin shaping your career.
2014-09-10
184 reads
Estimates
Software estimates are often wildly off from the actual amount of time and resources that are required. Today Steve Jones looks at a few reasons why.
2014-09-09
193 reads
Misconfiguration is a Problem
The configuration of server systems matters. Not just to ensure software runs smoothly, but also for security.
2014-09-08
80 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers