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 ...

SQL Server 2008 R2 is available now...

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

2 comments, 286 reads

Posted in Dukagjin Maloku - Dugi'DBA on 21 April 2010

SQL Server 2008 R2 new Editions - Info

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

56 comments, 633 reads

Posted in Dukagjin Maloku - Dugi'DBA on 21 April 2010

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

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:

  • Supported OS: Windows 7; Windows Server…

Read more

0 comments, 307 reads

Posted in Dukagjin Maloku - Dugi'DBA on 16 April 2010

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

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…
Read more

1 comments, 535 reads

Posted in Dukagjin Maloku - Dugi'DBA on 4 April 2010

The Way - The Reason

 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

6 comments, 228 reads

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

Indexes - where you cannot create them!

Indexes are the objects that DBA uses them everyday and maintaining them very often, during the maintenance routines. The main purpose that we use the indexes is to retrieve data as fast as it possible.

Types of indexes are:

Cluster  - max 1 per table & more about the… Read more

2 comments, 978 reads

Posted in Dukagjin Maloku - Dugi'DBA on 29 March 2010

SQL Server 2008 R2 - The list of the supported features

The MSDN - Microsoft, has collected too much info about features supported by the SQL Server 2008 R2, for all editions (DataCenter, Enterprise, Standard, Web, Workgroup, Express with Advanced, Express with Tools, Express). The list contains very usefull info about the fetures where the companies or users can find the… Read more

1 comments, 458 reads

Posted in Dukagjin Maloku - Dugi'DBA on 24 March 2010

SP_SPACEUSED & SP_MSTABLESPACE

Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005), and they are the documented one which is "sp_SpaceUsed" and undocumented one "sp_MSTableSpace".

SP_SPACEUSED

Yes, it is documented store procedure inside the SQL Server 2008 (incl,… Read more

3 comments, 1,658 reads

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

Info about Maximum specifications for SQL Server 2008/2005

A quick info where you can find the Maximum specification for SQL Server 2008/2005 (32 bit & 64 bit).

SQL Server 2008 - Max Specification

SQL Server 2005 - Max Specification

There it is some big max possibility in SQL Server:

Database size - 524,272 TB
Databases per instance of… Read more

0 comments, 656 reads

Posted in Dukagjin Maloku - Dugi'DBA on 21 March 2010

Determine which version of SQL Server is running...

Since the early versions of SQL Server, from version 6.5 we can know and determine the latest version that we install in our machine. I will show you the list that determine the latest version of the SQL Server.

In SQL Server 2008/2005 (using SSMS) & 2000 (using Query Analyzer)… Read more

0 comments, 441 reads

Posted in Dukagjin Maloku - Dugi'DBA on 20 March 2010

A little restriction that prevent changing tables in SQL Server 2008

In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and we want to change the datatype or adding any column in a table with SSMS (SQL Server Management Studio), and the SSMS will said to… Read more

4 comments, 1,604 reads

Posted in Dukagjin Maloku - Dugi'DBA on 20 March 2010

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

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

The content of this update includes 11 Presentations, 17 Demos, 10 Hands-on Lab and 17 Videos, yes it is lot of stuff!

It is dedicated for the SQL Server developers who build applications with Microsoft… Read more

0 comments, 264 reads

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

MS SQL Server Migration Assistant for MySQL v1.0 CTP1

There it is the SQL Server Migration Assistant or SSMS for MySQL, it comes for both versions SQL Server 2008 & 2005.

The SQL Server Migration Assistan 2008 differs from SSMA 2005 that it supports migration also with SQL Azure.

Supported Operating Systems are Win 7, Win Server 2003, Win… Read more

1 comments, 761 reads

Posted in Dukagjin Maloku - Dugi'DBA on 20 February 2010

SQL Server 2005/2008, Service Packs - announcement

This is a good news from the Microsoft about SQL Server Release Services for both versions SQL Server 2008 & 2005.

SQL Server 2005 SP4 can be released in Q4/2010 and the support will extanded & will be available through 2016/04/12 (ymd). For more specifics you can check http://support.microsoft.com/lifecycle/

SQL… Read more

0 comments, 174 reads

Posted in Dukagjin Maloku - Dugi'DBA on 19 February 2010

SQL Server 2008 R2 Update for Developers Training Kit

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... Read more

0 comments, 211 reads

Posted in Dukagjin Maloku - Dugi'DBA on 5 February 2010

Another free tool for SQL Server...

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… Read more

3 comments, 483 reads

Posted in Dukagjin Maloku - Dugi'DBA on 5 February 2010

Azure platform CTP accounts are about to expire?

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… Read more

3 comments, 148 reads

Posted in Dukagjin Maloku - Dugi'DBA on 21 January 2010

SQL Server 2008 R2 - official date

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 Read more

0 comments, 171 reads

Posted in Dukagjin Maloku - Dugi'DBA on 21 January 2010

Windows Azure Platform Training Kit

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.… Read more

0 comments, 343 reads

Posted in Dukagjin Maloku - Dugi'DBA on 20 January 2010

GodMode - in Windows 7

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!
Read more

0 comments, 175 reads

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

Newer posts

Older posts