SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
So you are not a database expert. In fact, you just inherited this job of taking care of your company’s database, or maybe more than one. It makes sense to you to keep things running smooth, but you don’t know where to start. Today let’s talk about a helpful tool that ships with SQL Server that can help you implement […]
If you think about the contents of a Disaster Recovery Plan, you will quickly come to realize that all persistence requires a plan. It doesn’t matter if it is NoSql, files, a Self Managed SQL Instance, or even a cloud hosted platform such as SQL Azure. Let’s take a quick review of some of the components of a Disaster Recovery […]
I’m surprised by the lack of comment on this subject. Caring for your SQL server can be important for almost any installation. Even when you are purchasing platform as a service features such as Azure SQL, you still need to have care in making sure you don’t have an outage. Let’s start with the basic first area you must implement […]
Back in the days of running Novell, I remember the administrators comparing their skills by the amount of time a server could be online without restarting. Thirty days was a good time. Some guys even ran as long as six months. This was a badge of pride, and even an edge on a resume if they needed to look for […]
Using XML as a SQL Server parameter has been popularized for quite some time because it is a very flexible method of passing data. It allows you to pass scalar properties. It can also pass in one or more sets of data along for the ride. It is completely flexible. JSON works pretty much the same. There are some things […]
Recently I have been working on optimizing API calls to squeeze out as much performance as I can get. I’ve come to open the question regarding the use of Asynchronous calls for everything. There is some overhead associated with utilizing Async methods. You can actually measure the difference in your API performance when your method calls are very fast to […]
Using XML as a SQL Server parameter has been popularized for quite some time because it is a very flexible method of passing data. It allows you to pass scalar properties. It can also pass in one or more sets of data along for the ride. It is completely flexible. JSON works pretty much the same. There are some things […]
As we have been talking about different ways of optimizing database queries it reminded me of different ways to optimize application performance when it comes to returning data to the application tier. There are two schools of thought with different strategies. Some applications retrieve data on demand, a lazy load approach. Others may choose to use a approach, retrieving lots […]
What I’m going to write today is pretty obvious. However, I can’t believe how often I get it wrong. When applications begin to have performance issues…what is the first thing you suspect? In many cases the immediate suspect is the database. What’s interesting to me is that the last few times I have been working with systems supported by SQL […]
I’m having a hard time realizing what I am going to write today. It goes against what I have experienced for years. And it explains why some of our auto generated tools have continued to be adopted. I shared some tips on optimizing data transformations for an MVC application where the data returned to the client is shaped according to […]