SQL Archives - Page 191 of 519 - SQL Authority with Pinal Dave

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

December 25, 2013

Notes from the Field, SQL Backup and Restore

[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 – A Career in Database Forensics

December 24, 2013

Pinal Dave

SQL

SQL Training

A growing field in the information security domain – Database Forensics offers a comprehensive and highly sophisticated skill set that allows professionals to uncover and trace data security breaches of the highest order and complexity. Many enterprises are looking to hire such professionals nowadays.

SQL SERVER – Learning More About SQL Wait Stats

December 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

I was recently visiting my customer for my day job in Delhi. During the meeting, I had a great time to meet a few of the technical domain experts of the leading organization. We discussed lots of different things while we were there and much of the conversation was surrounding…

SQL SERVER – What Permissions I have on Database I am Connected to?

December 22, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security

Here is the first thing I do when I get access to any new server – I check what are different permissions I have with respect to the database I am connected with. The matter of the fact is that most of the database consultants and administrator want to know…

Developer – Nine Things Developers Hate to Hear

December 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Humor

1. Uh oh… No one likes hearing this – not parents, not repairmen, not developers. They don’t like hearing others say it, and they don’t like hearing it come out of their own mouths. It usually means bugs. 2. Can you fix my computer? This question is the bane of…

SQL SERVER – Redundant Indexes Good or Bad – Final Wrap – Part 7

December 20, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

This is the seventh part of a series regarding Redundant Indexes. If you have not read the earlier parts – there is quite a good chance that you will miss the context of this part. I suggest that you should quickly read the earlier four parts. On my production server…

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

December 19, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…