|
|
Tip: Please be sure to add newsletter@sswug.org when configuring your email filters.
Brian Knight, Scott Golightly on SSWUGtv, Social Networking Feedback
New Show Posted
SelectViews - Today's show is an interview with two different people - Brian Knight and Scott Golightly. Find out about things they see in the field, how they approach their respective technology areas and much more.
[Watch the Show]
Backup That Computer Too, Not Just the Database...
As you set up systems to protect your databases, don't forget to backup local PCs too - making sure it's readily recoverable and protected. If you're looking for a great package to use, check out Acronis True Image - it's a great tool for making sure your system is covered. We've tested and used this software and it works flawlessly in our testing - it's a great way to fully automate the backups you rely on for your system. Check it out here.
Featured Article(s)
Find count of successful jobs with in range SP
The following procedure called usp_GetCountJobSuccessInRange gets a job name , number of days and run status that corresponds to the Run status values 0,1,2,3,4,5 (SEE table) The procedure checks the count of jobs that fall in the run status category (failed-0, success-1 etc) and that where executed within the days range (until the current day from current days - number days given)
Social Networks and Hiring for Technology Jobs
[Send in your thoughts here] The comments continue to arrive in droves - here are several more as food for thought.
Kraig: "If I was looking to hire an individual in this situation, I’d confront them about it in the second or third interview. They may not have an online presence because they are disengaged. If this is the case, then I’d pass them up for a different candidate.
They may also feel passionately that their identity and their personal data belong only to them and is not to be shared. The good DBAs I’ve worked with over the years have a passion for data. Some are very secretive, some are very open, but being secretive does not necessarily preclude being a good DBA. If anything, I’d have more respect for a DBA who was able to contribute and keep his identity anonymous. Personal data management and identity management is difficult, but one that a skilled DBA should be able to manage.
We live in an information based economy. Information is money. Too many people give up too much information too easily with too little compensation."
Ralph: "I have recently attempted to find someone on the internet who, supposedly, was a well respected person with regard to database work. I had the same experience of drawing a blank . . . zero hits that actually related to that person. I did get several hits related to someone with a virtually identical name, though. So, I thought, "Hey, who knows . . . I could have written down the name wrong." So I checked out the person that I did get hits on . . . only to establish that it was not the person I had searched for.
I have to admit that I am now extremely leery about dealing with the person for whom I searched. If there are no blogs, blog comments, or posts of any kind and I can't find any record of that person being active in any way on the internet, I have the feeling that there is just something a little odd about their claim to be "a well respected person with regard to database work." After all, even if it was a comment by somebody else, shouldn't they show up in a comment, blog, or profile somewhere? Or did they, maybe, find that other hit and decide that, since the name is really close to theirs, they could piggy-back on that person's reputation?"
Jeff: "While it is odd not to find ANYTHING about a person, I think there’s a fine line here on how to use any information gained in this way as part of a formal vetting process.
Perhaps the person uses a pseudonym to post. In a sense, I do this on some sites because my account name is associated with my business.
Even if the name matches, how can you be sure that it’s the same person you’re interviewing and not just someone with the same name? Or, worse yet, how do you know the person actually made the post and is not the victim of a malicious hoax?
Assuming you’ve found the correct person’s posts, how many do you review for content? If the person’s answer is incorrect in some way how does impact your opinion of them? If it was incorrect, but they learned from the responses of other posters, does this still count against them?
Assuming this becomes a formalized part of the employment process, I think there will have to be opportunities for the prospective employee to discuss (and defend) any information found in this way."
Featured White Paper(s)
Database Security Best Practice Strategies for Government Agencies
Like it or not, todays cyber attacks are no longer about bored teens defacing Web sites. The bad guys including those on the... (read more)
EMC CLARiiON Data Replication Options for Microsoft SQL Server Deployments Technology Concepts and Business Considerations
Read this white paper, EMC CLARiiON Data Replication Options for Microsoft SQL Server Deployments, and discover how EMC Recov... (read more)
See you online!
Stephen Wynkoop,
Founder
Microsoft SQL Server MVP
swynk@sswug.org
|
|
|
Win a 16GB iPod Touch! VendorRate is a reliable IT decision making tool that every technology department can use before making a purchasing decision. Rating a vendor is free, takes 3 minutes or less, is fully confidential, and shares your opinions with the world. New member drawing for 16GB iPod Touch ends 10/31. Enter today!
|
|
|
Attend the SSWUG Ultimate Virtual Conference! Presenting the largest online learning event covering Business Intelligence, SQL Server, Sharepoint and .NET Development November 5, 6 and 7. Twelve simultaneous tracks featuring over 40 well-known industry experts! Broadcast quality sessions, live interaction with presenters and attendees, downloadable session materials and much more.
Click here to Register!
|
|
Today's Articles
Note: 'Guest' articles below will be available for seven days to registered guests.
SQL Server Topics
Developer Topics
Oracle Topics
XML Topics
DB2 Topics
SSWUG.ORG Sponsors, Special Offers
| |
Thank you to our sponsors!
Special Member Offers
See the special member offers page for more information
Pay them a visit and let them know you heard about them on SSWUG.ORG!
|
SSWUG.ORG Free Software
| |
Software Free to use courtesy of SSWUG.ORG
- SQLsafe Freeware Edition - High performance SQL Server Backup & Recovery – 50% Faster than Native Backup Idera SQLsafe Freeware Edition is a free SQL Server database backup and...
- Free SQL Server Performance Dashboard - Idera Free SQL Check SQLcheck is an easy-to-use performance dashboard for SQL Server. Running as a handy and secure screensaver or on-demand, SQLchec...
- Free SQL Server Permissions Transfer - Idera SQLpermissions Save time and reduce errors when setting up SQL Server logins & permissions. SQLpermissions will generate customizable T-SQL sc...
Free Software Offers
See the free software page for more information
|
Summaries
| Find count of successful jobs with in range SP
| |  The following procedure called usp_GetCountJobSuccessInRange gets a job name , number of days and run status that correspond... [more]
[Click Here to Read More...] [TOP] |
Check your SQL Server using Windows PowerShell Part 6
| | (Muthusamy Anantha Kumar) Part I of this series illustrated the first and foremost check on SQL Serverhow to ping the host. P... [more]
[Click Here to Read More...] [TOP] |
SQL Server 2008 MERGE Statement
| | (Ashish Kumar Mehta) SQL Server 2008 introduces the MERGE statement which will allow users to perform insert, update and dele... [more]
[Click Here to Read More...] [TOP] |
Using Covering Indexes to Improve Query Performance
| | (Joe Webb) There are many ways to measure a databases performance. We can look at its overall availability; that is: are our ... [more]
[Click Here to Read More...] [TOP] |
Make Visual Studio Generate Your Repository
| | (Rob Conery) As many of you may know, I've been goofing around with Code Generation again with SubSonic's new MVC Addin. One ... [more]
[Click Here to Read More...] [TOP] |
ASP.NET - Client Side State Management - Control State
| | (Gil Fink) In this post I'm going to explain what is the control state and how to use it as a part of the ASP.NET client side... [more]
[Click Here to Read More...] [TOP] |
Moving to other pages in ASP.NET
| | (Tony Patton) Directing a user to another page or resource is a common aspect of a Web application. The user may initiate the... [more]
[Click Here to Read More...] [TOP] |
Using Filter Expressions with an SQL Data Source in ASP.NET C#
| | (Scott Lysle) This article describes the use of filter expressions in junction with an SQL Data Source. Filter expressions ma... [more]
[Click Here to Read More...] [TOP] |
Oracle Fusion Applications: Looking to the future
| | (Chris Maxcer) For all of the ink, video and digital posturing devoted to Oracle's ambitious Fusion Applications project, the... [more]
[Click Here to Read More...] [TOP] |
v$session.audsid
| | (Jeff Hunter) I am working on a project that requires me to get the name of the program during the logon process to the datab... [more]
[Click Here to Read More...] [TOP] |
Publishing resources exposed by ADF Data Control in RESTful services using RestLet and JDeveloper 11g
| | (Lucas Jellema) The previous two articles on RESTful services using RestLet and developing in JDeveloper 11g - First Steps wi... [more]
[Click Here to Read More...] [TOP] |
The elements of Web service performance
| | (Bill Brogden) Ever since the beginning of web services as a class of application, performance, in terms of response time and... [more]
[Click Here to Read More...] [TOP] |
Understanding the Web Services Architecture
| | (Joe Casad) The technologies of the Web have led to a new revolution in software development. The web service architecture le... [more]
[Click Here to Read More...] [TOP] |
Summarizing AJAX Patterns Under ASP.NET
| | (Xianzhong Zhu) Ever since early 2005, Ajax techniques have been continuously developing without uniform patterns. Thus, read... [more]
[Click Here to Read More...] [TOP] |
IBM Close to Delivering DB2/400 Storage Engine for MySQL
| | (Alex Woodie) IBM is nearing completion of new software that will enable DB2/400 to power the open source MySQL database, acc... [more]
[Click Here to Read More...] [TOP] |
Did you know there's a new DB2 Certification test available?
| | (Willie Favero) That's right! We now have a certification test for DB2 System Administrators. It's Test 737: DB2 9 System Adm... [more]
[Click Here to Read More...] [TOP] |
IBM Redpaper: Considerations on Small and Large Packages
| | (Troy Coleman) Have you ever considered the performance impact (high CPU) of having a few short-running SQL statements out of... [more]
[Click Here to Read More...] [TOP] |
|
Guest Articles [Top]
The article listings denoted as GUEST are random archive articles. Those articles are always available to dues-paying members, but are also available to guest newsletter subscribers for a period of 7 days from the release of this newsletter. Each newsletter features a new set of archive articles for each of the topics.
It's our hope that when you see the quality and range of articles in the archives, you'll see what a great value your SSWUG dues-paying membership really is.
Click Here to Activate Membership Today - it only takes a minute.
[ SQL Server ]
[ Oracle ]
[ DB2 ]
[ Open Source ]
[ XML ]
[ Developer ]
[ Join/Upgrade ]
[ Webcasts ]
[ Podcasts ]
[ Newsletter Archive ]
[ RSS/Feeds ]
[ About ]
[ Advertise ]
[ Contact ]
[ Privacy ]
[ Terms of Service ]
[ Link to SSWUG ]
[ List Server Archives ]
[ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.
Some names and products covered by SSWUG are the registered trademarks of their respective owners.
The SQL Server Worldwide User's Group
6420 E. Broadway Blvd. Suite A300
Tucson, AZ 85710 USA
|
