Firewalls help protect the surface area of the SQL Server and prevent unauthorized access to resources. Listed below are some common SQL Server ports to configure for Windows Firewall.
Read moreHTML5 has some great new changes. Here is a list of thirteen new tags and the purpose of each.
Read moreMany experts agree that memory is the most important resource with regard to SQL Server performance. There are hundreds of performance counters, and therefore, it can be complex to figure out just what to monitor. Here are some suggestions in understanding whether memory pressure might be the performance problem with your SQL Server. You can use Performance Monitor to collect this data. You can also obtain the SQL Server specific counters using the Dynamic Management View (DMV) that is built into SQL Server. The DMV is an excellent and lightweight option for performance monitoring. You can use this syntax.
Read moreThere are a few terms that often are confused in SQL Server. These are locking, blocking, and deadlocks. These are all very different from each other.
Locking is a normal and desirable process. Blocking is also normal, but is less desirable. Deadlocking is not a normal process and is never desirable.
Read moreUsing keyboard shortcuts lets you do more work faster. One of the best ways to work faster is to utilize your keyboard and the shortcut options it provides. Here are some basic keyboard shortcuts that will help make your SQL work faster and more efficient.
Read more