Tag Archives: database

The latest version of Cerber ransomware is targeting database applications and putting business’s most valuable data at risk, according to recent reports. Large database applications such as Oracle, Microsoft SQL Server, MySQL and others contain critical data for things like Enterprise Resource Planning (ERP), Customer Relationship Management (CRM) and Electronic Medical Record system. And the latest version is aiming to encrypt all of them in addition to documents, spreadsheets and multimedia files. How Cerber ransomware works Ransomware victims are not chosen on an individual basis. Instead, they’re usually found within…

Continue reading

Full text searching allows more complex searches such as word or phrase searching, inflection matching, proximity searching, and relevance matching to be performed on many different fields within tables.  In order for these searches to run SQL server builds and maintains a catalog. We have such a large amount of data that rebuilding a full text catalog can take as long as 14 days.  We needed a way to be able to bring the full text catalog back without rebuilding it, essentially, I needed a backup.  Microsoft does not backup…

Continue reading

Another certification.  I took the MCDBA (Microsoft Certified Database Administrator) tests and passed them all.  I finished the last one today.  I will take a break from certifications for a while and then pick up on them after a few months.  I may try for CEH (Certified Ethical Hacker) next.  We will see.  For now, I will enjoy the rest of my vacation. 
I put SQL Server on a Windows Server 2003 virtual machine on my new 64 bit laptop but Enterprise Manager would not run.  After some searching, I found a guide that helped me fix the issue.  I had to change permissions on various registry entries in the HKEY_CLASSES_ROOT and then I had to manually register a few dll files.  Quite a number of services and processes had to be stopped during this procedure.  New technology works well with new technology but new technology does not work well with old technology. …

Continue reading

I am always trying to learn something. I really enjoyed learning about programming yesterday and now I want to shift my efforts onto Microsoft SQL Server. I have an install of SQL server 2005 at school and I might have a copy of SQL Server 2000 at home. I plan to study and work with it for the next few months. I have one book on it and some lab manuals. I might order a few more depending on my interest. It feels good to be learning. Ian and I…

Continue reading

Richard Hale and I took my classes on a field trip to the Microsoft offices here in Cleveland for a SQL server event.  They gave us lunch at the event.  It was nice to see the Microsoft facilities but I was not overly impressed with the presentation itself.  The content was a little too technical for the students and some things were too complex for Richard and me to understand.  They showed a few charts without explaining the data which gave the impression that the data was not very supportive…

Continue reading