Archive

Archive for the ‘SQL Server’ Category

2011 in review…Coming in 2012?

January 8, 2012 1 comment

First of all, I want to thank you all for the 5000+ visits to my blog in 2011.

According to WordPress:  “A New York City subway train holds 1,200 people. This blog was viewed about 5,000 times in 2011. If it were a NYC subway train, it would take about 4 trips to carry that many people.”

I want to wish you all the best for the coming year!

This coming year will be a busy one in Microsoft technologies according to a may external examiners. I beleive that this year, Microsoft will target servers and businesses directly with a number of new releases:

And a lot more…

I my coming blog posts, I will cover some of theses as well as some of the highs and lows of Microsoft and software craftmanship in general!

Feel free to comment or suggest about some blog topics you’d like me to cover. I will LISTEN!

Can’t wait for SQL Server “Denali”…

November 18, 2010 Leave a comment

Here are a few features present in the Beta:

  • Full support of .Net Framework 4.0
  • Management Studio will use code snippets! (yeah like Visual Studio)
  • Support for UTF16 types.
  • Security: Ability to create custom sql roles.
  • Integration Services: Full rewrite in WPF (Windows presentation fundation)(The list of tools and applications that are coded in XAML is increasing).
  • Integration Services: Source code management

One thing, I cannot find written in black and white is support in Visual Studio 2010. I know it should be supported for SSIS, but what about SSRS?

Categories: SQL Server

Microsoft announces project “Crescent”.

November 11, 2010 2 comments

Project crescent is a continuation on the efforts of Microsoft to bring self service business intelligence to end users. It brings a Silverlight based tool on board as a fun user interface to interrogate data wharehouse, interact with data through charts etc.

I knew Silverlight was not fading 😉


Project Crescent will be available at the same time as SQL Server codenamed “Denali”!

More on project Crescent here http://blogs.msdn.com/b/sqlrsteamblog/archive/2010/11/09/a-glimpse-at-project-crescent.aspx

More on the Denali project here http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx and here http://news.softpedia.com/news/Microsoft-Unveiled-New-Generation-of-SQL-Server-165750.shtml

Categories: SilverLight, SQL Server

SQL Server 2010?


 

The other day I was talking with someone at the office saying that in fact SQL Server 2008 should have been SQL Server 2007 but the guys couldn’t make it.

I also said that we should expect an SQL 2010!

Here’s the first Microsoft webcast about it…

Well, take a look at the next release of Microsoft SQL Server codenamed ‘Kilimanjaro’ (first half of 2010)!

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032413071&EventCategory=5&culture=en-US&CountryCode=US

Kilimanjaro will add great things for reporting and analytics!  🙂

 

Well, we have a busy future! here some timelines:

Known Timelines…

Summer / Fall 2009

SilverLight 3 / Expression Studio 3

Visual Studio / Team Foundation Server / .Net Framework 4.0

2010 will be a busy year:

Exchange Server / Office SharePoint Server / SQL Server and ….may be Dynamics 5?

Categories: SQL Server

Talking about CRM 4.0 and Windows Server 2008 / SQL 2008

March 26, 2009 Leave a comment

 

Quote

Talking about CRM 4.0 and Windows Server 2008 / SQL 2008

 
 A great thing to know about CRM  and 2008 environment!
 
Categories: CRM, SQL Server

Cool SQL Server 2008 Migration for Integration Services (SSIS)

March 9, 2009 Leave a comment

 

This weekend, I had to reinstall (repair) my SQL 2008 Express with Advanced Services. I had lost the Visual Studio project templates for “Business Intelligence”, so I couldn’t create a new server report.

While it was repairing, I figured that was going to have a look at all the stuff in the maintenance wizard and stepped on this:

image

That’s so cool!

They finally have a migration tool for SSIS. A big improvement compared to the last migration which was from SQL 2000 to SQL 2005.

Categories: SQL Server