Month: September 2018

Moving the System Databases Sql Server

I found a great article that was succinct and concise and it talked about many of the different options for moving system databases around in Sql Server. I am just glad that this process has gotten easier over the years. I am also glad that the SSISDB was created so we didn’t need to RELY…

SQL Server 2019 new features

I was amazed to read that Sql Server 2019 can now use idea file system as the storage engine. hasn’t Sql Server introduced some amazing features recently? ZDNet: The big data odyssey of SQL Server 2019, and more data and AI news from Microsoft Ignite. https://www.zdnet.com/article/data-and-ai-news-abounds-at-microsoft-ignite/

Speeding up wildcard searches

I ran into this article today, and I had to share. Storing the string in reverse format (and indexing it) allows you to find partial matches, quicker. It’s a good solution: Faster SQL Server Wildcard Search We could use an alternative method to get the same result more efficiently with an index seek. See the…

GitHub MySQL High Availability

Reading about the mysql environment at github, I was surprised to hear that they have 15tb of data in mysql. I was more amazed to read that Github has 15 different clusters for MySQL. I wonder why they have so many? I used to work on an Operational Data Store database that had a daily…

Financial Accounting with Odoo

I was surprised to look at Googke News and see an article that showed that Odoo is wildly popular. The book ‘Financial Accounting with Odoo’ actually has climbed to be the #1 New Release on Amazon. I always knew that Odoo is an amazing product. I think that more companies should consider Odoo. Today I…

Quick Quiz About SQL Server Indexing

Wow this survey has some interesting questions. I was happy that I got an 80% score on my first try. I think that in general, indexes are the first and the most important thing to implement correctly if you want good performance. Of course, most of the people that I’ve worked with are actually terrified…