SQL Backup and Restore Archives - Page 8 of 19 - SQL Authority with Pinal Dave

[Notes from Pinal]: During my presentation, I always ask developer a simple question – When did you take your last database backup? I get two different kinds of answers – 1) few replies with No Idea and 2) few replies with some date time. When I further ask if they…

SQL SERVER – Expanding Your Skills – Notes from the Field #015

February 13, 2014

[Note from Pinal]: This is a fifteenth episode of Notes from the Field series. We all want to learn more and progress in our career. It is human nature to look for change and variety after a while. In most of the cases, it is quite easy to move inside…

SQL SERVER – Learning SSIS – Where Do I Start? – Notes from the Field #014

February 6, 2014

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. As wikipedia says – It features…

SQL SERVER – Tools for Proactive DBAs – Policy Based Management – Notes from the Field #012

January 23, 2014

[Note from Pinal]: This is a 12th episode of Notes from the Fields series. When taking a vacation the biggest worry any DBA has it that in their absence what will happen to their database. They are often worried that something will go wrong with their server or some users…

SQL SERVER – Check for Database Integrity – Notes from the Field #011

January 16, 2014

[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