Welcome to Romanian SQL Server User Group Sign in | Join | Help

Save a tree

Did you know?
  • A ton of recycled paper is equivalent to recycling a newspaper and two white sheets daily for one year.
  • A ton of recycled paper saves 20 trees, 3.800 kWh, 32.000L of water and prevents 27 kg of pollutants from being released into atmosphere.

So why we recycle paper?

  • To reduce deforestation, and this way there will be fewer: landslides, climate change, floods, habitat and biodiversity destruction and destruction of recreation areas;
  • To reduce the imports of wood
  • To reduce water consumption by up to 60%;
  • To reduce energy consumption by up to 40%;
  • To reduce air pollution by up to 70%;
  • To diminish pollution by up to 35%;
  • To decreases the amount of garbage deposited in landfills or incinerators.

Personal story: I lost 60kg of extra weight today :) - I mean by that recycling 60 kg of paper. ( For Bucharest you can use "Depozitul de maculatura".)

Posted 15 mai 2010 16:52 by xmldeveloper | 0 Comments
Filed under:

SQL Server 2008 R2 resources (reloaded)



The SQL Server 2008 R2 RTM is here and with it a lot of new resources.
  1. Test Drive
  2. Webcasts, Videos and events
  3. Blog posts
  4. Books
  5. Documentation
  6. Whitepapers
  7. E-Learning Clinics (thanks to Greg Low)
  8. Local Resources

Posted 22 aprilie 2010 10:13 by xmldeveloper | 0 Comments

SQL Server 2008 Express R2 RTM?

At least the following downloads are available:
Microsoft SQL Server 2008 R2 RTM - Express
Microsoft SQL Server2008 R2 RTM - Express with Advanced Services
Microsoft SQL Server 2008 R2 RTM - Express with Management Tools
Microsoft SQL Server 2008 R2 RTM - Management Studio Express

In case you didn't know the SQL Server 2008 R2 Express Edition - expands the size limit of a user database to 10GB.

Also looking at the downloads related to SQL Server 2008 R2 it seems that also a trial is available for download.
Posted 21 aprilie 2010 14:03 by xmldeveloper | 0 Comments
Filed under:

To tweet or not to tweet?

Probably this is not the right question. What is certain is that twitter has become a valuable source of information. I had to add new words to my language, words like "to tweet" "tweetup" "twitterview". You have no idea what tweetup or twitterview means? Tweetup or tweet-up is defined by Macmillan Dictionary as [quote] a meeting of two or more people who know each other through the Twitter short messaging service [/quote]. Impressions from a SQL Server 2008 R2 tweetup can be found on SQL Server Team's FaceBook page and on The blog from the dkRanch - The Tweetup.
As for twitterview - I will assist at the first one (for me) in a few hours:
[quote]
Donald Farmer ‘Twitterview’ with SQL Server Magazine
Attention SQL Server enthusiasts: mark your calendar for April 14, 9:30 AM PDT. SQL Server Magazine is hosting a ‘Twitterview’ with Donald Farmer, Principal Program Manager for SQL Server. This is your opportunity to ask Donald your burning BI questions. This is a continuation of SQL Server Magazine’s article by Shelia Molnar about Microsoft’s BI Strategy.
Not participated in a Twitterview before? It’s easy! Donald will answer your questions via the SQL Server Magazine Twitter account (@SQLServerMag) from 9:30 AM to 10:00 AM PDT.
[/quote]

If you ever need help with SQL Server use the hashtag (a hash tag is simply a tag with the hash "#" symbol as prefix) #sqlhelp.

I will close by mentioning just a few of the channels I follow:
  • @MS_SQL_Server - The official SQL Server twitter
  • @billramo - Bill Ramos SQL Server expert on manageability and performance troubleshooting and fan of agile and UI development
  • @SQLServerMag - SQL Server Magazine is dedicated to helping DBAs, database developers, and BI professionals get the most out of SQL Server.
  • @SSRS - Blogs Posts and Connecting with the SQL Server Reporting Services Team
  • @buckwoody - Buck Woody - Database Guy
  • @mssqltips - MSSQLTips - Your source for daily SQL Server tips
  • @donalddotfarmer - Donald Farmer - Working @ Microsoft in Business Intelligence. Personal interests: philosophy, art, and indulgences starting with food and wine and ending who knows where?
  • @sqlpass - Professional Association for SQL Server. Connect, Share, Learn.
Come to the twitterview with Donald Farmer Yes

Published Update
Twitterview: Microsoft’s Donald Farmer on SQL Server 2008 R2 (the transcript)
SQL Server 2008 R2 Tweetup Video Montage


Posted 11 aprilie 2010 20:15 by xmldeveloper | 0 Comments

SQL Server 2008 R2 resources



With SQL Server 2008 R2 RTM knocking at the door a list with R2 resources may come in handy.
So here you are:
  1. SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)
    [quote]
    The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications, as well as for developers who are new to SQL Server.
    [/quote]
    It contains presentations (22), demos (29), hands-on labs (18), videos (35) as well as an utility to help configuring your computer for running the demos.
  2. E-Learning Clinics (thanks to Greg Low)
  3. Webcasts
  4. Whitepapers
  5. GITCA Fireside Chats
  6. PASS - The Professional Association for SQL Server
  7. Articles and blogs
  8. Downloads
  9. Local Resources
  10. Other resources
  11. Free ebook: Introducing Microsoft SQL Server 2008 R2
Enjoy!
Posted 11 aprilie 2010 09:53 by xmldeveloper | 0 Comments

SQL Server 2008 R2 gets a release date

According to Data Platform Insider blog, May 2010 will bring SQL Server 2008 R2 both on Microsoft's products price list and also to the customers.

More details here: SQL Server 2008 R2 gets an official date
Posted 20 ianuarie 2010 12:25 by xmldeveloper | 2 Comments
Filed under:

Security Development Lifecycle (SDL) - Quick Security References

Microsoft SDL (Security Development Lifecycle) team released recently two guidance papers:
The SQL Injection subject is not at all new. As an example 9 years passed since NGSSoftware published their SQL Server Injection Whitepapers.
What brings new the SDL Quick Security Reference on SQL Injection? Among other things it describes the role in addressing this issue for the business decision maker, the architect, the developer, and tester.
The following graphic based on data published by breach.com shows the importance of SQL Injection as a threat:


Posted 19 ianuarie 2010 11:39 by xmldeveloper | 0 Comments
Filed under:

Get it while it's hot - SQL Server 2008 R2 November CTP

It is supposed to be feature complete. What will differ in the RTM version depends on your feedback!
Download the CTP here: Microsoft SQL Server 2008 R2 November CTP
Posted 14 noiembrie 2009 12:06 by xmldeveloper | 0 Comments
Filed under: ,

Can you guess the new name of Gemini ?

If you answered no, the new name for what we used to know as project Gemini is Power Pivot Smile
You can read more about it at http://www.powerpivot.com/
Yyou can also follow the project on twitter http://twitter.com/powerpivot
Posted 19 octombrie 2009 18:35 by xmldeveloper | 0 Comments

Analysis Services Multidimensional Data Tech Center

It's new and fresh and has a lot of Business Intelligence: it's the new Analysis Services Multidimensional Data Tech Center.
Oh, and it comes in two flavors a Dev one and and ITPro:
Enjoy !
Posted 25 martie 2009 10:21 by xmldeveloper | 0 Comments
Filed under:

Where do I get my Data Mining dose

Until recently the SQLSeverDataMining.com was the place to get SQL Server DM.
Now we have a Data Mining TechCenter.
Enjoy !
Posted 4 martie 2009 04:34 by xmldeveloper | 0 Comments
Filed under: ,

Meeting Rafal Lukawiecki - round 2

Rafal came again in Romania for a BI Tour. With this ocassion we had a chance to meet him and freely discuss various subjects. As a side note Rafal is an MVP now :)



  • As usual we started with BI. Project Gemini - means Power for Excel - in memory analysis. If you want to read more about it, Ron compiled a large list with resources here: http://blogs.msdn.com/ronpih/archive/2008/10/09/the-gemini-project.aspx
  • Next we moved to the financial problems of the present and what they would mean to BI and more generally to IT. Rafal has a simple statement and I agree with him: IT Solutions should become Business Solutions. IT has no choice but to deliver business value.
  • Then we went back to BI to several features new in SQL Server 2008, to real life questions and so on.
  • What's next to come? Rafal expects to see the "Move to the cloud" tendency to evolve. And that is of course exciting.
  • Before leaving for his plane, I had one more confirmation that Rafal is as geeky as I am (not that I had any doubts about it) when he bragged about his new Sony Book Reades. Pretty cool.
Posted 4 martie 2009 04:03 by xmldeveloper | 0 Comments

Care for a CTP ?

If you are waiting for SQL Server 2005 SP3, well, you will have to wait (not for long). Or you may want to install the SQL Server 2005 SP3 CTP.
Posted 1 noiembrie 2008 00:01 by xmldeveloper | 1 Comments
Filed under:

Exceptional DBA Awards 2008 and Data Mining in the Cloud

So for today two good news, one for me and one for everyone.

First one, I made it through the final of Exceptional DBA Awards 2008. If you want to vote (for me of course Smile ) you can use this link: http://www.exceptionaldba.com/vote.htm

Second news, the one for you, Bogdan Crivat showed me how to use Data Mining Add-ins with your own or with demo data. You can play with it here: http://www.sqlserverdatamining.com/cloud/

The long story can be found on Bogdan's blog: http://www.bogdancrivat.net/dm/archives/47

 

Posted 1 septembrie 2008 16:44 by xmldeveloper | 1 Comments

Before installing SQL Server 2008 RTM (updated)

You may wanna check requirements especially if you have Visual Studio 2008 installed.
SQL Server 2008 RTM requires Visual Studio 2008 SP1 (not available yet) so you may have a problem. I did.


Solutions:
  • Uninstall Visual Studio 2008 pre SP1 components (SP1 beta won't work either)
  • Wait for the SP1 (should be released soon)
  • When you install SQL Server 2008 make sure you don't select features that use the VS Shell (BIDS, Analysis Services, Integration Services).

Thanks to Bob Ward we have the problem documented here: Microsoft SQL Server 2008 Release Notes

 

Posted 8 august 2008 10:05 by xmldeveloper | 3 Comments
Filed under: