Blog

(Articles with tag:Remote DBA) - Remove Filter

Do You Use Stored Procedures In MySQL or MS SQL or Any Other Database?

Do you use stored procedures? Some developers said, we don’t use it. Too much of a hassle. We would rather use one development tool to encapsulate all in one set of code. I was interviewing a dot net developer for a web scarping project and I asked him, if he can show me what stored procedures he worked lately. I was amazed to realize that the developer has difficulties to identify different features in MS SQL and basically does not work with any SP. He said all is done within the entity framework and LinQ.

3 Strong Reasons You Need a Software Application Rewrite

One key point is embracing the fact that the product you are selling your clients is not the travel tours. There are certainly other businesses that sell travel tours for students or otherwise. But what makes your clients come to you and not a competitor is the technological aspect of the business. Having a good online presence is important. User satisfaction is the main thing that separates a successful product from a non-successful one.

A Custom Database – Why Does Your Business Need One?

Your business is unique, and that means you need solutions that are designed specifically for your company. So that part of the reason for a custom database is easy to understand. The problem is figuring out how to get a custom database developed when much of the software out there is designed with a one-size-fits-all attitude.

How to stop CPU Spikes as a result of parameter sniffing while the MS SQL stored procedure is executed?

With one of our clients that we provide Remote DBA services, we recently encountered a situation where one of the frequently running stored procedures suddenly started consuming 100% of the CPU on the server.

The 10 Best Features of MS Access to Maximize Value

Is Microsoft Access the database environment that your business should be using? We’re going to take a look at 10 of the most convenient and powerful aspects of MS Access to help you make a decision. The Farber Consulting Group Inc. has the MS Access consultants and developers to help you take advantage of these many benefits and more.

Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?

While working with different software developers, I noticed that some of them still using spreadsheets or MS Word to keep track of the database design. Other developers use the MS SQL Database Diagrams in MS SQL. Visual Studio provides some basic capabilities on the database design. But is that the most productive tool to use?