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
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
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".
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
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
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
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
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
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
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
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
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
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:
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
It's very interesting if you create new folder with name:
Try it and you will find a lot of stuff there for Windows 7. It works also in Windows XP!
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:
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… Read more
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… Read more
The best of Tech Ed in Los Ageles award winners were selected from Windows IT Pro and SQL Server Magazine, and the winners are:
- Business Intelliegence - DevExpress Analytics
- Database Administration - xkoto GRIDSCALE for SQL Server
- Database Development - Quest TOAD for SQL Server
- Developer Tools - AVIcode Intercept…
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… Read more