2 Resources for

mmiller@...

Sponsored White Papers, Webcasts, and Downloads

Removing dashes in excel: I have a 12 digit code with a dash after the 4th and 8th digit. I need to remove the dash but when I select edit remove it changes the number to an error. For example, the cell 1234-5678-9012 would now look like 1.23578E+11. The column width...; Tags: mmiller@..., cell; Discussion threads 2007-09-18
Calculate columns and averages with SQL Server's HAVING clause: The HAVING clause is used often with one table.First, thank you for your article. It is very useful and informative and I will keep a copy for reference.However, I disagree with your statement "Strictly speaking, HAVING does not require a sub-table, but using it without one is pointless. If all...; Tags: feedback, Group-By, Microsoft SQL Server, mmiller@..., server; Discussion threads 2007-01-23

Server System Inventory Form: It's a good idea to document as much as you can about your server while it's up and running so you won't be left in the dark should a disaster occur. This one-page form includes space for delivery information and server specifications.; Buy Now

IT Hiring Kit: Database Administrator: The IT Hiring Kit for Database Administrators will help you interview, evaluate, and select suitable candidates for a DBA position. This kit comes wit ...; Buy Now