SQL 2008 Readiness

  On the Microsoft website you can now find e-learning resources, webcasts and virtual labs to learn for free about the new features in SQL Server 2008.   Don’t miss this great free chance to learn about it!   Links:   E-learning Collection 6187: What’s New in Microsoft SQL Server 2008 https://www.microsoftelearning.com/eLearning/offerDetail.aspx?offerPriceId=139087   SQL Server…


TechNet Webcast: SQL Server Performance Counter Guidance

  Monitoring performance on Microsoft SQL Server using perfmon can be difficult. There are many counters, and it is hard to determine what you should be looking for. Having a set list of counters and knowing what to look for can help SQL Server administrators determine whether performance issues exist, and how scalable their servers are….


Get a Second Shot for Free!

  On September 15th, Microsoft launched the Second Shot offer, which will allow a free retake on your next Microsoft IT Professional, Developer, or Microsoft Dynamics certification exam.   This offer will be available worldwide, from September 15, 2007, to January 31, 2008, to anyone who registers for Second Shot and fails their first attempt…


LINQ Virtual Lab!!!

This lab shows how to access relational data using LINQ to SQL. You will start by creating an object model for the Northwind database, and then use the object model to access the database using the new C# 3.0 query expressions and LINQ to SQL APIs. You will next create an object model from an…


SQL Server Support FAQ

On the Microsoft SQL Server Support Blog, it has been published a really interesting article concerting SQL Server Support. Working with Premier customers on a day-to-day basis, I know that some of these questions are very common, therefore I recommend to have a look to this post and hear directly from the SQL Server Support…


Download the SQL Server 2005 System Views Map

  You can now download from:   http://www.microsoft.com/downloads/details.aspx?FamilyID=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en   the Microsoft SQL Server 2005 System Views Map, which shows the key system views included in SQL Server 2005, and the relationships between them.   This map includes all the static metadata views and the new dynamic management views. It also shows the relationships between these…


Two SQL Server Events in Reading and London

  Two fantastic events not to miss: SQLBits conference on 6th Oct and Chris Webb BI / Data Mining session on 26th Sept.   Oct 6th sees the first SQL Community conference (SQLBits – http://www.SQLBits.com), 20 sessions in 4 tracks (Business Intelligence, DBA, Development and Katmai) on a Saturday in Reading at a cost of…


SQL Server Reporting Services & SQL Server Analysis Services Performance Troubleshooting

Some useful posts\white papers that you can’t miss if you’re looking on how to increase or troubleshoot performances of Analysis and Reporting server:   Analysis Services Processing Best Practices http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx#Profile   The recommendations in this white paper provide best practices for processing in Microsoft® SQL Server™ 2005 Analysis Services. These performance optimizations are based on real-world…


SQL Server Monitor Gadget for Windows Vista Sidebar

  Have you ever thought about monitoring your SQL Server installation from Windows Vista Sidebar?   Well, you can install and download it for free at http://blogs.conchango.com/jamiethomson/archive/2007/08/09/Announcing-SQL-Server-Monitor-Gadget-for-Windows-Vista-Sidebar.aspx. The gadget monitors a specified SQL Server database for various metrics and displays them on the Windows Vista Sidebar. It is provided for use by SQL Server DBAs that…


SQL 2005 Standard Reports, SQL 2005 Performance Dashboard Reports and… DMVStats

  SQL Server 2005 introduced dynamic management views (DMV) and functions (DMF), a mechanism to allow you to look at the internal workings of SQL Server using TSQL. They allow you an easy method for monitoring what SQL Server is doing and how it is performing. They replace the need to query the system tables…