Resources for Learning SQL Server In this edition of the SSWUG newsletter I respond to a question from Tim regarding learning resources. Tim writes: I’m enjoying your newsletter. I’ve been an oracle DBA for over 10 years and am just now being introduced to the SQL Server world. Your newsletter is a huge help in my transition. You sign off […]
Other News
Accidental DBA Tip ? Manage Transaction Logs
Accidental DBA Tip – Manage Transaction Logs Transaction logs are a key utility for managing the recovery and performance of your database. In most engines, a transaction log maintains a copy of the data being written to your database to assure the integrity of the data. If you want to do more research about what I mean about the Integrity […]
Blooming FLWOR – An Introduction to the XQuery FLWOR Expression
(Dr. Michael Kay) In the previous tutorial in this series I presented a quick 10-minute introduction to XQuery. I started with a number of XPath expressions — because every XPath expression is a valid XQuery — and then went on to introduce FLWOR expressions, the workhorse of the XQuery language.
XmlDataSource – Treeview databind based on Parent – Child xml file
(Steven Derveaux) Do you need to implement an ASP:TreeView in you website based on a xml file with a nice nested Parent – Child structure? I think that everyone already wrote, at least one time in his life, a recursive function to accomplish this but this can be better.
Supporting XML and JSON web service endpoints in Spring 3.1 using @ResponseBody
(Willie Wheeler) In an earlier post I explained how to avoid parallel JAXB2/Jackson annotations when supporting both XML and JSON web service endpoints. Basically the idea was to configure the Jackson ObjectMapper to understand JAXB2 annotations.
COUNT and SIZE of all your documents in SharePoint 2010
(Nicki Borell) There are a lot of use cases and scenarios where you need to know the size and the count of the documents in your SharePoint content database.
DB2 for z/OS Version Migration – Top 10 Issues
(Lockwood Lyon) Thinking about upgrading to a new version of DB2 for z/OS? Of course you are!
How to convert a table dataset to CSV format in SQL
(Frank Zhou) The following SQL pattern can be used to convert the database dataset into CSV format. The query can also handle NULLs in the data columns.
CSS Animations – Basic Hover Scaling
(Duncan Mills) In this first of the detailed articles on the animation prototype I wanted to look at the basic setup of application and the simplest of the animations – the Pick Me! button. The Pick Me! button animates to draw attention to itself as the mouse moves over it. The actual animation it
Understanding Oracle Exadata Smart Scan
(Shyam Varan Nath) Over the years, the efficiency of storage technology and computational power of CPUs have increased exponentially. However, in any larger database system, the interconnect between the two acts as the limiting factor.