Author Archives: richardcbeck

Ester Cohen poem

i have few memories of being young. I remember walking in the fields with my father, and having him tell me to look at the birds flying and looking around wildly, trying to find them. My father was greatly relieved … Continue reading

Posted in Uncategorized

XML Shredding to SQL

The article in the simple-talk newsletter continues on talking about XML shredding, specifically using XQUERY rather than OPENXML.  The result of the shredding is that the XML is deconstructed into a typical database table. Basically, you do a traditional select … Continue reading

Posted in Uncategorized

mySQL dos batch file to import

We have to hack into a mySQL database. After i have created a number of powershell\sql scripts from the SQLDUMPfile, some to create tables and others to import data, we have to LOAD those script, which are in fact sql … Continue reading

Posted in Uncategorized

interesting use of temp table

i am not King of the temp tables, although i seem to use them alot. Currently, i am extracting data into a series of temp tables to prepare a data-set to save into a standard database table.  The first step … Continue reading

Posted in Uncategorized

MS SQL 2014 cardinality estimator

Apparently, MS SQL 2014 has a new cardinality estimator. Goodie. Ah, what was the old one? And why is it a cardinal and not a blackbird or robin? The Query Optimizer picks among one or more query plans to pick … Continue reading

Posted in Uncategorized

string and not a string

The ‘preferred’ way to send email to several people from powershell is to use the send-mailmessage cmdlet.  In our environment, the server needs to be identified as an acceptable server (that is done in a group in the BigIP local … Continue reading

Posted in Uncategorized

photoroster and attendance

We have a page of students for each class.  It is currently done in asp/vbscript, although that could change.  Boss wants to turn this into an attendance form.  Click on the student image and mark them as present/absent.  I initially … Continue reading

Posted in Uncategorized