Recently I ran into an issue with the infamous “Cannot generate SSPI context.” I have run into this issue a few times in the past and it is a problem that usually takes a while to find the solution and fix. This problem does not deal with just SQL Server. Usually the help of a [...]
Read the rest of this entry »Transactional replication can sometimes be a tricky high availability option to work with. Many companies are now using it more and more to offload reporting to a different server. But as we know, making schema changes to the tables in a publication is something that must be done when the application changes or different business [...]
Read the rest of this entry »Recently I ran into an issue where I had a SQL Server instance that needed to have a database restored on it. A pretty simple task, right? Well, it turns out that I did not have rights on the system to do the restore. My client did not have a system administrator password and did [...]
Read the rest of this entry »
