Get In a Line
Steve Jones talks a little about disk alignment for your SQL Server instances. This is something that you might to check on your systems and see if you can improve performance.
2010-02-01
144 reads
Editorials
Keeping It All In Memory
With the release of an in-memory database from Sybase, is it time for SQL Server to join the fray?
2010-02-01
326 reads
Rotating Keys
This Friday's poll deals with security. Steve Jones asks how often you might rotate those encryption keys to ensure that your systems are secure.
2010-01-29
156 reads
Arrogance Has No Place in Security
Arrogance has no place in assessing threats and attempting to build security to mitigate them.
2010-01-28
126 reads
The Dying Administrator
Is the SAN administrator dying out as a job? Steve Jones comments on an article that suggests it might be.
2010-01-27
195 reads
The IT Explosion
So many people are joining the IT industry all the time and Steve Jones talks about the attitudes that they bring with them.
2010-01-26
217 reads
Keeping up with Technology
Phil Factor believes that we have become so immersed in the idea that administrators or accountants can run technical enterprises, unaided, that we are in danger of forgetting the vital creative contribution of the technologist.
2010-01-25
120 reads
We'll go no more a' tibbling
Phil Factor points out the limitations and irritations of Hungarian Notation.
2010-01-25
873 reads
Forgetful Databases
Chris Massey gives a speedy book review, discusses the erosion of data privacy in the so-called Digital Age, and considers the implications for DBAs of a possible solution.
2010-01-22
259 reads
How Do You Handle the Stress of Being a DBA?
How do you deal with all the pressures, stress, and problems in being a DBA? Today we have a guest editorial from Brad McGehee that asks the question.
2010-01-21
660 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers