Boston – Code Camp #24

I am excited about the opportunity to present at Code Camp 23 in Boston. It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on November 21, 2015 at the Microsoft New England Research & Development (NERD) building, One Memorial Drive, Cambridge, MA. Below are the details for my presentation. Press Release: Microsoft just released The Power Business Intelligence Desktop Designer. Join us as John Miner, Microsoft SQL Server MVP, demonstrates the new amazing capabilities…

Boston – Code Camp #23

I am excited about the opportunity to present at Code Camp 23 in Boston. It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on March 21st, 2015 at the Microsoft New England Research & Development (NERD) building, One Memorial Drive, Cambridge, MA. Below are the details for my presentation. Topic: Azure SQL Database – Software As A Service Abstract: Are you tired of installing, configuring and patching Microsoft SQL Server? Azure SQL database maybe…

Boston – Code Camp #22

I am thrilled about the opportunity to present at Code Camp 22 in Boston. It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on November 22 nd, 2014 at the Microsoft New England Research & Development (NERD) building, One Memorial Drive, Cambridge, MA. Below are the details for my presentation. Topic: Effective use of temporary tables Abstract: Every developer eventually comes against business logic that can’t be handled with a single simple or complex…

Boston – Code Camp #21

I am excited about the opportunity to present at Code Camp 21 in Boston. It will be a good time to meet old friends and make new ones. I hope you have time to attend this awesome free event on June 21 st 2014 at the Microsoft New England Research & Development (NERD) building, One Memorial Drive, Cambridge, MA. Below are the details for my presentation. Topic: Basic Database Programming Abstract: You just found out that a client needs a SQL database to be designed from scratch. However, you existing…

SharePoint Saturday – Boston 2014

I had the pleasure to attend the SharePoint Saturday (SPS) conference on April 12th at the Microsoft Office in Cambridge, Boston MA. I am truly interested and passionate about MS SQL Server developer products (SSDT, SSIS, SSAS, SSRS); However, I do support SharePoint at my day job. This was a great opportunity to learn more about how to configure SQL Server for SharePoint. There were a handful of sessions on MS BI products deployed in a SharePoint environment. Here is a list of sessions that I attended and really liked….

2014 Goal Statement

I just finished blog entry two hundred seventy in December 2013. It is quite an accomplishment since it takes one or two hours to research and design to compose an good article. I figured it was time to reset my goals for the upcoming year. Here is what I am planning for this year. 1 – Have answered a total of 400 questions at Stack Overflow. My total right now is 188 answers. That means I need to respond 212 times in the next year. 2 – Have completed a…

Pragmatic Works – Performance Tuning

I had the opportunity last week to attend the SQL Server Performance Tuning Workshop by Pragmatic Works Learning Center. I definitely recommend this workshop. This is the second class I have taken at the Microsoft New England Research and Development Center located in Cambridge, MA. It is conveniently located right off the Kendall station stop on the Massachusetts Transit Bay Authority (MBTA) Red Line. The main instructor for the class was Bradley Ball aka SQLBalls. He was a very likable speaker possessing good presentation skills as well as a wealth…

Using Password Safe

One of the daily tasks of a database administrator is the granting and the maintaining of access to the fleet of databases under your charge. It is important to to keep track of all the system administrator accounts and passwords as well as any application ones requested by developers or end users. Another important aspect of security is making sure that passwords are strong enough to meet your companies audit requirements. Why even use a password if it can be easily hacked? Today, I want to go review how the…

2013 Goal Statement

I just finished blog entry one hundred yesterday. It is quite an accomplishment since it takes one to two hours to research, design, and compose an article. I figured it was time to reset my goals for the upcoming year. In the next thirteen months, I will be focusing on the Microsoft SQL Server Stack: Database Engine, Integration Services, Reporting Services and Analysis Services. I will of course throw an article off topic from time to time when it suits me. During this time I also want to update my…

Virtual Box – FTP Server Settings

I am continuing work on PROJECT ALPHA which is chartered to create a test environment for a PERL based Etract Translate and Load (ETL) solution. If you have correctly followed the previous Oracle Virtual Box articles, a working guest image of Windows 2008 Server now exists with the IIS 7.0 Web server role installed. Today, we are going to concentrate on configuring the FTP server. A local windows user account will have a home directory containing the test data file for the Perl program. The series of screen shots below…