(Jack Vamvas) Creating a backup and restore policy based on service level agreements, Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) is a critical part of DBA work. Another long-term but important Backup and Restore component is devising a Backup Retention Policy.
Author: SSWUG Research
Creating Fixed-Width Data Files
(Richard Carr) Fixed-width data files are an alternative to comma-separated values (CSV) for storing and sharing tabular data. The information in a fixed-width data set tends to use more storage or bandwidth than CSV but is more readable to humans.
Duplicate Validation Error Message and ADF Bindings
(Andrejus Baranovskis) One of the bug requests I was fixing during this week was related to duplicate validation error message display on ADF UI. This was quite annoying to the users – the same validation error message displayed twice:
Clickable SQL*Plus Errors
(Barry McGillin) Running lots of scripts in SQL*Plus is nice when they are working correctly. But what about when they fail? Its a pain to figure out what went wrong, unless you have a log file and even then, you have to hunt the errors down.
Raw Columns
(Andrew Reid) This was tested on Oracle 11.2. You can use a raw column to store binary data:
Five Ways to Improve Your Productivity with SSMS
(Matan Yungman) For most DBAs, Management Studio is the primary work tool.
Example: Converting the Kennedys Ontology to schema.org with SPINMap
(Holger Knublauch) With schema.org’s growing popularity, I thought it was a good idea to validate and illustrate how it can be used as a shared base ontology for various use cases. At TopQuadrant we have been using a Kennedys Ontology in training and example material for many years.
Combine Rows with FOR XML PATH
(Linda Lin) We can use FOR XML PATH to combine rows.
10 Tips for the SQL Server PowerShell Scripter
Microsoft Scripting Guy, Ed Wilson, is here. Today’s blog is a bit unique. I was throwing around ideas with Chad Miller, and somehow we came up with the idea that he would share some tips for the SQL Server Windows PowerShell scripter.
How to Identify and Fix Incorrect SQL Server Operator Settings
(Chad Churchwell) As DBA’s we rely heavily on email notifications when things go wrong in our environment such as failed jobs or alerts. In practice this is usually done through Operators in the SQL Server Agent. Recently I was working with a client and noticed a job that had been failing for as far