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