SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Dukagjin Maloku - Dugi'DBA

Everything that I can post for the SQL Server ...

24 HOPASS Bonus Sessions ..

Just for info that the incoming 24 Hours of PASS now has bonus sessions ...you can check for the details and register >>> http://bit.ly/9uyxNX

Read more

0 comments, 655 reads

Posted in Dukagjin Maloku - Dugi'DBA on 10 September 2010

A week far away...24 HOP!

I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great sessions with tracks about DBA, BI, DB Dev, and Porfessional Development. Once again the presenters will be the top - notch experts and SQL Server MVPs with strong experience and… Read more

0 comments, 611 reads

Posted in Dukagjin Maloku - Dugi'DBA on 8 September 2010

A great free tool for SQL Server...

Another free tool for SQL Server that supports SQL Server 2008/2005/2000, comes from xSQL Software, the Script Executor Commnity Edition, that provides for transactional execution of T-SQL scripts, it is a small application, totally free to use and very powerful for the DBAs and also Developers that allows you… Read more

1 comments, 1,103 reads

Posted in Dukagjin Maloku - Dugi'DBA on 3 September 2010

I need to say Hello, again...

For a long time I haven't been active member at SSC, so I'm coming back again, saying once again Hello to everyone and hoping that all your things are going as you wish!

Well, I wish you to have a nice day and have a nice SQLing to the all… Read more

2 comments, 566 reads

Posted in Dukagjin Maloku - Dugi'DBA on 3 September 2010

Getting Started with SQL Azure (doc)

Getting Started with SQL Azure - Very nice & short document about SQL Azure beginning process. This is the official document that is published from Microsoft, this document provides guidelines on how to sign up for SQL Azure, it has 23 pages and illustrated with examples and figures on how… Read more

0 comments, 1,204 reads

Posted in Dukagjin Maloku - Dugi'DBA on 7 July 2010

Stop'n'Start SQL Services via command prompt (cmd)

Using the command prompt for stopping and starting services is a very nice possibility and very fast! We know that SQL Server services must never stop, especially the SQL Server core engine service. During the system maintenance sometimes we need to restart the processes and it can be done also… Read more

9 comments, 14,762 reads

Posted in Dukagjin Maloku - Dugi'DBA on 23 June 2010

SQL Server 2008 R2 feature pack

Microsoft, has published things that can be very useful, in this case for the SQL Server users. They announced the feature pack for SQL Server 2008 R2, where you can find a lot of stuff and big collection of stand-alone packages which provide additional value for SQL Server 2008 R2.… Read more

5 comments, 2,668 reads

Posted in Dukagjin Maloku - Dugi'DBA on 22 June 2010

What a coincidence ....

Two of the biggest events in the Technology World will be held at the same date!

PASS SUMMIT 2010 (8-11, November 2010 - Seattle WA, USA)

TechEd Europe (8-12, November 2010 - Berlin, Germany).

We know that in both conferences will have very nice sessions and very valuable, also the… Read more

0 comments, 681 reads

Posted in Dukagjin Maloku - Dugi'DBA on 10 June 2010

MS TechUpdate Prishtina in Kosova (June 9, 2010)

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

0 comments, 1,754 reads

Posted in Dukagjin Maloku - Dugi'DBA on 9 June 2010

One more Fix Database Role in SQL Server

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

0 comments, 1,518 reads

Posted in Dukagjin Maloku - Dugi'DBA on 3 June 2010

TechUpdate Prishtina 2010, announcement

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

0 comments, 470 reads

Posted in Dukagjin Maloku - Dugi'DBA on 2 June 2010

It's Free, It's Non-Stop, It's 24 Hrs of PASS

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

4 comments, 520 reads

Posted in Dukagjin Maloku - Dugi'DBA on 17 May 2010

Tips from ...Rock Star DBA

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

3 comments, 735 reads

Posted in Dukagjin Maloku - Dugi'DBA on 14 May 2010

SQL Azure and T-SQL

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.


Read more

645 comments, 8,524 reads

Posted in Dukagjin Maloku - Dugi'DBA on 14 May 2010

SQL Server Azure features limitation

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

3 comments, 992 reads

Posted in Dukagjin Maloku - Dugi'DBA on 13 May 2010

SQL Server 2008 R2 backup/restore - simple Tip

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

9 comments, 10,159 reads

Posted in Dukagjin Maloku - Dugi'DBA on 12 May 2010

SQL Server with MS Access .adp Project file

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

5 comments, 12,225 reads

Posted in Dukagjin Maloku - Dugi'DBA on 11 May 2010

SET clause in SQL Server (2008/2005)

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

329 comments, 5,263 reads

Posted in Dukagjin Maloku - Dugi'DBA on 7 May 2010

Viewing the results before and after, during Update

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

204 comments, 3,410 reads

Posted in Dukagjin Maloku - Dugi'DBA on 6 May 2010

SQL Server 2008(R2) and Win Server 2008 R2 Core Edition

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

7 comments, 1,433 reads

Posted in Dukagjin Maloku - Dugi'DBA on 2 May 2010

Newer posts

Older posts