Tag Archives: Security

A new global threat: Meltdown and Spectre

Posted on January 9, 2018 by mauriciorpp

Yes, the post title is singular, but there are two threats. It’s a joke, because both are kinda similar. In this day and age, we all should be familiar with the importance of digital security. Almost every year there are … Continue reading →

Posted in Uncategorized | Tagged , | Leave a comment

To the cloud: Amazon AWS free access

Posted on July 19, 2016 by mauriciorpp

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

Posted on October 5, 2014 by mauriciorpp

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.

Posted on May 3, 2013 by mauriciorpp

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

Posted on April 17, 2013 by mauriciorpp

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 , , | 2 Comments

“Alter User with login” equivalent in SQL2000

Posted on April 5, 2013 by mauriciorpp

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

Posted on January 30, 2013 by mauriciorpp

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

Posted on August 29, 2012 by mauriciorpp

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

Posted on August 21, 2012 by mauriciorpp

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

Posted on August 15, 2012 by mauriciorpp

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