Notice anything? swynk@sswug.org < Let me know what you think! Thoughts for Database Naming Conventions Today I have lots of food for thought when it comes to naming things in the Database. The meaning of data as well as the name of the data are frequent questions that have been asked. Some feel that meaning is more important than naming […]
Other News
Managed Service Account–SQL Server 2012
(VidhyaSagar) As you know there are so many security measures are taken during every release of SQL Server. This version of SQL Server will be using Managed Service account to run SQL server related services. In other terms earlier versions we used Local system account as service account for all SQL
Three activities to help your Agile Development
(Dave Beulke) This week I speak at the Kansas City DB2 Users Group about my 22 billion row data warehouse design and the Agile development teamwork. Without the teamwork the project would not have been successfully implemented in only six months.
Migrate DB2 Net Search Extender indexes to DB2 Text Search
(Kavya Rao) In order to leverage the latest capabilities in IBM DB2 for Linux, UNIX, and Windows for full text search, users of DB2 Net Search Extended should migrate to DB2 Text Search. This article explains how to migrate from Net Search Extender to DB2 Text Search indexes, and what to consider wh
Managing Different Physical Implementations of your Relational Data Model
(Jeff Smith) Near the end of a product demonstration with a customer yesterday, someone asked how they could build physical models for each of their different environments using Oracle SQL Developer Data Modeler (SQLDev.)
RMAN: MML Implicit Delete of Needed BackupPieces
(Eric Keen) Recently trial restore attempts of a large RAC 11gR2 database from tape resulted in ”could not locate pieces of backup set key” and intermittent ORA-01861 errors. Puzzled that the backup logs were clean but the restore failed, we dug further and located the specific missing backuppie
Rails Like Templating With XSLT
(Ryan Dew) Recently I have been trying to solve the issue of redundant code in MarkLogic xQuery applications, especially in instances in which the application is a web site or something similar. Sure you can move stuff into library modules, which I still recommend, but if you change the signature of
Computed indexes in MarkLogic
(Rob Whitby) Imagine we have a load of XML in different schemas that we want to query as one dataset. Because MarkLogic is schema agnostic we can just chuck it all in and start querying. That’s great, except if we need to query by date for example, and the documents have different ways of expressing
Passing parameters in dynamic procedure
(Madhivanan) In this post Dynamic PIVOT in SQL Server 2005, I have shown a way to dynamically generate the column values with names. I used to get mails frequently from people on how to pass parameters when executing the procedure.
The Pros and Cons of MySQL Table Locking
(Rob Gravelle) MySQL resource locking and performance go together much like movies and popcorn. Applying table locking at the right time and in the right way can yield very positive results, specifically in a noticeable speeding up of your SQL statements. By the same token, when improperly execute