SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
Today we are going to unpack some details wrapped around things you would want to know when building a Database Maintenance Task for statistics using the Database Maintenance Task Wizard. As a background regarding statistics, it is important for you to know that Statistics are used by the SQL Server Query Analyzer to determine the best execution method out of […]
Today we are going to unpack the next feature of the SQL Server Database Maintenance wizard which targets indexes. This is a topic I cover a lot, because keeping your database table indexes in tune is a key factor for database performance. This probably one of the most important capabilities in the Database Maintenance Task Wizard tool we are going […]
The next option in the Database Maintenance Wizard is to shrink a database. This is an option that I don’t recommend creating, no matter how tempting it is, without really understanding and knowing what you are doing. So, let’s talk about how I have come to that conclusion. First, let’s talk about how a database acquires space that may be […]
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 […]