A full walk through Policy Based Management in SQL Server 2008: the policy framework, facets and conditions, then creating, evaluating and fixing policies.
SQLAuthority News – Effect of Oracle acquiring MySQL – A Delayed Analysis
What does Oracle acquiring MySQL through its Sun Microsystems deal mean for the 12 million small databases that run on free, open-source MySQL?
SQLAuthority News – Proposed eGov Standards Policy – Benefit for All or Only A Chosen Few
Does India’s proposed eGov Standards Policy help everyone or only a chosen few? My thoughts on why a single mandated standard can shut out Indian ISVs.
SQL SERVER – Introduction to Cloud Computing
An introduction to cloud computing for database people: what it means, how it differs from grid and utility computing, and its key characteristics.
SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers
It’s my birthday, so I am taking a break from tech posts to spend time with family and to thank my top 7 commenters who help readers on this blog.
SQL SERVER – Server Type and File Extention
Double click a .sql file and SSMS opens. Here is the file extension used by each SQL Server type, from .sql and .sqlce to .mdx for Analysis Services.
SQL SERVER – Logical Query Processing Phases – Order of Statement Execution
Logical Query Processing is the order in which SQL Server handles each clause of a statement, with FROM and ON first and SELECT near the end. Here are the phases.