On June 9, 2010 is held the annual event that in Prishtina is recognized as Microsoft TechUpdate. Presenters in this event were from Macedonia and Croatia and some local presenters. I wasn't there all the day, but I had little free time to meet with guest presenters, Tomislav Bronzin (Microsoft… Read more

Fixed Database Rols are: db_ddladmin, db_owner, db_accessadmin, db_securityadmin, db_backupoperator, db_datawriter, db_datareader, db_denydatawriter, db_denydatareader + one more that is dbm_monitor.

This is not a new Fixed Database Role, but you can use it when you establish the database mirroring on your SQL Server. It will be available in msdb sys… Read more

I have non-official info about the Microsoft event, and the only event, TechUpdate Prishtina, in Kosova. The event will be held on 09/06/2010 (dd/mm/yyyy), as always in Grand Hotel in Prishtina. I don't know the exact agenda, but I will publish it later. 

The event will be all the day,… Read more

Yea, it's FREE, it's NoN-Stop, it's 24 hours of PASS! Many of the bloggers have wrote about 24 Hrs of PASS, so there it is once again as reminder...

The biggest web-live presentations that will happened in the World, 24 Hrs of PASS, no need payment, just registration Read more

Thomas LaRock (SQL Server MVP) (Blog | Twitter | LinkedIN), recently has published the new book DBA Survivor: Become a Rock Start DBA, and many of the readers of this book also publish their review and everyone can say that they learn something new or refresh something… Read more

SQL Server Azure database supports the T-SQL, but no at all! For the SQL Server Azure and T-SQL are available three list (Supported, Partially Supported & Unsupported - statements):

Supported T-SQL statements.

• ALTER (SCHEMA, VIEW, ROLE)
• BEGIN...END
• CAST & CONVERT
• DROP (SCHEMA, ROLE, LOGIN, USER, VIEW, STATISTICS, etc)
• ORDER BY

Read more

SQL Server Azure, fully relational cloud database solution, is new possibility of the database administration and maintenance. I'm not going in deep to explain what about SQL Server Azure, the location where you can introduce and learn more is here & here.

In this post you will see the… Read more

Simple, but I think somebody will ask:

Can restore the SQL Server 2008 R2 database to SQL Server 2008 ?

Simple answer, No! You cannot restore your databases in SQL Server 2008 from SQL Server 2008 R2, (just simple test)!

Stay Tuned!

Read more

MS Access have a nice possibility if you want to connect with SQL Server databases and manipulate with data in the same way as MS Access mdb files. The MS Access files that can connect to the SQL Server has the extension .adp (Access Data Project - file) and… Read more

SET clause in SQL Server uses in combination with other clauses to change the current behavior of the SQL Server in current sessions. Many of the default settings of the SQL Server that was setting up before, can be changed with SET command, like date format, or first day of… Read more

DBAs & Developers using everyday UPDATE statement, and everytime before update they want to see what to update, after this they want to see what has been updated.

OUTPUT clause can give us new value & old value in one way. According to the T-SQL syntax the OUTPUT clause can… Read more

The WinServer 2008 Core Edition was the server that you cannot install the SQL Server 2008. The Win Server 2008 Core Edition can run specific server roles such as:

• Active Directory Domain Services
• DHCP
• DNS
• File Services
• Virtualization (Hiper-V)
  
• Print Services
• IIS (Web) etc..

It hasn't the GUI to operate… Read more

The cool update from SQL Server 2008 R2 is the possibility from Express Edition that changed the database limit from 4GB to 10GB (wow). Yep, no more limit database size just to 4GB, I think this is very nice info for the small businesses and it is cool update. SQL… Read more

SQL Server 2008 R2 is released on April 21st, 2010 and in parallel with this new release, now is available also the Books OnLine for SQL Server 2008 R2 that is the primary documentation for SQL Server. I think that the BOL for SQL Server is the nearest location for… Read more

The quote about Knowledge, sure it is Albanian quote:

Learn the Knowledge but you'll never get rewarded by the God(All-llah) until you use it!

Jakup Asipi, Albanian(born and died in Macedonia)

Read more

Just for info that SQL Server 2008 R2 (32bit & 64bit) is available now and you can download the trial

http://bit.ly/18gCbc

* Note: International download options will be available in May, 2010.

Stay Tuned!

Read more

SQL Server 2008 R2, it comes with new editions and lot of new features, also supporting the SQL Azure & PowerPivot with Excel 2010. The first info about SQL Server release date (21/04/2010) was on Brent Ozar (blog | twitter) post including info of the new features.

Except… Read more

On Aprill 2010 is available the SQL Server 2008 R2 Update for Developers Training Kit. This training kit inlcudes:

• Presentations (22)
• Demos (29)
• Hands-on Labs (18)
• Videos (35)

Once again a lot of stuff inside this Training Kit.

There are also system requirements:

Read more

SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update 2)

• 15 Presentation 
• 24 Demo
• 13 Hands-on Labs
• 35 Videos

The training kit includes the following content:

• Presentations (15)
• SQL Server 2008 R2 Update for Developers Overview Part I - SQL Server 2008 Review
• SQL Server 2008 R2…

 This is one thing outside the SQL World, but it has very strong place in every aspects, it is one quote that is very true and you will be part of it all the life:

The Quote is:

" If you want to do something you will find the way Read more