I have just come back from Opole. I have lecture today there. I am really impressed how the organized the conference. Also attendees were great :) They asked me many questions. I have met some guys from Microsoft (B.Zass, M.Kedziora) and also collegues from LGBS (M.Wojtaszek, R.Jendrusz).Today attendance was 40+.

Great :)

I have found my old lectures in Warsaw

Jeżeli faktycznie jest jedną z najciekawszych, to chyba nie najlepiej świadczy to o kondycji informatyki polskiej. Widzę tylko kilka jasnych punktów na bezkresnej przestrzeni zacofania...

pudła

Nie da się ukryć, że nie obyło się bez kilku ewidentnych gniotów, np.:

• Michał Niwicki (Aurox) w wielu infantylnych słowach pokazał, że Aurox potrafi obsługiwać BlueConnect,
• Krzysztof Surowiec (Uniwersytet Warszawski) w wielu kompromitujących słowach (typu „nie da się zrobić strony dobrze wyglądającej na PC bez użycia tabel, a tymczasem na stronach przeznaczonych dla PDA lepiej tabelek nie używać..”) pokazał, że na współczesnym WWW nie zna się za grosz.

trafione

Jednak na konferencji znalazło się również kilka autentycznie ciekawych prezentacji. W tym najbardziej interesujące dla mnie:

• Damian Widera przedstawił rozwiązanie Logotec Mobile@Connector — webaplikacja dla PocketPC wyklikana z kreatorów niczym program w MS Access, ;-)
• Marek Jarecki z SKK opowiedział o rozwiązaniach opartych na urządzeniach Intermeca i oprogramowaniu myAVIS — IMHO prawdziwy sens tej całej branży.

uogólnione

A przy okazji poczyniłem dalsze ciekawe obserwacje na temat „sens i przyszłość PDA”:

• PDA znikną, ponieważ zastąpią je smartfony — są mniejsze, lżejsze i wygodniejsze,
• PDA znikną, ponieważ zastąpią je notebooki — nie są wcale tak dużo większe ani cięższe,
• PDA nie znikną, ponieważ są najbardziej wygodne, łatwe oraz eleganckie i to nie tylko w zastosowaniach heavy-duty.

Powyższe trzy opinie spotykam już od jakiegoś czasu i chociaż każda z nich jest daleka od prawdy, to wszystkie trzy razem dosyć dokładnie opisują aktualny stan rozważań na ten temat. ;-)

W sumie jednak warto było...

 

 

Hello

Again about Katmai. Today I have started looking at EDP. Especially- performance data collections are really extremelly important for DBA's but also a little complicated.. Iti is only my first look. Pawel Potasinski is going to write an article about this. It will be available on January 2008.

 

details:(https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6962)

 

 

Data Collection and Performance Warehouse for Relational Engine

Performance tuning and troubleshooting are time-consuming tasks for the administrator. To provide actionable performance insights to administrators, SQL Server 2008 delivers more extensive performance data collection, a new centralized data repository for storing performance data and new tools for reporting and monitoring

Let's have a closer look to the another new feature.

(https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6965)

 

Registered Servers Enhancements

Enhancements to the Registered Servers tool window in Management Studio include running T-SQL queries and policies against groups of servers and the ability to share a common, centrally stored, server topology (Database Engine only).

 

Hello , I'm back again

Let's have a closer look to the next feature that you can see in CTP 5.

More details here: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6963

 

Service Broker Enhancements

Getting the data to the right place at the right time is important.  Service Broker Conversation Priority in SQL Server 2008 gives you greater control over the system by making it easy to configure priority rules so that the most important data is sent first and processed first. In addition, the new Service Broker Diagnostic Utility, ssbdiagnose, analyzes the configuration between two Service Broker services and reports back both the problems and their solutions.

Hello

I have just come back from first ITAD lectures.

The attendance was about 120 people, notes 4.37/5 , so it was not so bad :)

There were mainly students and the would like to come to ezU :)

 

Next week I go to Opole to my last lectures this year

 

Today I start another group on new features that are called Dynamic Develoment. The first one I would like to tell is Declarative Management Framework

(https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6973). I am writing a quite interesting article about this and hopefully it will be ready next week and available on Polish TechNet site.

I would like to point out that DMF is one of the greatest new features that s been introduced to SQL Server 2008.

Lets look what's new about DMF - according to Microsoft:

 

Declarative Management Framework (DMF) Enhancements

Enhancements to DMF include more expressive conditions (including support for common functions, T-SQL, and WMI queries), more robust target set filtering, custom messages for policies, and the inclusion of best practice policies.

 

Hello

Today let's have a look at the last enhacement CTP5 has brought.

This is very important feature as almost everybody uses SSIS in the every day DBA-life.

Go to the site (https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=7005) for details

 

Hello - today I am going to continue with new, cool features added in CTP5. Lets look what Microsoft has for us in Reporting Services. All the content you can also find there: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=7004

 

I have just found Microsoft published my webcast about creating a database using SSMS. It is not a big thing for most of us but there are still many newbies and I would like to help them to start working with SQL Server.

The webcast is in polish.

Hello folks

I have been quite busy last time so I have not found this article on time. But - now I have to tell you - go to TechNet and read it immediatelly. Pawel Weichbroth did a great job and publish his experience with managing and administering RAID volumes. This is a must for all DBA's. I know - we all know this well , but sometimes is good to know someone wrote a comprehensive scrub:

Hello folks. Again - what's new in the CTP5. Today lets look athe the AS. I have read much about this on the official site (https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=7003)

 

There are several improvement accordinpervasive insight in SQL Server 2008.

Detailed infromation is available here: http://www.microsoft.com/sql/2008/bi/index.html

This is a show where you can find any important information in high level overview.

 

Visit the link: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=7006

 

 

ITAD conference (IT Academic Days) will be on 12/4 (Gliwice) and 12/13 (Opole)  this year. This is one of the most important IT conferences for .NET Groups and students. I will be one of the speakers and tell about my company's most revolutionary application.

I try to publish some documents here before the showe begins.

 

 

Microsoft has released the CTP5 of the SQL Server 2008

You can downoload the product there: http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en

 

There are several improvements, lets say more than in the previous four together.

You should visit the link: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470  to check out what has been recently added.

 

 

 

 

A firend  of mine - Marcin Guzowski - has just published a veri interested article on TechNet site.

On this article he explains the log file in details.IMO every DBA should know what is going on with the file, how important it is, why having more than one file gives you nothing...

You can find the article there:

Hello folks

 

My article about CDC has just been submitted in Polish TechNet

Follow that link: http://www.microsoft.com/poland/technet/article/art0088_01.mspx

to read it. Please send me any feedback and comments you have

I really appreciate this

 

Table variable parameters

With SQL Server 2005,XML variables can be passed into stpored procedures and parsed with XQuery.The XML variable, as you probably know, can hold a table. In SQL Server 2008 there is possible to pass a table into a stored procedure directly:

use AdventureWorks
go

IF TYPE_ID('Person') IS NOT NULL
 DROP TYPE Person
GO

CREATE TYPE Person AS TABLE
(
 name    varchar(20)
 ,surname   varchar(20)
 ,BirthDate  int
)
GO

--create a stored procedure to test if a table can be passed as a parameter
IF  OBJECT_ID ('Test2008') IS NOT NULL
  DROP  PROC Test2008
GO
CREATE PROCEDURE Test2008
(
 @person_instance Person READONLY --cannot be modified
)
AS BEGIN
 SELECT * FROM @person_instance
END
GO

 
--declare a table variable
DECLARE @people as Person

--insert some data
INSERT INTO @people
VALUES ('Piotr','Nowak',1999),('Marek','Wolski',1988)

--run the stored procedure
EXEC Test2008 @people

How it works now, using SQL Server 2005:

first - a stored procedure that accepts an XML parameter

IF  OBJECT_ID ('Test2005') IS NOT NULL
  DROP  PROC Test2005
GO

CREATE PROCEDURE Test2005
(
 @personXML XML
)
AS BEGIN
 SELECT C.value('@name','varchar(20)') as ImieXML
     ,C.value('@surname','varchar(20)') as NazwiskoXML
     ,C.value('@BirthDate','int') as RokUrodzeniaXML
 FROM @personXML.nodes('/*') T(C)
END
GO

declaring an xml variable

DECLARE @xmlOsoba XML

put some data to the XML:
SET @xmlOsoba =(
 SELECT name, surname,BirtDate FROM aTable  AS L
 FOR XML AUTO)

EXEC Test2005 @xmlOsoba

Well, look at the code for SQL 2008, escecially at the stored procedure body. It is easier to manipulate tables that do magic on xml....