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

Browse by Tags

All Tags » SQL Server 2005   (RSS)

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 . Read More...
Posted 1 noiembrie 2008 00:01 by xmldeveloper | 1 Comments
Filed under:

SQL Server 2005 versus Oracle 11g - Taste Challenge

Read More...
Posted 18 martie 2008 15:42 by xmldeveloper | 3 Comments
Filed under:

They keep comming - Cumulative update package 6 for SQL Server 2005 Service Pack 2

http://support.microsoft.com/kb/946608/en-us Nope, it's not SP3 Read More...
Posted 19 februarie 2008 22:00 by xmldeveloper | 0 Comments
Filed under:

Is it the time for SQL Server 2005 SP3?

I would say yes and you can say yes too by voting here: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=326575 Read More...
Posted 13 februarie 2008 15:30 by xmldeveloper | 0 Comments
Filed under:

New Year Gift from SQL Server Managebility Team - SQL Server 2005 Best Practices Analyzer (January 2008)

Paul A. Mestemaker II, Program Manager for SQLCAT, starts the year by bringing gifts - an updated version of SQL Server 2005 Best Practices Analyzer. You can find in the box more than 60 new rules, rules for Analysis Services, BPA UI and command-line Read More...
Posted 19 ianuarie 2008 09:21 by xmldeveloper | 0 Comments
Filed under:

Screencast - Exploring Analysis Services using PowerShell

A few days ago I wrote how can one talk to Analysis Services. Though I have no PowerShell skills (I opened a PowerShell console 2-3 times) and I come from the Database Engine world - I thought that it would be interesting to try the powerSSAS provider Read More...
Posted 7 ianuarie 2008 22:26 by xmldeveloper | 0 Comments

Oldies but Goldies - Troubleshooting Analysis Services 2005 connectivity problems

or should I say Forever Young? If you try to troubleshoot AS connections like I had to, you will choose the second characterization for the Troubleshooting Analysis Services 2005 connectivity problems article. Read More...
Posted 5 ianuarie 2008 22:32 by xmldeveloper | 0 Comments

Free SQL Server 2008 and SQL Server 2005 training

From Microsoft Elearning: Clinic 6188: What's New in Microsoft SQL Server 2008 for Enterprise Data Platform - In this 1 hour on-line clinic, IT Professionals will learn about the new features in SQL Server 2008 that will help them to secure the enterprise Read More...
Posted 3 noiembrie 2007 15:03 by xmldeveloper | 1 Comments

I don't mean to brag but - We are the greatest

Microsoft SQL Server is in the Leaders quadrant for the Gartner Magic Quadrant for Data Warehousing! Read about it here Magic Quadrant for Data Warehouse Database Management Systems, 2007 or in the official announcement from Microsoft: Microsoft Is Positioned Read More...
Posted 19 octombrie 2007 18:26 by xmldeveloper | 1 Comments
Filed under:

Logon Triggers article - Lessons Learned

I wrote recently an article about Logon Triggers for Simple-Talk .You can read it here: Logon Triggers . While doing the research for this article I learned a few things: Common Criteria Certification does not guarantee that a product is secure but guarantees Read More...
Posted 10 octombrie 2007 22:34 by xmldeveloper | 0 Comments

SQL Internals Viewer

If you need to see the physical structure of your database you can use DBCC PAGE as described here: Read Index Structure [quote] CREATE TABLE #DBCCIND( PageFID INT, PagePID INT, IAMFID INT, IAMPID INT, ObjectID INT, IndexID INT, PartitionNumber INT, PartitionID Read More...
Posted 6 octombrie 2007 11:07 by xmldeveloper | 0 Comments

The return of the ring buffers

A year and a half ago I wrote about the undocumented Dynamic Management View sys.dm_os_ring_buffers in SQL Server Professional . Shortly the ring buffers expose internal server state information about memory, exceptions, or schedulers. Each ring buffer Read More...
Posted 2 octombrie 2007 15:36 by xmldeveloper | 0 Comments

Bring back my Query Analyzer

If you miss Query Analyzer you can still vote on the Connect site for this tool: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=297428&wa=wsignin1.0 However the answer from Microsoft is very clear: [quote] Thank you Read More...
Posted 2 octombrie 2007 09:33 by xmldeveloper | 0 Comments
Filed under: