Description: recover db from suspect state

Link: http://www.codekeep.net/snippets/d98d1fbc-5bfd-43fd-9bb2-3a482b7af278.aspx

EXEC sp_resetstatus 'dbname';
ALTER DATABASE dbname SET EMERGENCY
DBCC checkdb('dbname')
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('dbname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE dbname SET MULTI_USER

Description: convert ((int)year,(int)month,(int)day) to Datetime

Link: http://www.codekeep.net/snippets/ccc0d9a6-0d18-4f2d-adbf-266027bc254c.aspx

SELECT
   CAST(
      CAST(year AS VARCHAR(4)) +
      RIGHT('0' + CAST(month AS VARCHAR(2)), 2) +
      RIGHT('0' + CAST(day AS VARCHAR(2)), 2) 
   AS DATETIME)

Description: http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/249/creating-random-sql-server-test-data.aspx

Link: http://www.codekeep.net/snippets/7189e2d4-6e9b-4a78-9a5a-0754fbcf4689.aspx

CREATE TABLE dbo.TestTableSize
(
	MyKeyField VARCHAR(10) NOT NULL,
	MyDate1 DATETIME NOT NULL,
	MyDate2 DATETIME NOT NULL,
	MyDate3 DATETIME NOT NULL,
	MyDate4 DATETIME NOT NULL,
	MyDate5 DATETIME NOT NULL
)

DECLARE @RowCount INT
DECLARE @RowString VARCHAR(10)
DECLARE @Random INT
DECLARE @Upper INT
DECLARE @Lower INT
DECLARE @InsertDate DATETIME

SET @Lower = -730
SET @Upper = -1
SET @RowCount = 0

WHILE @RowCount < 3000000
BEGIN
	SET @RowString = CAST(@RowCount AS VARCHAR(10))
	SELECT @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0)
	SET @InsertDate = DATEADD(dd, @Random, GETDATE())
	
	INSERT INTO TestTableSize
		(MyKeyField
		,MyDate1
		,MyDate2
		,MyDate3
		,MyDate4
		,MyDate5)
	VALUES
		(REPLICATE('0', 10 - DATALENGTH(@RowString)) + @RowString
		, @InsertDate
		,DATEADD(dd, 1, @InsertDate)
		,DATEADD(dd, 2, @InsertDate)
		,DATEADD(dd, 3, @InsertDate)
		,DATEADD(dd, 4, @InsertDate))

	SET @RowCount = @RowCount + 1
END

Description: SQL Collate and combine multiple rows into single row with comma between rows.

Link: http://www.codekeep.net/snippets/a54c07cd-5eb5-4bf6-a43e-306c245c946a.aspx

DECLARE @List VARCHAR(8000)  
SELECT @List = COALESCE(@List + ', ', '') + (ServiceCode)
FROM  Services
WHERE ServiceID < 10 

PRINT @List

Description: SQL Temp Table Variable. Example shows how to insert list of database names into a temp table.

Link: http://www.codekeep.net/snippets/3f4da5ab-7b44-4a1a-adaf-8f75af3cbd3e.aspx

DECLARE @TVar TABLE (DBName VARCHAR(50) NOT NULL)

INSERT INTO @TVar (DBName) 
SELECT dbo.sysdatabases.name AS DBname
FROM dbo.sysaltfiles INNER JOIN dbo.sysdatabases ON 
            dbo.sysaltfiles.dbid = dbo.sysdatabases.dbid 
WHERE dbo.sysdatabases.name 
            NOT IN ( 
					'Northwind', 
					'pubs', 
					'tempdb', 
					'master', 
					'model', 
					'msdb',
					'ReportServerTempDB',
					'GTTemp',
					'RMinder'
					)
	AND dbo.sysaltfiles.name NOT LIKE '%log'
	AND dbo.sysaltfiles.name NOT LIKE '%Restore'

Description: SQL DateOnly, StartofWeek, EndOfWeek. Removes time from the Date object.

Link: http://www.codekeep.net/snippets/34ab2dab-db10-482e-a4d0-0252329ce13f.aspx

-- Date Only (Strips time)
SELECT DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP), 0) AS DATEONLY

-- First Date in the week
SELECT DATEADD(wk, DATEDIFF(wk, 6, CURRENT_TIMESTAMP), 6) AS START_OF_WEEK 

-- Last Date in the week
SELECT DATEADD(wk, DATEDIFF(wk, 6, CURRENT_TIMESTAMP), 6 + 6) AS END_OF_WEEK 

Description: SQL Restore

Link: http://www.codekeep.net/snippets/42a7e663-f844-45bd-ad62-11fc9e1973aa.aspx

RESTORE DATABASE [MydbName] FROM  DISK = N'D:\Restores\MydbName.bak' WITH  FILE = 1,  MOVE N'MydbName' TO N'D:\Database\MSSQL.1\MSSQL\Data\MydbName.mdf',  MOVE N'MydbName_log' TO N'D:\Database\MSSQL.1\MSSQL\Data\MydbName.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO

Description: This enables email on the SQL Server.

Link: http://www.codekeep.net/snippets/5c1f6265-dc74-443b-90ab-3a355a9afe80.aspx

sp_configure 'show advanced options' , 1
GO

RECONFIGURE WITH OVERRIDE;
GO

EXEC sp_configure 'Database Mail XPs', 1
GO

RECONFIGURE WITH OVERRIDE;
GO

-- Next expand the Management Node
-- Right click over DATABASE MAIL
-- Select CONFIGURE DATABSE MAIL
-- In last step of Wizard be sure to check PUBLIC and set a DEFAULT to YES.

Description: Alter session to set date format in sql plus.

Link: http://www.codekeep.net/snippets/472e9886-aa1b-4f19-861b-22f6a1a6a0eb.aspx

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY MM DD';
select sysdate from dual;

Description: more info http://www.sqlservercentral.com/articles/dmv/64425/

Link: http://www.codekeep.net/snippets/0a4730e0-19f7-4d09-bb73-7b351851a397.aspx

 -- Do not lock anything, and do not get held up by any locks.
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    -- What SQL Statements Are Currently Running?
    SELECT [Spid] = session_Id
	, ecid
	, [Database] = DB_NAME(sp.dbid)
	, [User] = nt_username
	, [Status] = er.status
	, [Wait] = wait_type
	, [Individual Query] = SUBSTRING (qt.text, 
             er.statement_start_offset/2,
	(CASE WHEN er.statement_end_offset = -1
	       THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
		ELSE er.statement_end_offset END - 
                                er.statement_start_offset)/2)
	,[Parent Query] = qt.text
	, Program = program_name
	, Hostname
	, nt_domain
	, start_time
    FROM sys.dm_exec_requests er
    INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
    CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
    WHERE session_Id > 50              -- Ignore system spids.
    AND session_Id NOT IN (@@SPID)     -- Ignore this current statement.
    ORDER BY 1, 2

Description: COPY DATA FROM TABLE TO TABLE

Link: http://www.codekeep.net/snippets/69774736-33e8-4023-ab73-2f80e664158f.aspx

USE [master]
GO
/****** Object:  StoredProcedure [dbo].[COPY_TABLE]    Script Date: 10/17/2011 11:44:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/***
OBJET :		STORED PROCEDURE
AUTHOR :		ELAMEEN ELSAYED
DESC :		MOVE TABLE'S ENTIRE DATA TO ANOTHER TABLE
VERSION 2011/10/08 :		@PRINT VARIABLE TO PRINT QUERY,
@BASE VARIABLE TO SPECIFY FROM WHICH TABLE THE LIST OF COLUMNS ARE GOING TO BE ACQUIRED
VERSION 2011/10/16 :		CHECK IF THE TABLE HAS IDENTITY FIRST,
@APPEND VARIABLE TO APPEND ROWS


***/
ALTER PROC [dbo].[COPY_TABLE] (
@SRC_DB NVARCHAR(100),
@SRC_SCHMA NVARCHAR(100),
@SRC_TBL NVARCHAR(100),

@DSTN_DB NVARCHAR(100),
@DSTN_SCHMA NVARCHAR(100),
@DSTN_TBL NVARCHAR(100),
@PRINT BIT=1,
@BASE BIT=0,
@APPEND BIT=0
)
AS
BEGIN
		
		DECLARE @LQS NVARCHAR(MAX), @LQS2 NVARCHAR(MAX),@COLS_TABLE NVARCHAR(MAX),@DB_COLS_TABLE NVARCHAR(MAX)
		IF @BASE=1 
			SELECT @DB_COLS_TABLE=@DSTN_DB,@COLS_TABLE=@DSTN_TBL 
		ELSE
			SELECT @DB_COLS_TABLE=@SRC_DB,@COLS_TABLE=@SRC_TBL 
			
		SELECT @LQS='
		DECLARE @COLS_LST NVARCHAR(MAX),@CMD NVARCHAR(MAX) 
		SELECT @COLS_LST=STUFF((SELECT  '',''+COLUMN_NAME
		FROM   '+@DB_COLS_TABLE+'.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='''+@COLS_TABLE+'''
		FOR XML PATH('''')),1,1,'''');'+
		CASE WHEN @APPEND=0 THEN  +' DELETE FROM  '+@DSTN_DB+'.'+@DSTN_SCHMA+'.'+@DSTN_TBL+';' ELSE '' END +
		' SELECT @CMD=''SET IDENTITY_INSERT  '+@DSTN_DB+'.'+@DSTN_SCHMA+'.'+@DSTN_TBL+' ON;INSERT INTO '+@DSTN_DB+'.'+@DSTN_SCHMA+'.'+@DSTN_TBL+' (''+@COLS_LST+'')
		SELECT ''+@COLS_LST+'' FROM '+@SRC_DB+'.'+@SRC_SCHMA+'.'+@SRC_TBL+';SET IDENTITY_INSERT  '+@DSTN_DB+'.'+@DSTN_SCHMA+'.'+@DSTN_TBL+' OFF;'';
		
		EXEC SP_EXECUTESQL @CMD;
		'
		--CHECK IF DOESN'T HAVE IDENTITY
		DECLARE @IDENT_FLG BIT;
		SELECT @LQS2 ='
		USE '+@DSTN_DB+';
		SELECT @IDENT_FLG=COALESCE(OBJECTPROPERTY(OBJECT_ID('''+@DSTN_TBL+''') , ''TableHasIdentity''),0);
		'
		EXEC SP_EXECUTESQL @LQS2,N'@IDENT_FLG BIT OUTPUT',@IDENT_FLG OUTPUT
					
					 
		IF @IDENT_FLG=0
			BEGIN
				--WITHOUT IDENTITY
				SELECT @LQS='
				DECLARE @COLS_LST NVARCHAR(MAX),@CMD NVARCHAR(MAX) 
				SELECT @COLS_LST=STUFF((SELECT  '',''+COLUMN_NAME
				FROM   '+@DB_COLS_TABLE+'.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='''+@COLS_TABLE+'''
				FOR XML PATH('''')),1,1,'''');'+
				CASE WHEN @APPEND=0 THEN  +' DELETE FROM  '+@DSTN_DB+'.'+@DSTN_SCHMA+'.'+@DSTN_TBL+';' ELSE '' END +
				'SELECT @CMD=''INSERT INTO '+@DSTN_DB+'.'+@DSTN_SCHMA+'.'+@DSTN_TBL+' (''+@COLS_LST+'')
				SELECT ''+@COLS_LST+'' FROM '+@SRC_DB+'.'+@SRC_SCHMA+'.'+@SRC_TBL+';'';
				
				EXEC SP_EXECUTESQL @CMD;
				'
			END
		IF @PRINT =1 
			PRINT  @LQS
		ELSE
			EXEC SP_EXECUTESQL @LQS
				
END

Description: Read Excell file into Sql Server

Link: http://www.codekeep.net/snippets/ab729219-61f0-4c4a-8573-bd69dde9c0f9.aspx

EXECUTE sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO

EXECUTE sp_configure 'Ad Hoc Distributed Queries', '1'
RECONFIGURE WITH OVERRIDE
GO

EXECUTE sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
GO
--insert into tbAll
SELECT *
FROM
OPENROWSET
('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=C:\Documents and Settings\administrator\Desktop\MRG1.xlsx;Extended Properties=Excel 12.0 XML;HDR=YES',
'SELECT * FROM [Sheet1$]')
--load 2008
 

Description: DISPLAY HIERARCHY DATA IN A RECURSIVE CHILD PARENT COLUMNS

Link: http://www.codekeep.net/snippets/b0b84cdf-6c54-40ba-a496-70be353ceee2.aspx

declare @t table (id int, parent int)
insert @t (id, parent) 
SELECT  EmployeeID,ReportsTo
FROM NORTHWIND..Employees
; with cte as (
    select  id, parent
    ,       cast(RIGHT(REPLICATE(' ',12) + 
                 CONVERT(varchar(12),id),12) as varchar(max)) Path
    from    @t
    where   parent is null
    union all
    select  child.id, child.parent
    ,       parent.Path + RIGHT(REPLICATE(' ',12) + 
                                CONVERT(varchar(12),child.id),12) as Path
    from    @t child
    join    cte parent
    on      parent.id = child.parent
)
select  *
from    cte
order by        Path

Description: trims out given characters from left or right side of a given string

Link: http://www.codekeep.net/snippets/89b7e2d8-4172-47d5-959e-db5950df3760.aspx

create function [dbo].[rtrim]
/*
    Author: Sergey Nefedyev
    Date: 2011-09-27

    UDF Fuction that returns passed in @string value after removing characters in 
    @remove from right side of the string

    Sample Call
        SELECT dbo.rtrim('ABCD987*', '*789A')
    Output
	   ABCD
*/
(
 @string nvarchar(max), 
 @remove nvarchar(100)
)
returns nvarchar(max)
as
begin
    while right(@string, 1) like '[' + @remove + ']'
    begin
        set @string = substring(@string, 1, datalength(@string)/2-1)
    end
    return @string
end
go

create function [dbo].[ltrim]
/*
    Author: Sergey Nefedyev
    Date: 2011-09-27

    UDF Fuction that returns passed in @string value after removing characters in 
    @remove from left side of the string

    Sample Call
        SELECT dbo.ltrim('ABCD987*', 'DCBA*')
    Output
	   987*
*/
(
 @string nvarchar(max), 
 @remove nvarchar(100)
)
returns nvarchar(max)
as
begin
    while left(@string, 1) like '[' + @remove + ']'
    begin
        set @string = substring(@string, 2, datalength(@string)/2-1)
    end
    return @string
end
go

create function [dbo].[trim]
/*
    Author: Sergey Nefedyev
    Date: 2011-09-27

    UDF Fuction that returns passed in @string value after removing characters in 
    @remove from left and right sides of the string

    Sample Call
        SELECT dbo.trim('ABCD987*', 'D9BA7*')
    Output
	   CD98
*/
(
 @string nvarchar(max), 
 @remove nvarchar(100)
)
returns nvarchar(max)
as
begin
    return dbo.ltrim(dbo.rtrim(@string, @remove), @remove)
end
go

Description: Find Specific word or phrase from all stored procedure, views, and triggers available in SQL Server 2005/2008

Link: http://www.codekeep.net/snippets/6a59c226-f6b1-477b-b40c-05911456c9f5.aspx

SELECT DISTINCT so.name,sc.text
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE so.xtype in ('P','TR','V') and sc.TEXT LIKE '%fsu%'
order by name

Description: This script will kill all current connections to a database in MSSQL. This is useful for detaching the database, restoring it or performing other tasks that require all connections dropped from the database.

Link: http://www.codekeep.net/snippets/78688de6-4801-42ad-abc3-fb7d28e2c3b2.aspx

DECLARE @SQL VARCHAR(8000)

SELECT @SQL=COALESCE(@SQL,'')+'Kill '+CAST(spid AS VARCHAR(10))+ '; '
FROM sys.sysprocesses
WHERE DBID=DB_ID('<DATABASE_NAME>')

EXEC(@SQL)

Description: A merge type statement for SQL Server prior to 2008

Link: http://www.codekeep.net/snippets/14b6d8ca-3796-48a5-8ba2-d67660f56374.aspx

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Stephen Smith
-- Create date: 24 August 2011
-- Description:	Saves or Updates a Saga state
-- =============================================
CREATE PROCEDURE SaveSaga 
	@id uniqueidentifier, 
	@name nvarchar(255),
	@state nvarchar(255),
	@xml text
AS
BEGIN
	BEGIN TRANSACTION Upsert
	
	update Saga with (serializable)
	set ID=@id, Name=@name, [State]=@state, [xml]=@xml, PersistedOn = GETDATE()
	where ID=@id
	
	if @@rowcount = 0
	
	insert into Saga (ID, Name, [State], [Xml], PersistedOn)
	values (@id, @name, @state, @xml, GETDATE()) 

	COMMIT TRANSACTION Upsert
END
GO

Description: Add a trigger to a table to update a date column with the current UTC Date Time value. This trigger will update all UPDATEs to the table.

Link: http://www.codekeep.net/snippets/dcc2724f-c438-4aee-89d9-799a0d49edc1.aspx

-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER trgUpdateMYTABLE ON MYTABLE FOR UPDATE AS
BEGIN
	UPDATE MYTABLE
	SET LastModified = GETUTCDATE()
	FROM MYTABLE INNER JOIN deleted d
	ON Attachments.ID = d.ID
END
GO

Description: Split function for t-sql

Link: http://www.codekeep.net/snippets/760efaa4-489c-4feb-96c9-9274e5f98a99.aspx

/****** Object:  UserDefinedFunction [dbo].[ufn_Split]    Script Date: 08/24/2011 10:09:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE FUNCTION [dbo].[ufn_Split]
(
	@string VARCHAR(200)
	, @delimiter VARCHAR(5)
)

returns @splitValues table

(
	rowId smallint identity(1,1),
	splitValue varchar(200)
)

as

begin

	-- ufn_Split
	-- Splits an incoming string by the delimiter returns a table of the split values.
	--
	-- Maintenance
	-- Date				Developer					Description
	-- 06/15/2011		Rob Horton					Creation.

	declare @splitLength int

	while len(@string) > 0

		begin

			select @splitLength = 
				(
					case charindex(@delimiter, @string) 
						when 0 then len(@string) 
						else charindex(@delimiter, @string) -1 
					end
				)

			insert into @splitvalues
			select ltrim(rtrim(substring(@string, 1, @splitLength)))

			select @string = 
				(
					case (len(@string) - @splitlength) 
						when 0 then ''
						else right(@string, len(@string) - @splitlength - 1) 
					end
				)
		end
		return
end

Description: backup all your sql server databases and save them to a folder with date format file name.

Link: http://www.codekeep.net/snippets/11920fec-c67e-4eaa-99a3-17023afc9724.aspx

DECLARE @DBName VARCHAR(255)
DECLARE @DATABASES_Fetch INT
DECLARE @DBFileName VARCHAR(256)    
DECLARE @DateName VARCHAR(256)    

SET @DateName = (SELECT CONVERT(VARCHAR,GETDATE(),20))
SET @DateName = REPLACE(REPLACE(@DateName,':',''),'-','') 

DECLARE DATABASES_CURSOR CURSOR FOR
    SELECT
        DATABASE_NAME = DB_NAME(s_mf.database_id)
    FROM
        sys.master_files s_mf
    WHERE
		-- ONLINE
        s_mf.state = 0 
		-- Only look at databases to which we have access
		AND HAS_DBACCESS(DB_NAME(s_mf.database_id)) = 1 
		-- Not master, tempdb or model
		AND DB_NAME(s_mf.database_id) NOT IN ('Master','tempdb','model')
    GROUP BY s_mf.database_id
    ORDER BY 1

OPEN DATABASES_CURSOR
FETCH NEXT FROM DATABASES_CURSOR INTO @DBName
WHILE @@FETCH_STATUS = 0
BEGIN
    SET @DBFileName = @DateName + ' - ' + REPLACE(REPLACE(@DBName,':','_'),'\','_') + '.bak'
    EXEC ('BACKUP DATABASE [' + @DBName + '] TO  DISK = N''c:\backup\' + 
        @DBFileName + ''' WITH NOFORMAT, INIT,  NAME = N''' + 
        @DBName + '-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD,  STATS = 100')
    FETCH NEXT FROM DATABASES_CURSOR INTO @DBName
END
CLOSE DATABASES_CURSOR
DEALLOCATE DATABASES_CURSOR

Description: This sp, can give you the portion of code of a long running query, given the id of connection. Fantastic for find wich point of your query is very slow.

Link: http://www.codekeep.net/snippets/a2864f58-5ef6-4b88-b705-5aab772e9cf6.aspx

-- Procedure para identificar o ponto exato de execução de um statement
USE MASTER
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_usrinputbuffer]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_usrinputbuffer]
GO
CREATE PROCEDURE dbo.sp_usrinputbuffer
(
	@SPID smallint,		-- O SPID a ser analizado
	@WAIT tinyint = 1,	-- Intervalo de repetição entre as verificações.Valor deve estar entre 0 e 60 segundos
				-- Default é de 1 em 1 segundo
	@NoLoop bit = 1		-- Se =1, o SPID é analizado apenas uma vez. Se =0 fica em loop até o final do processo.
)
AS
BEGIN

/********************************************************************************************
sp_usrinputbuffer: Esta procedure permite identificar a instrução exata que está sendo 
executado por uma dada conexão. Semelhante ao DBCC INPUTBUFFER mas diferente desta, em caso 
de procedure, a proc mostra toda a instrução inteira e não apenas o nome da procedure. Muito boa
para ser usada em conjunto com a procedure sp_usrheadblocker.

Exemplo: sp_usrinputbuffer 54 (Onde 54 é o ID da conexão SPID)

Obs: Se preferir, esta pode ser criada em qualquer banco, porém, ao executá-la deverá passar o nome da
base onde a mesma se encontra. Exemplo: Base..sp_usrinputbuffer 54

Author Original: Narayana Vyas Kondreddi
Source: http://vyaskn.tripod.com
Date Created: 18/12/2003
Alterada por : Nilton Pinheiro
WebSite: http://www.mcdbabrasil.com.br
*********************************************************************************************/	
	 
	SET NOCOUNT ON
 
	DECLARE @sql_handle binary(20), @handle_found bit
	DECLARE @stmt_start int, @stmt_end int
	DECLARE @line varchar(8000), @wait_str varchar(8)
 
	SET @handle_found = 0
 
	IF @WAIT NOT BETWEEN 0 AND 60
	BEGIN
		RAISERROR('Valores válidos para @WAIT estão entre 0 e 60 segundos', 16, 1)
		RETURN -1
	END
	ELSE
	BEGIN
		SET @wait_str = '00:00:' + RIGHT('00' + CAST(@WAIT AS varchar(2)), 2)
	END
 
	WHILE 1 = 1
	BEGIN
		SELECT	@sql_handle = sql_handle,
			@stmt_start = stmt_start/2,
			@stmt_end = CASE WHEN stmt_end = -1 THEN -1 ELSE stmt_end/2 END
			FROM master.dbo.sysprocesses
			WHERE	spid = @SPID
				AND ecid = 0
  
		IF @sql_handle = 0x0
		BEGIN
			IF @handle_found = 0
			BEGIN
				RAISERROR('Não pode encontrar o handle ou o SPID é inválido', 16, 1)
				RETURN -1
			END
			ELSE
			BEGIN
				RAISERROR('Query/Stored procedure completada', 0, 1)
				RETURN 0
			END
		END
		ELSE
		BEGIN
			SET @handle_found = 1
		END
 		Print '******** STATEMENT SENDO EXECUTADO NO MOMENTO ************'
		Print ''
		SET @line = 
		(
			SELECT 
				SUBSTRING(	text,
						COALESCE(NULLIF(@stmt_start, 0), 1),
						CASE @stmt_end 
							WHEN -1 
								THEN DATALENGTH(text) 
							ELSE 
								(@stmt_end - @stmt_start) 
    						END
					) 
   			FROM ::fn_get_sql(@sql_handle)
  		)
 
		Print @line
 
		IF @NoLoop = 1
		BEGIN
			RETURN 0
		END
 
		WAITFOR DELAY @wait_str
 
	END
 
END
GO

Description: Email Scripts

Link: http://www.codekeep.net/snippets/8d00dfda-717e-44ee-ad21-5c443a138c87.aspx

select * from tblSubscribers where email like '%mail%'



--SELECT	RIGHT(Email, CHARINDEX('@', REVERSE(Email))-1) AS [Domain Name], COUNT(Email) AS [Number of Subscribers]
SELECT	SUBSTRING(email,(CHARINDEX('@',email)+1),50) AS [Domain Name], COUNT(Email) AS [Number of Subscribers]
FROM 	tblSubscribers 
--GROUP BY RIGHT(Email, CHARINDEX('@', REVERSE(Email))-1)
GROUP BY SUBSTRING(email,(CHARINDEX('@',email)+1),50)
ORDER BY [Number of Subscribers] DESC, [Domain Name]


SELECT * 
FROM tblSubscribers 
WHERE NOT
(
	CHARINDEX(' ',LTRIM(RTRIM([Email]))) = 0 
AND  	LEFT(LTRIM([Email]),1) <> '@' 
AND  	RIGHT(RTRIM([Email]),1) <> '.' 
AND  	CHARINDEX('.',[Email],CHARINDEX('@',[Email])) - CHARINDEX('@',[Email]) > 1 
AND  	LEN(LTRIM(RTRIM([Email]))) - LEN(REPLACE(LTRIM(RTRIM([Email])),'@','')) = 1 
AND  	CHARINDEX('.',REVERSE(LTRIM(RTRIM([Email])))) >= 3 
AND  	(CHARINDEX('.@',[Email]) = 0 AND CHARINDEX('..',[Email]) = 0) 
)

Description: get date from datetime (without time part)

Link: http://www.codekeep.net/snippets/1f4f9ee7-7ec6-437e-a4f3-0ff6b0868a5b.aspx

DECLARE @dateStartDay dateTime
DECLARE @dateStartMonth dateTime

-- in @dateStartDay the date 
SELECT @dateStartDay = DATEADD(dd, DATEDIFF(dd, 0, @dateStart), 0)

-- in @dateStartMonth the date aproximated to month
SELECT @dateStartMonth = DATEADD(mm, DATEDIFF(mm, 0, @dateStartDay), 0)
	

Description: Get database max size and current size in Teradata

Link: http://www.codekeep.net/snippets/95fa504e-8893-415e-82af-1987e3b96f08.aspx

select databasename,cast(sum(maxperm)/1024/1024/1024 as decimal(7,2)) max_perm,cast(sum(currentperm)/1024/1024/1024 as decimal(7,2)) current_perm
,cast(sum(maxspool)/1024/1024/1024 as decimal(7,2)) max_spool,cast(sum(currentspool)/1024/1024/1024 as decimal(7,2)) current_spool
from dbc.diskspace where databasename = 'U_GSI_SANDBOX_P'
group by databasename order by max_perm desc;

Description: Get table size of all tables in a Teradata database

Link: http://www.codekeep.net/snippets/78369bcb-ffb4-45e1-90d6-997a8347e68b.aspx

Select tablename, sum(currentperm) as TableSize from dbc.tablesize
where databasename = 'U_GSI_ANALYTIC_P'
group by tablename

In this video, the existing application will be modified to move functionality into a separate assembly. Proper naming conventions will be discussed, as well as the ConfigureAwait method, which can be used to avoid unnecessary marshaling of data to the UI thread.

In this video, the existing application will be modified to add cancellation support. For each HREF link found, a method will be called which will enter into an infinite loop, periodically downloading the HTML content of that link, looking for changes using the TaskEx.Delay method. In addition, a CancellationToken will be passed through each method, allowing the user to cancel out of the process at any time.

In this video, the existing application will once again be modified to offload the work of searching through the HTML using the TaskEx.Run method. This will allow that work to be done on a background thread.

In this video, the application created in the first segment will be modified to download the content of each HREF link concurrently using the TaskEx.WhenAll method and the await keyword. The length of the returned content will then be appended to each item in the ListBox.

In this video, we will create a simple application to download the HTML content of the MSDN home page, and then use a regular expression to search through that HTML, looking for any HREF links. They will be pulled out and displayed in a ListBox. The application will be written the “old” way without any asynchronous calls, and will then be modified to use the Async CTP.

This video shows how you can record a VBA macro in Microsoft Excel 2010 and then copy it to Visual Studio 2010 and convert the code to C# 4.0.

Using Visual Studio 2010, you can build Office 2007 solutions and Office 2010 solutions that target both the .NET Framework 3.5 and the .NET Framework 4. The requirements for installing these solutions vary depending on the version of Office and the .NET Framework your solution targets. In this video you will explore these requirements.

You can deploy an Office solution using ClickOnce deployment. Learn how you can perform post-deployment actions such as copying the document to the user's computer during install. Creating the post-deployment action requires writing some code and modifying the application manifest.

You can deploy an Office solution using ClickOnce deployment. When you publish a solution, you create the files ClickOnce needs, including a setup routine. If you have multiple solutions, you will have multiple setup routines. Learn how you can combine the setup routines into one so that when users run the setup routine they will install all of the solutions at the same time.

Explore a hyperlinked version of the C# grammar – learn about new keywords and where they fit in the language.

Given a Word 2007 add-in including one or more smart tags targeting the .NET Framework 3.5, you may want to change the add-in to target .NET Framework 4, so you can take advantage of new framework features. Changing the target version of the framework for a Word add-in from .NET Framework 3.5 to .NET Framework 4 is easy, but requires specific steps.

Given an Outlook add-in targeting the .NET Framework 3.5, you may want to change it to target .NET Framework 4, so you can take advantage of new framework features. Changing the target version of the .NET Framework for an Outlook add-in from .NET Framework 3.5 to .NET Framework 4 is easy, but requires specific steps.

C# 2010 adds several language improvements that Visual Basic .NET users have enjoyed for years that make it far easier to interact with Office object models. Reduce the size and complexity of your C# code using these new language features.

Visual Studio 2010 provides a project type that enables developers to build Business Data Connectivity (BDC) Models that produce .NET connectivity assemblies for Business Connectivity Services (BCS) in SharePoint 2010. This allows you to connect external data sources and expose them to SharePoint. In this example a BDC Model will be created that access and updates data in a SQL Server database.

Visual Studio 2010 provides a project type that enables developers to import a Site Definition and add code. This site definition can then be deployed to a Solution Gallery and new sites created on the basis of Site Definition. Learn how to import a SharePoint 2010 Site Definition in Visual Studio 2010.

Sites can be created from Site Definitions in the create dialog in SharePoint. New Site Definitions can be created in Visual Studio 2010 and then deployed to SharePoint 2010. Learn how to create a new Site Definition and then add a Web Part to the site's default.aspx page using Visual Studio 2010. The Web Part will filter tasks based on their due date.

List Definitions and List Instances that are based on those definitions are fundamental part of Microsoft SharePoint 2010. Microsoft Visual Studio 2010 provides developers with a project type that simplifies the creation of List Definitions in XML and the creation of List Instances based on those definitions. Tight integration with Microsoft SharePoint 2010 allows List Definitions and List Instances to be deployed to a SharePoint site directly from Visual Studio 2010.

A Content Type is a reusable collection of settings that can be defined and applied to data in a SharePoint list or library. Visual Studio 2010 provides project types that support the creation and deployment of content types. Learn how to create a SharePoint 2010 Content Type from Visual Studio 2010.

Visual Studio 2010 provides a project type that enables developers to build Event Receivers that perform actions before or after selected events on the SharePoint 2010 site. Learn how to create an Event Receiver for SharePoint 2010 in Visual Studio 2010. In this example an event will be added to the Adding and Updating actions for Custom List items.

Visual Studio 2010 provides a template for a State Machine workflow that enables developers the opportunity to build workflow solutions for SharePoint using a graphical design surface. State Machine workflows transition from state to state rather than the transition from activity to activity that is found in a sequential workflow. Learn how to create a SharePoint 2010 State Machine Workflow in Visual Studio 2010.

Visual Studio 2010 provides a template for the creation of a Sequential Workflows that enables developers the opportunity to build workflow solutions within SharePoint using a graphical design surface. Sequential Workflows have a pre-determined order of activities that define the workflow. Learn how to create a SharePoint 2010 Sequential Workflow in Visual Studio 2010.

Visual Web Parts allow developers to build SharePoint 2010 Web Parts using a design surface in Visual Studio 2010. This allows for drag and drop of user controls from the Toolbox to build the visual web part's user interface. Learn how to create a Visual Web Part for SharePoint 2010 in Visual Studio 2010.

This video shows how to edit data from a DataGridView in a details form which opens when one double clicks on the RowHeader of the DataGridView. Since both forms are bound to the same datasource one sees an instant update on both forms when the user decides to save the data and additional roundtrips to the database are avoided.

Microsoft Visual Studio Languages Program Manager Dustin Campbell shows how to refactor your code with the tools available in Visual Studio.

Microsoft Visual Studio Languages Program Manager Dustin Campbell shows how to use the refactoring tools in Visual Studio.

Visual Studio Languages PM Dustion Campbell shows how to step with the Debugger in Visual Studio.

Learn how to use the Call Hierarchy window, a new feature in Visual Studio 2010 that helps you discover the call sites in your application. This feature requires Visual Studio 2010 or higher.

In this video Lead PM Karen Liu shows how the new IDE feature called Generate from Usage allows developers to write code that consumes a library or API before that API even exists. This feature requires Visual Studio 2010 or higher.

Code Snippets allow you to automatically insert short fragments of code into your program. Based on Code Templates that you can create and edit yourself, Code Snippets are easily cusomizable. This video shows how Code Snippets work, how to edit existing Code Snippets and how to create your own Code Snippets. This feature requires Visual Studio 2005 or higher.

Visual Studio allows you to use a feature called Highlight References that allows you to visually see and navigate between the references to a symbol in your file. This feature requires Visual Studio 2010 or higher.

Microsoft Engineer Eric Lippert explains how to use covariance and contravariance in C# 4.0.

Microsoft Engineer Eric Lippert explains how to use covariance and contravariance in C# 4.0.

Learn how new features in C# 4.0 make it easy for C# developers to work with COM objects in general, and Microsoft Office in particular. (Requires Visual Studio 2010.)

The new Named and Optional Parameters feature in C# 4.0 provides an alternative to method overloading. (Requires Visual Studio 2010.)

Visual Studio developers will learn how to create a master-detail (or one-to-many) data entry form against the Entity Framework in WPF using Visual Studio 2008 Service Pack 1.

Visual Studio developers will learn how to hook up validation code on Entity Framework entities and customize the display of errors on WPF controls using Visual Studio 2008 Service Pack 1.

Visual Studio developers will learn how to build a simple local report showing data from a database using the ReportViewer control in Visual Studio 2008.

Visual Studio developers will learn how to build a data access layer using Entity Framework in order to query and display the results in a WPF list box.

Visual Studio developers will learn how to build a WPF data entry form to query, navigate, and edit data against the Entity Framework.

Visual Studio developers will learn how to build a simple local report showing data returned by a business object using the ReportViewer control in Visual Studio 2008.

Visual Studio developers will learn how to build a simple local report showing data from a database using the ReportViewer control in Visual Studio 2008.

ADO.NET Entity Framework is an object-relational mapping (ORM) framework for Microsoft .NET. In this video, Todd Miranda explores how to use the Entity Framework to access and manipulate data from a database.

Visual Studio developers will learn how to format data in controls on WPF data entry forms using Visual Studio 2008 Service Pack 1.

Visual Studio developers will learn how to create a master-detail (or one-to-many) data entry form in WPF using Visual Studio 2008 Service Pack 1.

Visual Studio developers will learn how to create a simple data grid in WPF for editing tabular data using Visual Studio 2008 Service Pack 1.

You can add managed controls from the Visual Studio Toolbox (such as a button) and native Microsoft Office Word 2007 controls (such as a content control) to documents at run time. Learn how to use Visual Studio 2008 with Service Pack 1 to create an application-level add-in that can add controls to any open document.

Visual Studio Tools for Office developers will learn how to deploy their Excel 2007 document-level solutions with Windows Installer by using Visual Studio 2008.

Visual Studio Tools for Office developers will learn how to deploy their Excel 2007 application-level add-ins with Windows Installer by using Visual Studio 2008.

Visual Studio developers will learn how to select data from a database and display it in a WPF ListBox in a variety of ways using Visual Studio 2008.

Visual Studio developers will learn how to create a simple data entry form in Windows Presentation Foundation (WPF) using Visual Studio 2008 that allows navigation as well as edit, add, delete and save of the data.

This video shows how to use the SoundPlayer control to play wav audio files in your application.

This video shows how to use the Windows Media Player ActiveX control to play wma and MP3 audio files in your application.

This video shows how to use the Web Browser control to bring the full functionality of Internet Explorer into your application.

This video shows how to use the Tree View control which provides a hierarchical view of data.

This video shows how to use the Tool Strip control which provides users of your application with a way to execute common commands.

This video shows how to use the Tab control which presents a familiar folder-style content navigation system, and is a good way to organize multiple panes of content in your application.

This video shows how to use the Status Strip control which is an elegant way for you to provide application progress or status information back to your users.

This video shows how to use the Rich Text Box control which allows users to input formatted text into your applications.

This video shows how to use the Picture Box control which allows you to display image files from your local machine or from the network.

This video shows how to use the Menu Strip control which provides a standard Windows style menu in your applications.

This video shows more advanced features of the List View control such as retrieving data from a database, editing item labels in a list view, synchronizing data, and grouping items.

This video shows the basics of using the List View control which provides a graphical representation of data elements.

This video shows how to use the Background Worker control to create a multi-threaded application.

This video shows how to use the Timer control which you can use to poll or monitor if an action has occurred in a given time interval.

This video shows how to use the TableLayout control which enables you to dynamically add rows to your controls at runtime.

This video shows how to use the SplitContainer control to create a multi-pane user interface.

This video shows how to use the Process control to automate running external applications like Notepad and Internet Explorer from within your code.

This video shows how easy it is to create applications that use the Windows system tray.

This video shows how to use the FlowLayout panel to create dynamically resizing Windows UI.

This video shows how to interact with common Windows Dialog controls, including the File Open, Save, Page Setup, Print, Color Picker, and Font Dialog controls.

This video shows how to take and customize the Button control including layout, hover effects, and events.

In part two of this webcast series, we dive into more detail about the gesture APIs that are available on the Microsoft Windows Mobile 6.5 platform. We show you how you can make use of the Gesture API when creating your managed applications, and we work through the code samples and a sample library that simplify the access to these gesture APIs.

In this webcast, we introduce you to the new gesture APIs that are available on the Microsoft Windows Mobile 6.5 platform. We demonstrate how you can make use of the gesture APIs when creating your managed applications, and we work through the code samples and a sample library that will simplify the access to the gesture APIs.

On Wednesday, May 2009, at 10 AM PST, Randy Starr, VP of Technology at BlueDot Solutions will talk about mfLY!® for Microsoft Visual Studio 2008. mFly® provides a model/view/controller Framework add-on to Visual Studio 2008 that significantly enhances the development experience, quality, and re-usability of managed Windows Mobile (and Microsoft Windows) applications through a unique set of designers, template and frameworks. Watch Randy demonstrate the primary features of mfLY! and see how it can help you improve the quality and time to market of your mobile projects.

We are moving right along with our MSDN Webcast Series on Windows Mobile Application Development. Our next webcast will focus on Development Line of Business Applications for Windows Mobile. On Wednesday, April 29 at 10 AM PST, Windows Mobile Device Application Development MVP and author of the 30 Days of ,NET Windows Mobile Application Development blog series Chris Craft will host a webcast on “The Embedded Database for Building Mobile Line of Business Applications.” In his webcast, Chris will provide an introduction into using Microsoft .NET Compact Framework and Microsoft SQL Server CE database development to create line of business applications, with a focus on database techniques for occasionally connected scenarios. The webcast will place a strong focus on data driven applications and data synchronization techniques.

Please join us for this week's MSDN as part of the 24-Hours of Windows Mobile Application Development series. On Wednesday, April 22, Nickolas Landry, MVP and Principal Architect of Infusion Development will WCF Development and Mobile Devices. Communicating with the server-side and the rest of your corporate network infrastructure is a key aspect of any mobile smart client application that lives within a distributed enterprise architecture. However, mobile devices aren't always on the Web or docked into the corporate network. Therefore your applications have to handle a range of scenarios for transferring data to and from the home office during times when a connection is available and storing information locally when a connection is not available. Windows Communication Foundation (WCF) provides a unified programming model for building connected applications with managed code on the desktop and the server. Thanks to the WCF extensible channel architecture, mobile devices can also participate and leverage WCF, but only a subset of the full WCF model is supported. This session explores the similarities and the differences in building mobile communications infrastructures using Microsoft .NET Compact Framework 3.5 and WCF. Through live demos using Microsoft Visual Studio 2008 and other mobile tools, we’ll cover the WCF programming model and available layers, the supported channels, integrating with the desktop and server-side, see how to cover the lack of device addressability, the role of Microsoft Exchange 2007, e-mail and AirSync, extensibility points, security and more. If you think you know everything about WCF, think again…mobile devices are also part of the enterprise equation and you need to learn how to reach out to them.

Enterprise mobile applications usually require that sensitive data is stored on a mobile device. This session shows you how to store data securely in encrypted form and, most importantly, how to store encryption keys securely so that an attacker can't get access to them. You'll also learn how to encrypt configuration files to hide sensitive data, and how to implement a working password-based access control system for your mobile apps. We'll also look at how to use client certificates to control access to server resources.

With Visual Studio 2008, Device Developers have a very powerful development environment at their hands. In this sample filled Webcast you will learn how to develop applications in managed code for Windows Mobile Devices and you will learn how to configure and make use of Device Emulator to test your applications. You will also learn how to write unit tests for your applications and how to make use of the .NET Compact Framework 3.5 Power Toys to analyze performance of your running applications. Of course you will also learn how to deal with data on your device, making use of SQL Compact CE. This webcast is your perfect preparation to get the most out of all Windows Mobile sessions during Tech-Ed 2009.

System Center Mobile Device Manager (SCMDM) is a complex product with a lot of dependencies which must all be in place in order for it to work correctly. This session, which takes almost 2 years of hands-on experience of deploying implementing SCMDM in the field, steps through how to successfully (and cost effectively) implement this product in the enterprise. The objective of this session is to address the misconception that SCMDM is hard to implement while showing how MDM eliminates almost all of the overhead associated with Blackberrys while retaining and elevating both manageability and security.

Digital Certificates and public/private key technology is core to Windows Mobile platform security. In this session, you’ll learn how certificates are used to provide authentication, access control and encryption for the OS, applications and networking. You’ll also learn best practices and “gotchas” for managing certificates on the device. The speaker is an expert on Windows Mobile Certificate management and certificate-related features in the OS. Come ready to ask any questions you may have: enrollment, import, SSL, root certificates, email security, application security, etc.

So, you are using Microsoft System Center Mobile Device Manager 2008 and Windows Mobile 6.1. Now what? You probably know that Mobile Device Manager can manage, secure, and install software on your phones. But did you know Mobile Device Manager also gives your users the potential to control the PC at their desk and access everything they need on the corporate network, including file shares, Microsoft Office SharePoint Server, instant messaging, and internal Web pages. In this webcast, we present the best practices for a Mobile Device Manager installation that provides users with access to everything they need in the corporate network through their phone and (just as important) denies access to resources mobile users don't need. We review the basics of Mobile Device Manager and IP security (IPsec) virtual private networks (VPNs), and we discuss the tools that users can take advantage of so they can work wherever they would like using their phone. Discover how Mobile Device Manager eliminates the need to expose your organization's Microsoft Exchange Server to the Internet.

Please join us for next week’s webcast in the series “24 Hours of Windows Mobile Application Development”. During this demo-filled webcast, Senior Mobility Consultant Alex Yakhnin will show how to customize .NET CF controls to create attractive UIs for Windows Mobile Devices. This is the second part of the series on creating attractive UIs on Windows Mobile devices (view part one: Creating Compelling and Attractive UIs for Windows Mobile Applications). In this webcast we'll show you how to customize the look of the built-in controls in the .NET Compact Framework such as TextBox, ListBox, and ListView.

Are you interested in learning how to create a compelling UI for your Windows Mobile app? If your answer is yes, please join us for part 20 or our 24-Hour webcast series on Windows Mobile Application Development. This week, Senior Mobility Consultant Alex Yakhnin will explain how to utilize the Alpha blending and Gradient drawing APIs on the Windows Mobile platform to create a compelling and attractive user experience in your mobile applications. Alex will also provide an example of how to create a framework that could be used to simplify the development of custom user interfaces.

Please join us for part 19 of the 24-Hours of Windows Mobile Application Development webcast series. For part 19 of the series, MVP Maarten Struys and developer content author Joshua Partlow will show you how to create your own customized Windows Mobile user interface controls using the .NET Compact Framework. The Microsoft .NET Compact Framework 3.5 ships with a variety of ready to use user interface controls. However, sometimes you might want to make use of controls with a slightly different or entirely different look, feel, and functionality. In this sample-filled webcast, you learn how to create your own controls that are derived from existing controls, how to create composite controls, and how to create entirely new controls. You also learn how to add designer support to Microsoft Visual Studio 2008 for your custom controls.

Please join us for part 18 of our 24-Hour series on Windows Mobile Application Development. On Wednesday, February 11, Mobility Architect Reed Robison will talk about how to use Language Integrated Query (LINQ) on Windows Mobile Devices. Come find out what Language Integrated Query (LINQ) brings to the Windows Mobile platform. In this webcast, we watch LINQ in action, explore the pros and cons of LINQ on Window Mobile, and help you understand what this powerful new feature can do for your development efforts using the Microsoft Compact Framework 3.5.

Please join us for part 17 of our 24-Hours of Windows Mobile Application Development Webcast Series. This week, Windows Mobile Device Application Development MVP Andrej Radinger will show you how to develop Windows Mobile applications using Visual Studio 2008. Microsoft Visual Studio 2008 brings lot of improvements for mobile developers, and Windows Mobile 6 software development kit (SDK) tools enable easier and faster solution development. In this webcast, we explain what is new in the Microsoft .NET Compact Framework 3.5 and how to develop Windows Mobile client applications effectively. We also show you some of the cool features that can be easily used in your applications, such as Pocket Outlook Object Model (POOM) integration, Short Message System (SMS) interception, state and notification broker, and camera integration. This webcast is packed with live demos and code samples.

Please join us for part of 15 of our series "24 Hours of Windows Mobile Application Develpment." This week, Mobility Development Consultant Mike Francis will share his top Windows Mobile Development tips. We will discuss common obstacles for common architectures, and will provide tips to avoid these obstacles and information on the Windows Mobile development resources that are available. We also cover what is new for developers in Internet Explorer Mobile 6.

Please join us for part 14 of our 24 Hours of Windows Mobile Application Development Webcast Series. This week, Maarten Struys and Constanze Roman will discuss Device Security for Windows Mobile Devices. The Windows Mobile Security model is very flexible. Using different security policies, it is possible to control which applications are allowed to run on a particular device and what those applications can do. In this sample-filled Webcast, we will explain how the Windows Mobile Security model works, and they show you how you can mimic device security using the emulator in combination with the Microsoft Visual Studio 2008 Device Security Manager. Maarten and I will also demonstrate how to sign your applications with certificates to allow them to run as either privileged or normal applications on Windows Mobile devices.

Please join us for part 13 of our Webcast series on 24 hours of Windows Mobile Application Development. The topic of tomorrow’s webcast will be Testing your Windows Mobile Applications. During tomorrow’s Webcast, MVP Maarten Struys, Windows Mobile Community PM Constanze Roman, and I will be talking about testing Windows Mobile applications. In this sample-filled webcast, you will learn how to debug applications using Visual Studio 2008, how to make use of logging and tracing data inside your Windows Mobile application, and how to use Hopper to stress test your applications.

Please join us for part 12 of our 24-hours of Windows Mobile Application Development webcast series. On Wednesday, December 10, Maarten Struys will be talking about Asynchronous Programming Techniques with the .NET Compact Framework. Join this webcast to learn how to properly start and terminate threads, update user interface controls inside multiple threads, and call Web services asynchronously. In this sample-filled webcast, we demystify multithreading, so you can feel confident in developing your own multithreaded applications.

Please join us for part 11 of our 24-part Webcast series on Windows Mobile Application Development. This week, Andy Wigley, co-author of the Wndows Mobile Development Handbook, will talk about networking. In this webcast, you learn how to create a network connection in code and how to discover if you have network connectivity. We look at the design of applications that need to be network aware and strategies for creating applications that can operate when disconnected from the network and then sync up data when network connectivity is restored. We also compare the options for transferring data over a network connection, which include ActiveSync, Microsoft SQL Server merge replication, remote data access (RDA), SQLClient, Microsoft Synchronization Services for ADO.NET, Windows Communication Foundation (WCF), SOAP-based Web services, RESTful data services, and Microsoft Message Queuing (MSMQ). We explain the benefits and shortcomings of each sync technology and demonstrate many of them so you can select the right solution for your data synchronization needs.

Join us for part 10 of our 24-Hours of Windows Mobile Application Development Webcast Series. This week's Webcast will be live from TechEd EMEA in Barcelona. We will be discussing GPS and Location Awareness. More and more Windows Mobile powered devices ship with integrated global positioning system (GPS) hardware. Since people typically use Windows Mobile devices on the road, it makes a lot of sense to add location awareness to your applications. In this Microsoft Developers Network (MSDN) webcast, we show how you can make proper use of the GPS Intermediate Driver to access GPS information from inside managed applications. We also discuss how to use the FakeGPS utility to test location-enabled applications without needing access to physical GPS hardware.

Join us for part 9 of our 24-part Windows Mobile Webcast series. For this part, we will be discussing Unit Testing for Mobile Devices. With Microsoft Visual Studio 2008, unit testing is now available for mobile device developers as well. Is unit testing just hype or can you increase the quality of your code by creating unit tests? In this sample-filled webcast, you will learn how to create unit tests for your smart device application. We will also show you how to debug unit tests and how to run unit tests inside a command prompt. After attending this webcast, you should rest assured knowing that your code works as intended.

Please join us for part 7 of our 24-Hours of Windows Mobile Application Development Webcast series. This week, MVP Maarten Struys will talk about interoperability between managed and native code. Even though the Microsoft .NET Compact Framework 3.5 contains a lot of functionality, sometimes it is unavoidable to call back (P/Invoke) into native Win32. In this webcast, we show you the basics of P/Invoke. In the second part of this webcast, we show how you can use existing COM objects inside your managed applications. Of course, both P/Invoking into native code and using COM objects inside managed applications are illustrated by a number of code samples.

Please join us for part six of our "24 Hours of Windows Mobile Application Development" Webcast series. This week's Webcast will discuss how to use Pocket Outlook data inside a managed application. To limit the amount of data that is stored on Windows Mobile devices and to provide users with a consistent user interface when dealing with Personal Information Manager (PIM) data, you must frequently make use of Pocket Outlook functionality inside your own managed application. In this sample-filled webcast, we show you how to retrieve, use, and store PIM data inside your own managed applications through the Windows Mobile Managed APIs that ship as part of the Windows Mobile 5.0 and Windows Mobile 6 software development kits (SDKs).

Please join us for part 5 of our Webcast series on Windows Mobile Application Development. In this MSDN webcast, you learn how to develop battery-friendly applications for Windows Mobile devices. During a large portion of this webcast, we explain and demonstrate the State and Notification Broker that provides easy access to more than 100 different hardware and system states, such as network connectivity and battery power, which are all consistently within reach by managed code.

Please join us for part 4 of our "24-hours of Windodws Mobile Application Development" webcast series. One of the key issues that Windows Mobile developers face is the issue of application compatibility across the range of Windows Mobile devices. As new devices are released, they introduce many new features. Successfully developing and deploying Windows Mobile applications requires up-front planning for compatibility across devices. In this webcast, Jim Wilson discusses creating adaptive applications that can run on a broad range of Windows Mobile Devices, giving end users more or less functionality, depending on the available features of their device.

Please join us for part 3 of the "24-hours of Windows Mobile Application Development" webcast series. Constanze Roman and Maarten Struys will show you how to create one single application that can target different Windows Mobile Devices with different form factors. Discover how docking and anchoring enable you to easily change between portrait and landscape mode, how to add touch-screen functionality for Windows Mobile Professional Devices, and how to create adaptive applications, taking advantage of the different hardware capabilities of Windows Mobile Devices.

In part two of the "Windows Mobile Application Development" series, Maarten Struys and Constanze Roman will discuss the new enhancements for Device Emulator 3.0. You will learn how to configure Device Emulator using the Device Emulator Manager and make use of Cellular Emulator to emulate phone calls and Short Message Service (SMS) messaging. You will also learn how to customize your own emulators and how you can programmatically control Device Emulator.

On Wednesday September 3, 2008, at 10 PST, a new webcast series on Windows Mobile Application Development will launch. In part one of the series, Maarten Struys and Constanze Roman will give you an overview of Windows Mobile Application Development and show you some of the tools you need to succeed.

Join devCentral, the AT&T Developer Program, and Microsoft for a free Webcast reviewing BizTalk RFID Mobile features, capabilities, and architecture. We will then explore code samples that show how to develop RFID applications on BizTalk RFID Mobile. All actual attendees will be entered to win an AT&T BlackJack II. Winner will be notified via email after the Webcast. When: Monday, July 14, 10:00 AM - 11:00 AM (GMT-08:00) Pacific Time (US & Canada). What you will learn: BizTalk RFID Mobile is a device agnostic RFID platform that will enable you to write your applications once and have them run on mobile RFID readers from a variety of manufacturers. You will receive the information that you need to get started writing applications. Registration is required. Presenters: Paul Sanford, Sr. Product Manager, BizTalk Server RFID team

On July 23rd at 10 AM PST, Constanze Roman and Maarten Struys will present an MSDN Webcast about Unit Testing for Devices. During this sample filled Webcast you will learn how to create Unit Tests for Devices using Visual Studio 2008, how to run those Unit Tests, how to debug them and how to automate Unit Testing by executing your tests from a command prompt.

In this webcast, hosted live from Tech∙Ed Orlando, we wrap up our series on getting ready for Tech∙Ed by revisiting some of the highlights of our previous webcasts. We talk about developing for Windows Mobile devices and share some interesting demos with you; for example, one demo is on unit testing for devices. We also show you how to use FakeGPS with your own location data. We might even interview some Tech∙Ed attendees!

In this webcast, we focus on the considerations you need to make when selecting and using a local device data store, including coverage of Language Integrated Query (LINQ) as it is implemented in the Microsoft .NET Compact Framework.

In this Webcast you will learn how to access Pocket Outlook from inside your own managed application, how to add location awareness to your application, and how to make phone calls from inside your own managed application.

Developing Windows Mobile 6 applications with the Microsoft .NET Compact Framework allows you to take advantage of your existing desktop developer skills and enables you to begin developing mobile applications quickly. In this webcast, we address how you can deal with different form factors, battery life, and so on.

In this MSDN MSDN webcast, Maarten Struys and Constanze Roman show you how to develop applications for Windows Mobile devices. This crash course in Windows Mobile software development, which part 1 of 5, helps prepare you for the Windows Mobile sessions to be presented at Tech∙Ed Orlando on June 3–6.