Tag Archives: Security

To the cloud: Amazon AWS free access

Ok, so┬álet’s be fair to everyone: AWS also has a “free level” for you to create a few VMs and learn how to manage things there. I highly reccomend that you get to learn both AWS and Azure. https://aws.amazon.com/free/ Happy … Continue reading

Posted in AWS, Azure, Cloud | Tagged , , , , | Leave a comment

Talk about MS-SQL, Oracle, NoSQL and Babylonian accounting tablets

Looking at the past can teach us a lot of things. This is a great way to know more about the things you like. And this is a great article about some fundamental characteristics of the major database systems today. … Continue reading

Posted in MongoDB, MySQL, Oracle, SQLServer | Tagged , , | Leave a comment

SQL Server security: Managing logins using stored procedures.

If you are a concerned DBA, you know that the rule of “least privilege” must be followed at all times. Even if something is not perfect right now, this is the direction to go and every step in that direction … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

SQL and Linked-Servers: The SCHEMA LOCK permission was denied on the object

While debugging some legacy applications, I’ve come to this error. The exact message is: I suspected some permission related issue (that is very common with linked-servers). A quick┬ásearch later confirmed it, but as documentation is pretty rare on this issue … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

“Alter User with login” equivalent in SQL2000

By now, most DBA’s must be familiar with “Alter user with login” command from SQL 2005 SP2 and above. But when only SQL 2000 existed we had to do a lot more things manualy. Migrating logins/users has always been a … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

SQL – Database in Emergency Mode

Who never experienced a critical failure of some server that resulted in database corruption? There are times that the unthinkable happens, be it with physical or virtual servers, and there will always be a weaker link somewhere in the service … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

Change DB Owner in SQL Server

Sometimes some hidden configurations mess up with the management of our SQL Database Servers. One great candidate to do this is the “Owner” property of the databases. Not that the property will cause some issue by itself, but the default … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

Changes in maintenance plan overwriting SQL job ownership

Sometimes some things strange happens. Usually when you are trying to fix other things. This issue happened to me when revising some SQL Agent jobs to make sure all backups were running fine. I removed to old DBA account from … Continue reading

Posted in SQLServer | Tagged , , , , , , | Leave a comment

Originally posted on DBA By Day, Gamer By Night:
It embarrasses me to say that this happened again recently. We were building a new SQL Server 2005 server & locked it down before we had added our Administrator group &…

Posted in SQLServer, Windows | Tagged , , | Leave a comment