Rob Farley is doing a live meeting this month on understanding what SARGable means. It is at 1pm BST and so if you are in the UK will be a very useful hour spent. for more details go to http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=341 The description of the session is Understanding SARGability (to make your queries run faster)…
Tnsnames.ora [DOCS] is a configuration file for SQL*Net that describes the network service names for the databases in your organization. Basically, it tells Oracle applications how to find your databases.
This post is just a quick overview on how to get SQL Developer to ‘see’ this file and define a connection.
There’s only a single prerequisite…
I am person who always asks myself ”Did I lock the house door?”, And I do ask that question when I have almost reached office. I don’t have a bad memory or I am not a “forget it all after a min person”. Infact I have a fantastic memory of things. This problem has been haunting me for a very long time. My wife used to always have a…
Can’t afford an iPad or it’s not yet on sale in your country? Don’t worry. You can upgrade your iPhone to iPad at free of cost. Wondering how? Here it is.
via appadvice
Join us on Facebook to read all our stories right inside your Facebook news feed.
We will be deciding on the sessions tomorrow (Tuesday
8th March) so make sure you get your session in for SQLBits quick.
Don't forget we are focussing on performance an scalability so make sure your
session covers one or both of these.
To submit your session
Step 1 - Complete your Speaker Profile
Step 2 - Submit My Sessions
We will be deciding on the sessions tomorrow (Tuesday
8th March) so make sure you get your session in for SQLBits quick.
Don't forget we are focussing on performance an scalability so make sure your
session covers one or both of these.
To submit your session
Step 1 - Complete your Speaker Profile
Step 2 - Submit My Sessions
<b>Ubuntu Geek:</b> "Download videos from various Flash-based video hosting sites, without having to use the Flash player. Handy for saving videos for watching offline, and means you don’t have to keep upgrading Flash for sites that insist on a newer version of the player."
Something that is sometimes forgotten by a lot of DBAs is the fact that database log files get fragmented in the same way that you get fragmentation in a data file. The cause is very different but the effect is the same – too much effort reading and writing data.
Data files get fragmented as data is changed through normal system activity,…
If you’ve got an environment which is at the end of an unreliable or slow network connection, or isn’t connected to your network at all, and you want to do a deployment to that environment – then pointing SQL Compare at it directly is difficult or impossible.
While you could run SQL Compare locally on that environment, if it’s a server –…
Don't miss the opportunity to hear Wade Hilmo, IIS' principal development lead, at Tech Ed Europe, 26 June 2013 in Madrid, Spain at the IFEMA – Feria de Madrid Convention Centre. Wade will be presenting the latest about IIS in Windows Server 2012 R2, bringing his special insight from his years leading the development team. The full…
Ubuntu notifications are great, but some applications can get annoying by popping up things you don’t care about. Here is how you can disable, or enable, specific notifications for Pidgin.
Whether you only want notifications when buddies sign on and off, or you only want new message notifications the libnotify plugin allows you to…
In this Issue: Brian Genisio, Michael Washington, Fons Sonnemans , Don Burnett, Xianzhong Zhu, Mike Snow, Jesse Liberty, Victor Gaudioso, David Kelley(-2-), and Matias Bonaventura .
Shoutout:
Anoop has a good post up: MEF or…
Google Play is full of task managers for Android. These utilities can show you apps running in the background, kill running apps, and otherwise manage your apps — but you don’t need to install any third-party software to do this. We’ll show you how to quickly and easily kill and manage your running apps using only the software…
I was tempted to throw in another Dora the Explorer Map reference here, but I came to my senses.Having trouble finding something? Maybe you’re just getting older? I know I am. But still, it’d be nice if my favorite database tool could help me out a bit. Hmmm, what’s this ‘Find Database Object‘ thing over here…sounds like a…
We’ve previously covered the standard ways to free up space on Windows. But if you have a small solid-state drive and really want more hard space, there are geekier ways to reclaim hard drive space. Not all of these tips are recommended — in fact, if you have more than enough hard drive space, following these tips may…
For the latest news and happenings in the IIS community over the past month, be sure to check out the September edition of the IIS Community Newsletter: http://www.iisnewsletter.com/archive/september2012.html Make sure you don’t miss an edition and get it delivered directly to your inbox. You can subscribe at the…
The latest release of Google Chrome has geolocation enabled by default, and if you are worried about privacy or just don’t want websites to prompt you for your location, we’ve got the quick details on how to turn it off.
Readers should note that the new Geolocation feature doesn’t give out your details by default, so…
IN contintuation to SQL Server 2008 R2 announcement here is the good news for MSDN & Technet subscribers, see here_for_more, Don't forget to uninstall the previous & current SQL Server 2008 R2 CTP releases (by taking database backups) and install afresh for further testing. Good luck.... more to come on R2…
Apologies for slacking on the blogging front here lately. Still mentally hung over from Open World, and lots of things going on behind the scenes here in Oracle-land. Whilst (love that word) blogging is part of my job, it’s not the ONLY part of my job
So a super-quick and dirty ‘trick’ this morning.
Copying…
The skill set needed by a DBA can be quite diverse at times and a run in with SSRS 2005 probably illustrates the point quite well. I don't have skills in IIS although I was responsible for the design and deployment of an online mortage application site some years ago.I had to get hands on with IIS5,…
Progress bars are pretty much ubiquitous these days; we’ve even seen them on some water coolers. A progress bar provides instant feedback on a given process, so why not bring some of that graphical pizzazz into your spreadsheet, using Excel’s Conditional Formatting feature?HTG Explains: What Are…
Now I know why, but what I'm thinking is that if I create an error should I get valid data returned? To explain, I was browsing through the dmvs for queries which might benefit from tuning and I identified a query with two clustered index scans ( table scans ). I don't know all the schema off by…
There a lot of companies on the Internet vying for your online storage needs. Although pricing should always be a consideration, don?t be lured by cheap packages aimed at getting you in the door. Mak... [Author: David H. Scott - Computers and Internet - April 02, 2010]
You don’t have to wait for the iPad. This versatile tablet PC from Fujitsu reads both stylus and freehand, multi-touch gestures, and it weighs in at 4.5 pounds.