Sorry, the reference to ACID in my previous blog was inserted into the code section. In case you were wondering, ACID is an acronym for “Atomicity Consistency Isolation Durability” which are the 4 properties of a database transaction (or at least a good one). I'll explain if I get any requests. Note to self: always click Preview before posting
Read More
I can truly say that Brian Knight has a great thing going with the Foundation Class at Pragmatic Works. Thanks to his brother Devin, our teacher this week, I know the that skills I have learned in SQL Server Management Studio and SSRS will enable me to excellerate my learning and get me to the next level in BI. The sky is the limit because of the strong foundation. I have always liked working with computers and SQL gives me the perfect tool to persue my passion. I can’t wait! Here is a multi to ...
Well, day 4 has come and gone (except for the homework) and thanks to Devin's excellent facilitating we are creating reports with ease. I suppose that means we're ready to be dropped off for work somewhere (Anybody looking for a top-shelf graduate of SSRS?). In the process our Padawan showed us a slide show that really explained the difference between JOIN and LEFT JOIN and RIGHT JOIN. When I get the link I will blog it, so come back if you are having trouble understanding JOIN's.
If nothing else I am figuring out how to write blogs. But...there is a lot of else! Today we created our own DB from scratch based on the game BATTLESHIP. After a few innocent insults about age, genger, etc., we came up with a really complex DB design (at least it was complex by our standards... Look at it here and you decide.) We also created our first report and I discovered how see more of what I was working on by filling the screen by pressing ALT-SHIFT-ENTER. Try it. The fun has really star...
It's really getting fun. Today I demonstrated how to CREATE and ALTER a Stored Procedure Here's the one I did: CREATE PROC usp_ResaleDate (@StartDate datetime,@EndDate datetime) --exec usp_ResaleDate '1/1/2000', '1/1/2009' AS SELECT R.ResellerName, SUM(f.OrderQuantity), SUM(f.SalesAmount) FROM FactResellerSales F JOIN DimReseller R ON R.ResellerKey=F.ResellerKey JOIN DimDate D ON D.DateKey=f.OrderDateKey WHERE d.FullDateAlternateKey BETWEEN @StartDate AND @EndDate GROUP BY R.ResellerName To ALTE...
Has anyone tried to attach murach's sample DB for SQL Server 2008? I tried by using the "simple" steps outlined in the book and got these errors: Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file "C:\Murach\SQL Server 2008\Databases\AP.mdf". Operating system error 5: "5(Access is denied.)". Msg 5120, Level 16, State 101, Line 2 Unable to open the physical file "C:\Murach\SQL Server 2008\Databases\AP_AllObjects.mdf". Operating system error 5: "5(Access is denied.)". Msg 5120,...
Devin just finished pouring as much as he could into our brains. It started easy and progressed to more difficult as the day went on. At this rate we will know everything about the known universe by Wednesday. Thanks Brian for giving us this great opportunity for training.