Notes from the Field Archives - Page 19 of 20 - SQL Authority with Pinal Dave

[Notes from Pinal]: There is always scenario when we suddenly end up having an error in our database query which is related to database integrity. We see error where SQL Queries are not executed due to there is corruption in the database file. When we see this happening, in many…

SQL SERVER – Auditors, Passwords and Exceptions – Notes from the Field #010

January 9, 2014

Notes from the Field, SQL Backup and Restore, SQL Server Security

[Note from Pinal]: This is a 10th episode of Notes from the Field series. Every other day, I read online about various security breach happening worldwide – some have lost passwords, some have lost phone numbers and some have lost credit card information. Security is the most important aspect of…

SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009

January 2, 2014

[Note from Pinal]: This is a ninth episode of Notes from the Fields series. If you are DBA and Developer there is always a situation when you want to execute the same query on multiple servers. This can work out very well if you have a servers in single digit,…

SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health

December 26, 2013

Notes from the Field

One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same. Inceptions of Notes from the Field There are two aspects of any technology…

SQL SERVER – Overall SQL Server Performance – Not Just Query Performance – Notes from the Field #008

December 25, 2013

[Note from Pinal]: This is a new episode of Notes from the Field series. When SQL Server is slow we think we can improve the performance of the server by just increasing the performance of queries. However, sometimes the queries are already doing good and there is no increase in…

SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007

December 19, 2013

Notes from the Field

[Note from Pinal]: This is a seventh episode of Notes from the Field series. The biggest issue any DBA have with their server is the health of it. We all want to configure our server optimally and know any issue with it if it faces one. This is one of…

SQL SERVER – Optimal Memory Settings for SQL Server – Notes from the Field #006

December 12, 2013