Parte 1
http://www.youtube.com/watch?feature=player_detailpage&v=W0onwYWQJH0
more:
http://www.youtube.com/watch?v=ZWaX1g_2SSQ
Monday, May 20, 2013
Space Used By Tables :: SQL-Server
CREATE TABLE #SpaceUsed (name sysname,rows bigint,reserved sysname,data sysname,index_size sysname,unused sysname)
DECLARE @Counter int
DECLARE @Max int
DECLARE @Table sysname
SELECT name, IDENTITY(int,1,1) ROWID
INTO #TableCollection
FROM sysobjects
WHERE xtype = 'U'
ORDER BY lower(name)
SET @Counter = 1
SET @Max = (SELECT Max(ROWID) FROM #TableCollection)
WHILE (@Counter <= @Max)
BEGIN
SET @Table = (SELECT name FROM #TableCollection WHERE ROWID = @Counter)
INSERT INTO #SpaceUsed
EXECUTE sp_spaceused @Table
SET @Counter = @Counter + 1
END
SELECT * FROM #SpaceUsed
DROP TABLE #TableCollection
DROP TABLE #SpaceUsed
fonte: amigo Tona
DECLARE @Counter int
DECLARE @Max int
DECLARE @Table sysname
SELECT name, IDENTITY(int,1,1) ROWID
INTO #TableCollection
FROM sysobjects
WHERE xtype = 'U'
ORDER BY lower(name)
SET @Counter = 1
SET @Max = (SELECT Max(ROWID) FROM #TableCollection)
WHILE (@Counter <= @Max)
BEGIN
SET @Table = (SELECT name FROM #TableCollection WHERE ROWID = @Counter)
INSERT INTO #SpaceUsed
EXECUTE sp_spaceused @Table
SET @Counter = @Counter + 1
END
SELECT * FROM #SpaceUsed
DROP TABLE #TableCollection
DROP TABLE #SpaceUsed
fonte: amigo Tona
Friday, May 17, 2013
Capturar URL
Para capturar o endereço completo (URL):
Dim url AS String = Request.Url.AbsoluteUri
A váriavel "url" irá retornar:
http://www.mysite.YYY.XXX/minhapagina.aspx
http://www.mysite.YYY.XXX/minhapagina.aspx
Monday, May 13, 2013
Friday, May 10, 2013
Sandcastle
Sandcastle Help File Builder
The Sandcastle Help File Builder was created to fill in the gaps, provide the missing NDoc-like features that are used most often, and provide standalone GUI and command line based tools to build a help file in an automated fashion. A Visual Studio integration package is also available for it so that help projects can be created and managed entirely from within Visual Studio.Codeplex Download
Thursday, May 9, 2013
Negócios Bilionários
O Facebook está de olho no Waze e pode comprar a plataforma por algo entre US$ 800 milhões e US$ 1 bilhão.
As conversas entre as duas partes teriam começado seis meses atrás e já estariam em estágio avançado - tanto que um termo de compromisso foi assinado, garante a publicação.
O Waze é um aplicativo de navegação que usa informações dos usuários para ajudá-los a encontrar os melhores caminhos, em abril, ele contava com 44 milhões de adeptos.
Já existe uma parceria entre o produto e a rede social, pelo meio da qual é possível compartilhar rotas com os amigos.
As conversas entre as duas partes teriam começado seis meses atrás e já estariam em estágio avançado - tanto que um termo de compromisso foi assinado, garante a publicação.
O Waze é um aplicativo de navegação que usa informações dos usuários para ajudá-los a encontrar os melhores caminhos, em abril, ele contava com 44 milhões de adeptos.
Já existe uma parceria entre o produto e a rede social, pelo meio da qual é possível compartilhar rotas com os amigos.
Wednesday, May 8, 2013
Tuesday, May 7, 2013
Saturday, May 4, 2013
Google I/O 2013
Google I/O 2013 - De 15 à 17 de Maio
Sessions
https://developers.google.com/events/io/sessions
Sessions
- Android
- Chrome e Apps
- Google+
- Google Cloud Platform
- Google Maps
- YouTube
https://developers.google.com/events/io/sessions
Wednesday, May 1, 2013
Tuesday, April 30, 2013
Thursday, April 25, 2013
Monday, April 22, 2013
Thursday, April 18, 2013
Cool Links List
Channel9
@ http://agni-tech.blogspot.com/channel9.msdn.com/
Windows Phone
@ http://agni-tech.blogspot.com/windowsphone.com/pt-br
SQL-Server
@ http://agni-tech.blogspot.com/microsoft.com/en-us/sqlserver/
Office 365
@ http://agni-tech.blogspot.com/channel9.msdn.com/
Windows Phone
@ http://agni-tech.blogspot.com/windowsphone.com/pt-br
SQL-Server
@ http://agni-tech.blogspot.com/microsoft.com/en-us/sqlserver/
Office 365
Tuesday, April 16, 2013
Git - Livro
The entire Pro Git book, written by Scott Chacon and published by Apress.
Cisco Learning Network
The Cisco Learning Network
A demanda de profissionais capacitados para gerenciar as ferramentas que mantêm o fluxo de informações e comunicações continua a crescer. As Certificações Cisco podem ajudá-lo a encontrar uma carreira de sucesso em um setor em alta atualmente. Teste gratuitamente seus conhecimentos e avalie o seu potencial para se tornar um profissional em redes através das Certificações Cisco.
Monday, April 15, 2013
Kudo
Kodu is a visual programming language made specifically for creating games.
It is designed to be accessible for children and enjoyable for anyone.
http://www.kodugamelab.com/
Thursday, March 21, 2013
Tuesday, March 19, 2013
Wednesday, March 13, 2013
Tuesday, March 12, 2013
Channel9 Cool Stuff!
more @ http://channel9.msdn.com/
1 - 17
2 - 17
3 - 17
4 - 17
5 - 17
6 - 17
7 - 17
8 - 17
9 - 17
10 - 17
11 - 17
12 - 17
13 - 17
14 - 17
15 - 17
16 - 17
17 - 17
1 - 17
2 - 17
3 - 17
4 - 17
5 - 17
6 - 17
7 - 17
8 - 17
9 - 17
10 - 17
11 - 17
12 - 17
13 - 17
14 - 17
15 - 17
16 - 17
17 - 17
C# CalcAge Algorithm
public static Int32 CalcAge(DateTime? data)
{
if (data != null)
{
var bDay = Convert.ToDateTime(data);
var actualDate = DateTime.Now;
var age = actualDate.Year - bDay.Year;
if (bDay.Month < actualDate.Month || (actualDate.Month == bDay.Month & bDay.Day < actualDate.Day))
return age--;
else
return age;
}
return 0;
}
Monday, March 11, 2013
Thursday, March 7, 2013
Time Tracker
Main Home page
http://www.myintervals.com/
Video tour of Intervals online project management functionality
http://www.myintervals.com/video/
Intervals is web-based project management software that marries time tracking and task management in a collaborative online space with powerful reporting.
http://www.myintervals.com/
Video tour of Intervals online project management functionality
http://www.myintervals.com/video/
Intervals is web-based project management software that marries time tracking and task management in a collaborative online space with powerful reporting.
Wednesday, March 6, 2013
VB.NET // C#
This is a quick reference guide to highlight some key syntactical differences between VB.NET and C#
http://www.harding.edu/fmccown/vbnet_csharp_comparison.html
Tuesday, March 5, 2013
Monday, March 4, 2013
Saturday, March 2, 2013
Friday, March 1, 2013
SeleniumHQ
http://www.seleniumhq.org/
Selenium automates browsers. That's it. What you do with that power is entirely up to you. Primarily it is for automating web applications for testing purposes, but is certainly not limited to just that. Boring web-based administration tasks can (and should!) also be automated as well.
Selenium has the support of some of the largest browser vendors who have taken (or are taking) steps to make Selenium a native part of their browser. It is also the core technology in countless other browser automation tools, APIs and frameworks.
Selenium automates browsers. That's it. What you do with that power is entirely up to you. Primarily it is for automating web applications for testing purposes, but is certainly not limited to just that. Boring web-based administration tasks can (and should!) also be automated as well.
Selenium has the support of some of the largest browser vendors who have taken (or are taking) steps to make Selenium a native part of their browser. It is also the core technology in countless other browser automation tools, APIs and frameworks.
Thursday, February 28, 2013
SELECT WITH NOLOCK
vale a pena conferir dicas sobre este recurso poderoso do SQL - Server
http://blogs.msdn.com/b/fcatae/archive/2010/10/05/como-usar-select-with-nolock-para-melhorar-a-performance.aspx
http://blogs.msdn.com/b/fcatae/archive/2010/10/05/como-usar-select-with-nolock-para-melhorar-a-performance.aspx
Wednesday, February 27, 2013
create db objects via bat file
echo off
cls
echo.
echo =========================
echo CREATE NEW VIEWS ON DATABASE
echo =========================
echo.
echo.
echo.
echo Executing create...
sqlcmd -S . -E -i %~p0\v_x.sql -o %~p0\Log\CreateViewsLog.txt
echo.
%~p0\Log\Log.txt
echo Create View Executed!
echo Log saved on %~p0\Log\
echo.
pause
GChat
GChat
http://www.windowsphone.com/en-us/store/app/gchat/f9da43e4-9bbb-4a6d-842d-629bd6bdc84b
http://www.windowsphone.com/en-us/store/app/gchat/f9da43e4-9bbb-4a6d-842d-629bd6bdc84b
Gchat supports cool features such as: - Modern design that integrates with the rest of Windows Phone - Receive IMs even if the app isn't running with push notifications - Pin your friends to start and receive tile notifications for each one - Completely encrypted conversations and support for Google Talk's "off the record" conversations - New in 1.6: New icon, invisible status, bug fixes, and 24hrs logout timer for Gchat+ users More info at http://gchatapp.com
Tuesday, February 26, 2013
Friday, February 15, 2013
PMI :: Termo de Abertura
PROJETO <<NOME PROJETO>>
|
||
TERMO
DE ABERTURA DO PROJETO
|
||
Preparado
por
|
<<Nome
Autor>>
|
Versão X.X
|
Aprovado
por
|
<<Nome
Aprovador>>
|
DD/MM/AAAA
|
I - Resumo
das condições do projeto
II - Justificativa
do projeto
III - Nome
do gerente do projeto, suas responsabilidades e sua autoridade
IV - Necessidades
básicas do trabalho a ser realizado
V - Principais
partes interessadas
VI - Descrição
do projeto
1.
Produto do projeto
2.
Cronograma básico do projeto
3.
Estimativas iniciais de custo
VII - Restrições
VIII - Premissas
IX - Administração
1. Necessidade
inicial de recursos
2. Necessidade
de suporte pela organização
3. Controle
e gerenciamento das informações do projeto
APROVAÇÕES
|
||
<<Nome
Aprovador>>
|
Data:
|
|
Nota:
Quaisquer alterações neste documento deverão ser submetidas ao processo de
controle de projeto no site http://sitequalquer.com
para aprovações antes de serem
incorporadas a este documento.
PMI :: Processos
Introdução
- Paradigmas sobre gestão de projetos
- Origens dos Projetos
- Produto, Projeto e Gerenciamento
- Ciclo de vida de projetos
- Stakeholders (Interessados)
- PMO – Project Management Office
- Estruturas Organizacionais
- PMBOK®
- Restrições e Premissas
- Triple Constraint (Tripla Restrição)
- Áreas de Expertise
- Grupo de Processos
- Interação entre os Processos
- Áreas de Conhecimento conforme PMBOK®
- Processos
- Matriz de Grupos de Processos e Áreas de Conhecimento
Processo de Iniciação
- Desenvolver o Termo de Abertura do Projeto
- Desenvolver a Declaração do Escopo Preliminar do Projeto
Processo de Planejamento
- Planejamento do Escopo
- Definição do Escopo
- Criar o EAP (WBS)
- Planejamento das Comunicações
- Definição das Atividades
- Estimativa de Recursos da Atividade
- Planejamento de Recursos Humanos
- Seqüenciamento de Atividades
- Estimativa de Duração da Atividade
- Estimativas de Custos
- Planejamento da qualidade
- Planejamento do Gerenciamento de Riscos
- Identificação de Riscos
- Análise Qualitativa de Riscos
- Análise Quantitativa de Riscos
- Planejamento de Respostas a Riscos
- Planejar Compras e Aquisições
- Planejar Contratações
- Desenvolvimento do Cronograma
- Orçamentação
- Desenvolver o Plano de Gerenciamento do Projeto
Processo de Execução
- Orientar e Gerenciar a Execução do Projeto
- Contratar ou Mobilizar a equipe do Projeto
- Desenvolver a Equipe do Projeto
- Distribuição das Informações
- Solicitar Respostas de fornecedores
- Selecionar Fornecedores
- Realizar a Garantia da Qualidade
Processo de Controle
- Gerenciar a Equipe do Projeto
- Administração de Contratos
- Verificação de Escopo
- Relatório de Desempenho
- Gerenciar as Partes Interessadas (Stakeholders)
- Monitorar e Controlar o Trabalho do Projeto
- Controle Integrado de Mudanças
- Controle do Escopo
- Controle do Cronograma
- Controle de Custos
- Realizar o Controle da Qualidade
- Monitoramento e Controle de Riscos
Processo de Encerramento
- Encerramento do Contrato
- Encerrar o Projeto
Saturday, February 9, 2013
Friday, February 8, 2013
Tuesday, January 29, 2013
SharePoint 2013 x Project Server
SharePoint 2013 x Project Server
Project Server 2013 and Project Online, built on SharePoint Server 2013 and SharePoint Online, deliver project portfolio management solutions that are designed around the core principles of scalability and flexibility. Scalability improvements, such as database optimization and Project Web App page load, were made to enable multi-tenancy and lower infrastructure costs. Flexibility improvements increase agility and control, and include multi-browser support, an integrated administrative experience, and deeper integration with Exchange, Lync, SharePoint, and Project Pro for Office 365.
Project Server 2013 and Project Online, built on SharePoint Server 2013 and SharePoint Online, deliver project portfolio management solutions that are designed around the core principles of scalability and flexibility. Scalability improvements, such as database optimization and Project Web App page load, were made to enable multi-tenancy and lower infrastructure costs. Flexibility improvements increase agility and control, and include multi-browser support, an integrated administrative experience, and deeper integration with Exchange, Lync, SharePoint, and Project Pro for Office 365.
CMS, SharePoint e Project Server 2013
Entre no CMS Wire e e descubra novidades na Gestão de Projetos com SharePoint e Project Server 2013
The recent beta of SharePoint 2013 brought with it a new version of its sister product: Project Server 2013. Project Server is built on top of SharePoint, and is designed to extend the capabilities of Microsoft Project for large scale enterprise project management.
Project Server 2013 brings with it several new features. Most obvious of all is adoption of the new Windows 8 UI, as seen in SharePoint 2013. One of the biggest functional changes is the integration with Office 365, now that Project Online is part of Microsoft’s cloud offering.
The new Azure Workflow Server, a big part of SharePoint 2013, also makes an appearance here. This does mean any existing workflows will be incompatible and need rebuilding. However it also means users now have the option of creating workflows directly in SharePoint Designer 2013 and deploying them to Project Server ...
more: CMS Wire
Monday, January 28, 2013
Tuesday, January 15, 2013
Saturday, December 8, 2012
Wednesday, November 7, 2012
Javascript :: window.open
string xNumeroRSTE = "111";
Response.Write("<script type='text/javascript'>window.open('DocumentRender//DemandForReceipt.aspx?TransactionId=" + xNumeroRSTE + "','_blank');</script>");
Response.Write("<script type='text/javascript'>window.open('DocumentRender//DemandForReceipt.aspx?TransactionId=" + xNumeroRSTE + "','_blank');</script>");
Thursday, October 18, 2012
RESEED SQL-SERVER
EXEMPLO:
TRUNCATE TABLE XXX -- (OPCIONAL E SOMENTE QUANDO DESEJADO)
DBCC CHECKIDENT (XXX, RESEED, 1)
TRUNCATE TABLE XXX -- (OPCIONAL E SOMENTE QUANDO DESEJADO)
DBCC CHECKIDENT (XXX, RESEED, 1)
Monday, October 8, 2012
GetValue via JavaScript
Get values from asp.net controls like TextBox, RadioButtonList, DropDownList, CheckBoxes...
http://www.dotnetfunda.com/articles/article72.aspx
Get TextBox Sample
<table>
<tr>
<th colspan="2" align="left">TextBox Value in JS:</th>
</tr>
<tr>
<td>
<asp:TextBox ID="txt1" runat="server"></asp:TextBox>
</td>
<td>
<input type="button" value="Submit" onclick="GetTextBoxValue('<%= txt1.ClientID %>')" />
</td>
</tr>
</table>
http://www.dotnetfunda.com/articles/article72.aspx
Get TextBox Sample
<table>
<tr>
<th colspan="2" align="left">TextBox Value in JS:</th>
</tr>
<tr>
<td>
<asp:TextBox ID="txt1" runat="server"></asp:TextBox>
</td>
<td>
<input type="button" value="Submit" onclick="GetTextBoxValue('<%= txt1.ClientID %>')" />
</td>
</tr>
</table>
Tags
Tags, the meaning of ...
<% %> An embedded code block is server code that executes during the page's render phase. The code in the block can execute programming statements and call functions in the current page class. http://msdn2.microsoft.com/en-gb/library/ms178135(vs.80).aspx
<%= %> most useful for displaying single pieces of information. http://msdn2.microsoft.com/en-us/library/6dwsdcf5(VS.71).aspx
<%: %> Like <%= %> But HtmlEncodes the output (new with Asp.Net 4 http://weblogs.asp.net/scottgu/archive/2010/04/06/new-lt-gt-syntax-for-html-encoding-output-in-asp-net-4-and-asp-net-mvc-2.aspx
Wednesday, September 19, 2012
populating menu items
Dynamically populating menu items from the database in ASP.NET
http://www.codeproject.com/Tips/354696/Dynamically-populating-menu-items-from-the-databas
http://www.codeproject.com/Tips/354696/Dynamically-populating-menu-items-from-the-databas
Tuesday, September 18, 2012
Thursday, September 13, 2012
Wednesday, September 5, 2012
SEO - Search Engine Optimization
fonte: http://www.w3schools.com/web/web_search.asp
Search engine optimization (SEO) is the process of improving the ranking (visibility) of a website in search engines. The higher (or more frequently) a web site is displayed in a search engine list (like Google), the more visitors it is expected to receive.
SEO considers how search engines work, what people search for, and which search terms (words) are typed. Optimizing a website may involve editing the content to increase its relevance to specific keywords. Promoting a site to increase the number of links, is another SEO tactic.
Effective search engine optimization may require changes to the HTML source code of a site and to the site content. SEO tactics should be incorporated into the website development and especially into the menus and navigation structure.
Another class of techniques, known as black hat SEO or spamdexing, uses methods such as link farms, keyword stuffing and article spinning that degrade both the relevance of search results and the quality of user-experience with search engines. Search engines look for sites that employ these techniques in order to remove them from their indices.
Effective search engine optimization may require changes to the HTML source code of a site and to the site content. SEO tactics should be incorporated into the website development and especially into the menus and navigation structure.
Another class of techniques, known as black hat SEO or spamdexing, uses methods such as link farms, keyword stuffing and article spinning that degrade both the relevance of search results and the quality of user-experience with search engines. Search engines look for sites that employ these techniques in order to remove them from their indices.
Submit Your Site to Search Engines
Web search engines (like Google) automatically add new web sites to their search index every time they crawl the web.
If your web site is new and unknown, it may take some time before your site is "discovered".
Luckily most search engines invites you to submit your site: *
Open Directory: http://www.dmoz.org/help/submit.html
Normally you will have to enter the full URL of your site including the http:// prefix.
Example: http://www.mysite.com/
When you submit your site to a search engine, you only need to specify the top-level (home) page. You do not need to submit each page. The search engine will find the rest based on your links (keep your navigation menus tidy).
Sometimes you can also add keywords that describe the page, but don't expect these to affect how your site is ranked or listed.
Search engines indexes are updated on a regular basis. Changes to your site will be updated over time (monthly) and dead pages and links will disappear.
* Not all submitted URLs will be added, and you cannot predict or guarantee when or if your site will appear in a search result.
Friday, August 31, 2012
Thursday, August 30, 2012
Wednesday, August 29, 2012
Tuesday, August 28, 2012
MetraNet
| Setup MetraNet | |||
| 1 | Create a New Pipeline Extension | ||
| 2 | Create an Enumerated Type | ||
| 3 | Create a Service Definition | ||
| 4 | Create a Parameter Table | ||
| 5 | Create a Product View | ||
| 6 | Create a Priceable Item Type | ||
Monday, August 27, 2012
MetraTech (Priceable Item Creation Workflow)
Priceable Item Creation Workflow
The components that you configure and the usual order in which you configure them are presented here.
Stages 1 and 2 represent the work a systems integrator or configuration developer does in ICE to create a pipeline.
Stage 3 represents the work that is typically performed by a product or rating manager to create a product offering based upon the priceable item.
Stage 1: Create a priceable item
1. Define a Pipeline Extension
When you want to provide a new service to customers, you will be defining a new product offering - and this offering will comprise one or more priceable items. You generally configure your new service in new, self-contained pipeline extension or include it with other similar services in an already existing extension.
2. Define Required Enums
If you want an enumerated value as part of your parameter table, service definition, or product view you will need to configure it prior to creating the priceable item.
3. Create a Service Definition
You want to know the exact properties of configured service data table in the mediation database. This determines the usage data that MetraConnect will send to MetraNet.
For example, if MetraConnect is sending transactions containing the login name, transaction start time, and transaction end time, the service definition would contain these values.
4. Define Parameter Tables
Parameter tables store the rate schedules of a priceable times, expressed as rules with conditions and actions. You will need to gather all the variables that MetraOffer rate schedules will consider when rating usage.
5. Define Product Views
Properties that you want MetraNet to 1) display to the customer in MetraView and 2) have available in the product view table for any other purpose, such as an adapter that you have created to process your data.
6. Create a Priceable Item Type
A priceable item type ties together a service definition, a product view, and one or more parameter tables to create an entity that can be implemented as a chargeable item by a product manager using MetraOffer.
A priceable item type ties together a service definition, a product view, and one or more parameter tables to create an entity that can be implemented as a chargeable item by a product manager using MetraOffer.
7. Validate and Synchronize
So far the changes you have made have been made to metadata - not to your MetraNet database schema. In this step, first you validate your XML (ICE makes this easy), and then you are ready to commit the changes so that MetraNet creates the tables that your database will use.
Stage 2: Create a stage and plug-ins
1. Define a Stage
In order to process transactions for a priceable item, one or more processing stages must be associated with that priceable item. This is actually what creates the priceable item’s pipeline. The stage is the container in which you define plug-ins in the next step.
2. Define Plug-ins
In this step you add the required business logic to your pipeline by creating plug-in instances. You can make use of MetraNet's library of standard plug-ins, which will require only some minor configuration. You can write your own plug-in logic with MetraNet's MTSQL language - or, when necessary (for such reasons as high performance or transaction support), you can create custom plug-ins with C#.
3. Set the Pipeline
You are now ready to connect up the pipeline by specifying the extension, the service definition, and the stage you have just created in the previous steps.
Stage 3: Create a product offering
1. Create a Product Offering in MetraOffer
Now you have a priceable item, this step and the next are performed in MetraOffer. First you define the containing package for the priceable item, called the product offering.
2. Add a Rate Schedule in MetraOffer
A rate schedule can now be applied to the product offering. You set the values for the rate schedule according to the rules (conditions and actions) that were specified in the parameter table.
3. Add a Test Subscriber in MetraCare
4. Before you can test a product offering you need to create an account to subscribe to it.
5. Test with Sample Charges
You can generate charges using Meter Sessions or Meter Tool.
6. View the Charges in MetraView
You can view the charges the subscriber would see.
Subscribe to:
Posts (Atom)



