Security is a complex process, one that is becoming more and more important to DBAs all the time. This week Steve Jones wants to know how security is handled for your service accounts.
2016-08-29 (first published: 2012-08-10)
265 reads
The idea of a data hub in your company is interesting to Steve Jones. He talks about this concept, and how it might help you increase data quality, and perhaps get closed to a single view of the truth.
2012-08-09
498 reads
This poll asks about copies, specifically those of your databases. How many do you keep around? How much extra storage does this cost? Steve Jones thinks that most organizations have quite a few copies, which can use a lot of resources.
2016-09-02 (first published: 2012-08-03)
182 reads
There are some very interesting projects being performed with cloud services. Steve Jones talks about a few and the new computing without limits claim from Google.
2012-08-02
90 reads
Today Steve Jones talks about the accidental DBA and how they can find themselves in a position where they are responsible, but not well trained. In those cases, it's up to the individual to learn, but also the manager to ensure it gets done.
2012-08-01
184 reads
One very handy item Steve Jones found as a DBA was a DBA only database on each instance. Today he asks you if you have one and if not, why not. There are good reasons to have one, and security is usually not a problem.
2012-07-31
451 reads
There is a rippling effect from the hack on Yahoo. Those users and passwords are being used on other sites. Steve Jones reminds us that we shouldn't be sharing passwords, and we should educate our users to do the same thing.
2012-07-30
93 reads
These days it seems there's no shortage of bad managers out there. However the bad ones do more than hurt morale, they actually can impact productivity. Steve Jones wonders why companies don't do more to fix this.
2012-07-30
217 reads
Great DBAs collect all kinds of metrics on their instances and let them manage themselves. However many administrators need help monitoring and interpreting the data. Today Steve Jones asks if you think this data needs extra security or is it less of an issue than other PII data.
2012-07-27
368 reads
Dropbox has grown tremendously in the last few years and Steve Jones talks about a concept of running with less headroom as a way to cope with that rapid growth. Is it something you'd be interested in with a SQL Server?
2012-07-26
120 reads
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers