Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but I did have a developer email me with a problem she was having. (I do believe she may have been the only one actually working, can you imagine??) But that’s ok, I love using this […]
Good morning SQL people! It’s time for another installment of SQL Server A to Z. We’re up to the letter O, which immediately brings to mind the song from Sesame Street, “Would you like to buy an O?” (Circular and sweet. “O” looks just like a donut. Really good enough to eat…) You’re welcome. OPENQUERY […]
When the cheers subsided and the parade was over (oh yes, there was a parade; complete with floats and bagpipes), the DBA found herself dissatisfied. There was a minor detail that was nagging at her. What about those linked servers that used an alias? With her original query, the remote server would be the alias […]
Once upon a time there was a developer who was concerned about the security of his application’s data. So he decided to change the password for his application’s SQL login. So he logged into the database and used sp_password to change his password and he was happy. On the other end of the hall lived […]
This week I’ve been chasing my own white whale. Another developer came to me with this little problem. A query he was trying to run over a linked server to an Oracle database was returning unexpected results. Here’s his original query: select count(order_num) from openquery(PROD, ‘select t2.order_num from myschema.mytable t2 where open_date < to_date(”01-JAN-2011”, ”DD-MON-YYYY”) […]
