(Eli Leiba) I/O is one of the most time consuming activities in SQL Server. If you can reduce the I/O wait time then you can improve performance. This can be done with indexing and tuning queries, but I/O issues may also be at the file level. In this tip we look at how to identify specific files
Other News
MOCK your GUI
MOCK Your GUI I love this caption. I’m sitting here picturing a developer looking at a screen someone designed and saying something like, "My 2 year old son could design something better than that with crayons." But that’s not where I’m going with this. In my experience, the most difficult piece of software to test is the User Interface. Graphical […]
What is a business rule really?
SelecTViews WIth Stephen Wynkoop All the news of the day that counts is provided here.. also, find out about normalization, what types of skills might be good for specialization and upcoming learning events…We keep you informed and up to speed on tips tricks and more. [Watch the Show] What is a business rule really? Now we’re really getting down to […]
Extracting Data from XML without writing XSLT
(Simon Ward) If you have ever tried writing an XSLT to import data into filemaker, you will know that it is not very easy, unless you know XSLT in detail.
Learn the language of Semantic Web
(Priya Parvatikar) Learning the lingo and getting to grips with technical terminology isn’t critical to understanding the concepts behind Semantic Web, but studying the basics will certainly help! So if you’re tormented by Triples, mesmerised by mash-ups or oblivious on ontology, here’s an introduct
Should You Switch from IBM’s SQL Replication to Q Replication?
(david t) SQL Replication is a data replication technology that’s been around since the early 1990’s. It’s improved considerably since its early days, but IBM’s Q Replication is newer and has developed an excellent reputation for high performance, continuous availability, and database migration. N
DB2 — What’s in a Name?
(Craig Mullins) Versions of DB2 exist for a large array of platforms, of which the mainframe (z/OS) is only one. Of course, it is my favorite one since I’ve been working on mainframe technology now for decades and have worked with DB2 since Version 1.
Missing information in SQL*Plus
(Martin Widlake) By preference I like to work against the databse using SQL*Plus. GUIs are fine and they are much better for developing code than using sql*plus and notepad (or vi or whatever ascii text editor floats your boat). However, for finding things out quickly and also storing what I find (v
Anonymous PL/SQL blocks
(Scott Wesley) Some of you may be familiar with the ability to administer Apex applications via SQL Developer, for instance I could modify the alias of my application thusly:
SQL SERVER – Management Studio and Browser in Same Application
(Pinal Dave) First of all – I must confess that I was not aware of this feature till I noticed it today. At home I have multiple monitors but when I am traveling I have single laptop along with me.