Report Server Course

Links:
http://msdn.microsoft.com/en-us/library/ms153561.aspx
http://msdn.microsoft.com/en-us/library/ms156500.aspx
http://www.developer.com/db/article.php/10920_3727626_2
http://msdn.microsoft.com/en-us/library/ms157406(sql.90).aspx
http://blogs.msdn.com/bwelcker/archive/tags/Reporting+Services/default.aspx
http://www.sql-server-performance.com/articles/reporting/index.aspx
http://lyon-smith.org/blogs/code-o-rama/archive/2007/03/22/visual-studio-column-guides-redux.aspx
http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en
http://visualstudiomagazine.com/columns/article.aspx?editorialsid=1900
Husk Report Builder 2.0
Og her er koden i forbindelse med Report server kurset d 25. – 27 feb:
Private Sub
LoadInformation()Â
 ‘load information into list view
lstView.Items.Clear()
 Dim myCatalogItems As
CatalogItem()myCatalogItems = rs.ListChildren(“/”, True)Â
For Each cItem As CatalogItem In myCatalogItemsÂ
Dim strValues(3) As String
strValues(0) = cItem.Name
strValues(1) = cItem.Path
strValues(2) = cItem.Type.ToString()strValues(3) = cItem.CreatedBy
lstView.Items.Add(New ListViewItem(strValues))Â
Next
End Sub
Private Sub DisplayCurrentInfo()Â
Me.Cursor = Cursors.WaitCursorÂ
‘display item information in messagebox
Dim [...]

SQL 2005 Course

Samples, Utils and Links from MOC 2780 SQL 2005 Course.
Check All Databases with undocumented stored procedure:
EXEC SP_MSForEachDB @command1=”Print ‘?’ DBCC CHECKDB (‘?’)”
Another track to the same station.
Declare @db VarChar(100),
 @dbid int,
 @hidb int
Select @hidb = Max(dbid ), @dbid = 0 from master..sysdatabases
While @dbid < @hidb
Begin
   Set @db = null
   Select @db = name
   From sysdatabases
   Where dbid = [...]