[bksvol-discuss] Re: Really technical
- From: "Andy B." <sonfire11@xxxxxxxxx>
- To: <bksvol-discuss@xxxxxxxxxxxxx>
- Date: Sat, 7 Aug 2010 20:11:28 -0400
Coffee rules!
-----Original Message-----
From: bksvol-discuss-bounce@xxxxxxxxxxxxx
[mailto:bksvol-discuss-bounce@xxxxxxxxxxxxx] On Behalf Of Chela Robles
Sent: Saturday, August 07, 2010 2:01 PM
To: bksvol-discuss@xxxxxxxxxxxxx
Subject: [bksvol-discuss] Re: Really technical
Scott I'll try not to be too technical I guess that is what you get
when you took nothing related to SQL and only barely got by with Java
and BlueJ in the first year of college in 2006, and you definitely made
my day, lol, had to add it to my facebook profile, as a Bookshare
Volunteer Quote Of The Day sort of thing, definitely will play trumpet
more grin! Chuckle Chela is going to have some coffee first though.
--
"To me, music that breaks your heart is the music that stays with you
forever. It's one thing to be melancholy and one thing to be sophisticated,
but when you get the two of them together in a way people can relate to,
then I think you're on to something. You want the sophistication to lie in
the purity of the sound, the beauty of the arrangements, and the quality of
the performances."-Trumpeter Chris Botti
--
Chela Robles
AIM and E-Mail: cdrobles693@xxxxxxxxx
Skype: jazzytrumpet
WindowsLive Messenger: cdrobles693@xxxxxxxxxxx
I Volunteer for a non-profit organization called Bookshare, to find out more
go to: http://www.bookshare.org
--
On 8/7/2010 10:42 AM, Scott Rains wrote:
> LOL! Chela, I promise you and all volunteers, nobody is going to need
> to become a CIO, and SQL-whiz, a DB Admin, or a jazz trumpet virtouso
> to continue to volunteer.
>
> Kim, in a car a dashboard is a bit of attractively molded plastic that
> hides the tangle of wires and the spots of grease behind it. Online
> it's a an attractively designed page that hides lots of thought, and
> an alphabet soup of jargon, about how to make the user's job as simple
> as possible.
>
> Andy nailed it earlier, "Sign into bookshare, go to the My Account
> link and you have a simple basic dashboard."
>
>
> Scott Rains
> Benetech Fellow, Bookshare Volunteer Department
> ________________________________________
> From: bksvol-discuss-bounce@xxxxxxxxxxxxx
> [bksvol-discuss-bounce@xxxxxxxxxxxxx] On Behalf Of Chela Robles
[cdrobles693@xxxxxxxxx]
> Sent: Saturday, August 07, 2010 10:26 AM
> To: bksvol-discuss@xxxxxxxxxxxxx
> Subject: [bksvol-discuss] Re: Really technical
>
> SQL is
> Abbreviation of structured query language, and pronounced either
> see-kwell or as separate letters. SQL is a standardized query
> language<query_language.html> for requesting information from a
> database<database.html>. The original version called SEQUEL
> (structured English query language) was designed by an IBM<IBM.html>
> research center in 1974 and 1975. SQL was first introduced as a
> commercial database system<database_management_system_DBMS.html> in
> 1979 by Oracle Corporation.
>
> Historically, SQL has been the favorite query language for database
> management systems running on minicomputers<minicomputer.html> and
> mainframes<mainframe.html>. Increasingly, however, SQL is being
> supported<support.html> by PC<PC.html> database systems because it
> supports distributed databases<distributed_database.html> (databases
> that are spread out over several computer
> systems<computer_system.html>). This enables several users<user.html>
> on a local-area network<local_area_network_LAN.html> to
> access<access.html> the same database simultaneously.
>
> Although there are different dialects of SQL, it is nevertheless the
> closest thing to a standard<standard.html> query language that
> currently exists. In 1986, ANSI<ANSI.html> approved a rudimentary
> version of SQL as the official standard, but most versions of SQL
> since then have included many extensions<extension.html> to the ANSI
> standard. In 1991, ANSI updated the standard. The new standard is
> known as SAG SQL.
>
> DBA is
> Short for database administrator is is the title given to the person
> responsible for managing many aspects of a database<database.html>
> including archiving, performance, security, testing, and other tasks.
>
> CIO is
> Short for Chief Information Officer, CIO is a job title given to
> someone within an enterprise<enterprise.html> who heads, at the
> executive board level, information technology within an organization.
> The CIO is largely responsible for the computer systems and the
> information technology (IT<IT.html>) that support the organization,
> and works within the organization's budget to oversee the IT
> implementation, often reporting to the organization's CFO (Chief
> Financial Officer). Within the organization, the job of a CIO is to
> overall derive greater demonstrable business value from IT spent. CIO
> is a job title that is most commonly used in the military, enterprise
> and larger business organizations.
>
> And CEO is loike what President and founder Jim Fructerman is to
> Bookshare if that makes sense.-- "To me, music that breaks your heart
> is the music that stays with you forever. It's one thing to be
> melancholy and one thing to be sophisticated, but when you get the two
> of them together in a way people can relate to, then I think you're on
> to something. You want the sophistication to lie in the purity of the
> sound, the beauty of the arrangements, and the quality of the
> performances."-Trumpeter Chris Botti
> --
> Chela Robles
> AIM and E-Mail: cdrobles693@xxxxxxxxx<mailto:cdrobles693@xxxxxxxxx>
> Skype: jazzytrumpet
> WindowsLive Messenger:
> cdrobles693@xxxxxxxxxxx<mailto:cdrobles693@xxxxxxxxxxx>
> I Volunteer for a non-profit organization called Bookshare, to find
> out more go to: http://www.bookshare.org
> --
>
>
> On 8/7/2010 6:13 AM, Kim Friedman wrote:
> Chela, in your explanation, you mention SQL, DBA, CIO, CEO ... I have
> no idea what these acronyms stand for. The explanation is getting very
> complicated. Regards, Kim Friedman. P.S.: Your writing to someone who
> doesn't understand this stuff. K.
>
> ________________________________
> From:
>
bksvol-discuss-bounce@xxxxxxxxxxxxx<mailto:bksvol-discuss-bounce@xxxxxxxxxxx
rg> [mailto:bksvol-discuss-bounce@xxxxxxxxxxxxx] On Behalf Of Chela Robles
> Sent: Friday, August 06, 2010 8:05 PM
> To: bksvol-discuss@xxxxxxxxxxxxx<mailto:bksvol-discuss@xxxxxxxxxxxxx>
> Subject: [bksvol-discuss] Re: Really technical
>
> In information technology, a dashboard is a user interface that, somewhat
resembling an automobile's dashboard, organizes and presents information in
a way that is easy to read. However, a computer dashboard is more likely to
be interactive than an automobile dashboard (unless it is also
computer-based). To some extent, most graphical user interfaces
(GUI<http://searchWinDevelopment.techtarget.com/sDefinition/0,,sid8_gci21398
9,00.html><http://searchWinDevelopment.techtarget.com/sDefinition/0,,sid8_gc
i213989,00.html>s) resemble a dashboard. However, some product developers
consciously employ this metaphor (and sometimes the term) so that the user
instantly recognizes the similarity.a product might obtain information from
the local operating system in a computer, from one or more applications that
may be running, and from one or more remote sites on the Web and present it
as though it all came from the same source. Hewlett Packard developed the
first such product, which began
> as a tool for customizing Windows desktops. Called /Dashboard/, the
> HP product was subsequently acquired by Borland and then a company
> called Starfish. Microsoft's /Digital Dashboard/ tool incorporates
> Web-based elements (such as news, stock quotes, and so on) and
> corporate elements (such as e-mail, applications, and so on) into
> Outlook. Dashboards may be customized in a multitude of ways and named
> accordingly, generally, for example as a general /corporate/ or
> enterprise<http://searchWinIT.techtarget.com/sDefinition/0,,sid1_gci21
> 2065,00.html><http://searchWinIT.techtarget.com/sDefinition/0,,sid1_gc
> i212065,00.html> dashboard, or more specifically, as a
> CIO<http://searchCIO.techtarget.com/sDefinition/0,,sid182_gci213620,00
> .html><http://searchCIO.techtarget.com/sDefinition/0,,sid182_gci213620
> ,00.html> or
> CEO<http://searchCIO.techtarget.com/sDefinition/0,,sid182_gci1271045,0
> 0.html><http://searchCIO.techtarget.com/sDefinition/0,,sid182_gci12710
> 45,00.html> dashboard.
>
> A software-based control panel for one or more applications, network
> devices or industrial machines. Dashboards display simulated gauges
> and dials that look somewhat like an automobile dashboard.
>
>
> What is the SQL Server DBA Dashboard?
>
> The SQL Server DBA dashboard tool is both a DBA and a TSQL programmer
> tool. The main goal of this tool is to allow DBAs and programmers to
> quickly identify performance, SQL Agent and disk space issues
> associated with a single instance of SQL Server. The dashboard tool
> can be installed and run against any SQL Server 2005 SP2 or SQL Server
> 2008 instance.
>
> The dashboard provides 39 different performance and disk space related
> reports with a single click from the main dashboard page. These
> different reports provided information in the following areas:
>
> * Identifies the worst performing TSQL Statement and Stored
Procedures, based on different criteria like CPU, I/O and elapsed time
> * Performance counter measurements
> * Shows summarized and detailed SQL Server Agent Job failures
> * Displays CPU consumption overtime
> * Reports on Index Fragmentation
> * I/O usage by database<#>
> * Tracks backup history
> * Tables without indexes
> * Unused and missing Indexes
>
> There are two different dashboards within the SQL Server DBA<#>
> Dashboard. There is one dashboard for DBAs and another one with a
> subset of reports targeted for SQL Server programmers/developers<#>.
> The main reason for having two different dashboards has to do with
> permission. The programmer/developer dashboard only requires "VIEW
> SERVER STATE" permissions; where as the SQL Server DBA Dashboard
> requires "sysadmin" permissions.
>
>
> Architecture/Components that make up the SQL Server DBA
> Dashboard:
>
> The dashboard is made up of a single DLL, a database
> (SS_DBA_Dashboard), a SQL Server Agent job and a series of Reporting
> Services RDL files. As already stated the SQL Server DBA Dashboard
> contains two different dashboards, one for DBAs and another for
> programmers.
>
> The DLL file contains most of the code used to obtain the information
> displayed in the dashboard reports. The DLL assembly is used to create
> external stored procedures in the SS_DBA_Dashboard database. In
> additions to SPs being created in this database there are a couple of
> tables to hold a small number of statistical records. This database
> should grow very little, if any after the first use of the dashboard.
>
> The DLL and database needs to be installed on each SQL Server instance
> you want to monitor with the dashboard tool. The RDL files can be
> stored in a single location or multiple locations. The RDL files are
> designed to only to be executed from within SQL Server Management
> Studio. In fact, only two RDL files "DBA_Dashboard_Main.rdl" and
> "Programmer_Dashboard_Main.rdl" files should be referenced when
> bringing up a Custom Report from within SSMS. These two RDL files pass
> parameters to the other RDL files, so if you try to invoke the other
> RDL files directly from SSMS they will fail.
>
> Any instance where the DLL and SS_DBA_Dashboard have been installed
> can be monitored using the two dashboards. The two main RDL files
> mentioned above can be rendered on any client computer that has SSMS
> installed. The only requirement is that the client computer be running
> SQL Server SP2, the user/computer can access the RDL files, a valid
> registration can be made between the client computer and the server
> being monitored with SSMS, and the user using the dashboard has the
> permission to execute the SPs in the SS_DBA_Dashboard database.
>
>
>
> **
>
>
> --
> "To me, music that breaks your heart is the music that stays with you
> forever. It's one thing to be melancholy and one thing to be
> sophisticated, but when you get the two of them together in a way
> people can relate to, then I think you're on to something. You want
> the sophistication to lie in the purity of the sound, the beauty of
> the arrangements, and the quality of the performances."-Trumpeter
> Chris Botti
> --
> Chela Robles
> AIM and E-Mail: cdrobles693@xxxxxxxxx<mailto:cdrobles693@xxxxxxxxx>
> Skype: jazzytrumpet
> WindowsLive Messenger:
> cdrobles693@xxxxxxxxxxx<mailto:cdrobles693@xxxxxxxxxxx>
> I Volunteer for a non-profit organization called Bookshare, to find
> out more go to: http://www.bookshare.org
> --
>
>
> On 8/6/2010 1:44 PM, Kim Friedman wrote:
>> Hi,
> I read this message about dashboards (the computer ones, not the
>> ones in
> cars), and I haven't the faintest idea what one is supposed
>> to do when
> encountering a dashboard. I'm afraid I think: "huh? What
>> is that for?
> Why do they call it a dashboard?" In short, this is
>> beyond my purview
> and I'm stumped. Can someone explain this dashboard
>> thing to me in
> simple terms and show me what you'd do if you came
>> across one? I'm
> willing to learn. Regards, a confused Kim Friedman.
>>
>>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5348 (20100806) __________
>> The message was
> checked by ESET NOD32 Antivirus.
>> http://www.eset.com
>>
>>
>> To
> unsubscribe from this list send a blank Email to
>> bksvol-discuss-request@xxxxxxxxxxxxx<mailto:bksvol-discuss-request@fr
>> eelists.org>
> put the word 'unsubscribe' by
>> itself in the subject line. To get a
> list of available commands, put
>> the word 'help' by itself in the subject
> line.
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5348 (20100806) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5348 (20100806) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5348 (20100806) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
> To unsubscribe from this list send a blank Email to
> bksvol-discuss-request@xxxxxxxxxxxxx
> put the word 'unsubscribe' by itself in the subject line. To get a
> list of available commands, put the word 'help' by itself in the
> subject line.
>
To unsubscribe from this list send a blank Email to
bksvol-discuss-request@xxxxxxxxxxxxx
put the word 'unsubscribe' by itself in the subject line. To get a list of
available commands, put the word 'help' by itself in the subject line.
To unsubscribe from this list send a blank Email to
bksvol-discuss-request@xxxxxxxxxxxxx
put the word 'unsubscribe' by itself in the subject line. To get a list of
available commands, put the word 'help' by itself in the subject line.
Other related posts:
