Blog

(Articles with tag:MySQL Administrator) - Remove Filter

How to Insert Carriage Return or Line Break Or Tab into a string in MS SQL Server

From some reason when I first ran MS SQL 2016 I realized when I run some code with Carriage Return Return and Line Break it stays in one line after coping that into a note pad or below the SQL code in Microsoft SQL Server Studio. So, what happened here? After digging deep into it I found out that this feature that worked as default from MS SQL 2014 and below is not working as a default feature anymore. You need to set it up in order to make that work.

MySQL Remote DBA Consultant helped the client to scale up

We got an urgent call from a new client that has many clients of its own. They do have a SaaS application with more than 1000 clients. Our consulting firm provides MySQL and MS SQL as remote dba services. They needed help with MySQL database right away. Imagine the client has SaaS app with more than 1000 clients of his own. For every client there is one dedicated database. Obviously, the client created a nightmare maintenance for himself. Just to spice up the situation every database seems different then the other one. Either the indexes are different, or in some cases some columns in certain tables are different. A Real mess!

Can you optimize my ms sql or mysql database?

Probably the most common request a DBA can get is to optimize a database or to perform a performance audit, which is really just another way of saying the same thing. The idea behind this request seems simple enough – you're the expert on databases. I have a database, please tell me if my DB is running as it's supposed to.

Optimize your sql query for best search result

When developing solutions that require querying large amount of data, you may want to consider user Stored Procedures. When accessing multiple "query patterns", you want to program your system to use the most efficient algorithm to return your data to the user. While using dynamic SQL may work for small databases, a preferred method would be to use a Stored Procedure to optimize performance.