As part of the Database Health Monitor version 2.1 release there were many new report includes, one of those was the backup status report. A quick way to page through all of your SQL Servers and check on the status of backups. Here is an example of the backup status report showing a database that hasn’t had any recent backups, …
Coming from a SQL Server, and PHP background, I often get asked, does SQL Server work with PHP? The answer is YES. I have been using SQL Server and PHP together in a high availability load balanced environment with multiple data centers for the last 4 years. Microsoft offers drivers that plug into PHP to allow the connectivity. You get support …
One of the common questions that I get asked after my Unleashing CTE Presentation is “Can we use CTEs in SSRS reports?” The answer is YES, Common Table Expressions work great in SSRS reports, one of my favorite ways of cleaning up some of those big ugly SSRS report queries is to use CTEs.
Before proceeding with the article, please take this quick password safety test. Password Safety Test – Score one point for every YES answer.: Do you write your passwords down? ( YES / NO ) Do you ever re-use a password on multiple systems or websites? ( YES / NO ) Are your passwords shorter than 8 characters? ( YES / …