Welcome to Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005   (RSS)
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...
Read More...
http://support.microsoft.com/kb/946608/en-us Nope, it's not SP3 Read More...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...