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)
Just for info that SQL Server 2008 R2 (32bit & 64bit) is available now and you can download the trial
* Note: International download options will be available in May, 2010.
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:
- Supported OS: Windows 7; Windows Server…
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:
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
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