It is a good news for developers! Microsoft published the Training Kit for SQL Server 2008 R2.
The content of this Training Kit includes 8 videos, 8 Presentation, 8 Hands-on Labs and 13 Demos. - good stuff!
For more info and download you can check here
Have a nice SQL-Developing...
Stay Tuned!
Let me show you another free tool for SQL Server that is very usefull and thanks from the companies that are serves us with them for free. A few days before Bred McGehee presents us a free tool and very smart & fast tool from RedGate company, it is SQL Search 1.0 and you can take a look a little explanation how it works. So let me introduce another free tool for SQL Server from Idera, it is SQL Permissions which let us to transfer logins and permissions from one server to another. SQL Permissions offers the flexibility to move logins or group of logins and apply permissions accross one or more DBs on target server.
System requirements and prerequisites for SQL Permissions are:
SQL permissions supports the following versions of Microsoft SQL Server:
For more info and other related products you can check here.
I recieved the notification from Azure Platform Team that the CTP accouct will be closed at the end of the January 2010.
If you decide to not continue with upgrade, on February 1, 2010, accounts will be disabled and SQL Azure databases will be made read-only. Finally they will be deleted on March 1, 2010.
Trying for 2-3 months the Azure platform just for test and I spend good time with data in cloud, also using some tools about Azure. I have decide to not continue for the moment.
Have nice SQLing with Azure if anyone decided to continue next...
Since the August 2009 when the CTP ( Community Technology Preview) version was available, the Microsoft announced the offical release date for SQL Server 2008 R2 and will be available by May 2010!
SQL Server 2008 R2 will include some technology inside that users can use them:
Master Data Services
StreamInside
Application and Multi Server-Management
Managed Self Service BI
For more info click here
Everyone interesting for Windows Azure Platform Training Kit - December Update, can find it from Microsoft location here.
There are lot of stuff and you can download it in your local machine and enjoy the collection of the training video and other training set like presentations, demos etc etc.
It's very interesting if you create new folder with name:
GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}
Try it and you will find a lot of stuff there for Windows 7. It works also in Windows XP!
Interesting!
n'joy!
Little info about System Resource Database in (SQL Server 2008/2005)
The fifth system database in both versions (SQL Server 2008 - 2005) is Resource Database. In this DB we have all relevant information about systems objects and functions that we use every day in our daily routine, such as:
SELECT SERVERPROPERTY('ResourceVersion');GOSELECT SERVERPROPERTY('ResourceLastUpdateDateTime');GOSELECT OBJECT_DEFINITION(OBJECT_ID('sys.objects'));GOSELECT SERVERPROPERTY('Edition');GO
The Resource Database is the read-only DB , all sys.objects in SQL Server are organized in this DB physically and logically are appears in sys schema of every DB.
Physical name for the Resource Database are mssqlsystemresource.mdf - data file and mssqlsystemresource.ldf - log file, the location has been changed and it is different in both versions.
SQL Server 2008SystemDrive:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Binn\.
SQL Server 2005SystemDrive:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
The Resource DB depends from master DB, so if you remove your master DB also you will move the Resource DB.
SQL Server cannot backup up the Resource DB, it can be done manually and the restore should be done manually as well, and must be careful to not overwrite the current Resource DB.
More and other related info about Resource DB can be checked from here.
Hi to everyone! I decide to write it in my blog here about this problem because really don't have any idea what was the problem with SQL Profiler in both versions of SQL Server ( 2005 & 2008). This error doesn't depend from any SQL Server update or any Windows update ... really wondering!
So the error msg is:
The application faild to initialize properly (0x0000005). Click OK to terminate program. - that's all, nothing else!
So the solutions was:
Start your machine in Safe Mode; logon as local Admin; go to C:\Windows\system32\ ; then find the file with name "sysfer.dll" - very very problematic file that is comming from Symantec Corporation and it is part of Symantec CMC Firewall. This is the file that stops to start the SQL profiler, and sure that I have Symantec End Point protection as antivirus (maybe the other antivirus softwares didn't do this problem!!!).
So just rename the file like sysfer123.dll and leave it; restart your machine and you will be able to start the SQL profiler!
I wrote it in my blog and puting in the tips & tricks, because for the long time for that reason I didn't work with SQL profiler! - too bad!
So finally everyone can enjoy to solve this problem in this way!
Yes, Albanian SQL Server User Group will start soon with first meeting and registering the new users. So we will start from Kosova soon and will see what will be the agenda for the first meeting. engagements has been started and we are working on it that the PASS Chapter in Kosova to be attractive for the new users and our comunnity at general! Later will see the possibilities to invite someone from outside ( experts or MVP ) and to be more interesting, these people can make interesting and very professional lectures from their knowledge about SQL Server.
I believe in success and we will do the best that we can for this local event in our newest state in the World (Kosova)!
The best of Tech Ed in Los Ageles award winners were selected from Windows IT Pro and SQL Server Magazine, and the winners are:
Yesterday, in Prishtina - capital city of Kosova, has been held the TechUpdate Seminar 2009 from Microsoft, organized from the Microsoft local office in Prishtina in cooperation with Microsoft Skopje Office. This is the 4th time organized TechUpdate in Kosova and everytime we have introduce with new technologies and new features for the new products from Microsoft. Extended Agenda for this TechUpdate was:
It was great presentations all the day, and nice experience to be together with IT people there.
The best for me was:
So hope that in the future we will organize with more technologies and other guests from IT world!
Hmm, SQL Server 2008 is completed everyday till possible new versioin. So know we have available the SQL Server 2008 R2 ( Release two).
SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 by providinga wealth of new features and capabilities that can benefit your entire organization. This release will further improve IT Efficiency with new and enhanced management capabilities and empower business users to access, integrate, analyze and share information using business intelligence tools they already know.
New things in SQL Server 2008 R2:
With this new release, IT professionals, developers and business users will experience the following benefits:
More information here.
At the end of August 2009 will organize the Software Freedom Kosova 2009, the big event for the Open Source and Linux.
The message from this event is MEET NEWBORN EUROPE Prishtina-Kosova!
Ok, this is the first Software Freedom Conference of Kosova, so as newborn and developing nations the focus will be on:
Talks will be held in Albanian and English!
On 28th - 30th August 2009 we will meet in University of Prishtina.
As you can see the Conference is open for everyone and it is free, for more information you can click here. - why not to be there!?
I just recieve the announcement for the Mircosoft event TechUpdate 2009, in Prishtina capital city of Kosova! The event will be held on 13th May 2009 in Hotel Grand Prishtina! The purpose of the event is to refresh the knowledge Microsoft's technologies and trends. So the agenda is related to latest Microsoft technologies available on the market and the presentations will be about:
Yep, yesterday in Prishtina, capital city of Kosova was held the event named, Oracle Day in Kosova! It was very nice presentation for the new products and new features from the Oracle 11g, Agenda was about Database, Fusion Middleware and Applications so I and some of my friends as SQL Server users was there to see what new from Oracle 11g! Nearly were 100 participants in this event and it was nice introduction with other people who uses the Oracle but also SQL Server, lot of coffee and lunch. Many company and many banks are using Oracle, but also we have company that are using SQL Server. Soon, during this month in Prishtina City will organized the TEChUpdate 2009. Hope that in the future to have more events from Microsoft!
Very nice to be informed with new technology features especially from SQL Server and Oracle!