Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Dukagjin Maloku - Dugi'DBA

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

Archives: May 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, 289 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, 356 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.

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

Read more

645 comments, 5,489 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, 495 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, 9,181 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, 6,337 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, 3,173 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, 2,347 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, 829 reads

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