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)
267 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
499 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
91 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
185 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
453 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
96 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
218 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
371 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
121 reads
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Telp/WA.0821°3111°179 Jl. Tebet Raya No.25 B Blok CI, Tebet Tim., Kec. Tebet, Kota Jakarta...
Jl. Dr. Rajiman No.197, Jayengan, Kec. Serengan, Kota Surakarta, Jawa Tengah 57152
Telp/WA.0821°3111°179 Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F &...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers