For more information about the site, see the Site Index

• Sizing up SQL Azure limitations: There are workarounds
• Third-party tool for SQL Server outshines IntelliSense in SSMS
• Bedeviled by SQL Server lock escalation? Trace flags can help
• Top 5 buying criteria for packaged SQL Server BI systems
• Virtualizing SQL Server: Myth or reality?
• On the server level with SQL Server dynamic management views
• Gaining insight with SQL Server dynamic management views, Part 2
• Are SQL Server BI systems compatible with virtualization?
• Finding your way around SQL Server data preservation
• Gain insight with SQL Server dynamic management views
• SQL Server business intelligence performance baked in for most SMBs
• Firing up AlwaysOn for high availability in SQL Server Denali
• Putting SQL Server catalog views to work
• Three tips on choosing hardware for your SQL Server BI system
• Zooming in on SQL Azure data synchronization
• Three SQL Server hardware upgrades to enliven performance
• Tuning SQL Server table indexes: Adjusting the fill factor
• Demystifying the Microsoft Distributed Transaction Coordinator
• SQL Azure migration: To the cloud and back again
• Using bcp utility for data moving, sqldiag for troubleshooting
• Command-line utilities for SQL Server database tuning, comparing tables
• SQL Server command-line utilities: sqlcmd
• Warned about table changes in SSMS? Here’s a workaround
• Reading a SQL Server query execution plan
• Three things every BI implementation must have
• Get all the angles on SQL Server database mirroring
• For better SQL Server security, get Extended Protection
• SQL Azure database recommendations and best practices
• Managing multiple SQL Servers the easy way
• Working with SQL Server configuration functions
• Perk up your BI planning with write-back
• SQL Server merge replication using IIS
• Where to look next for BI applications? Try the cloud
• SQL Azure development, inside and out
• Q&A: Getting the lowdown on Master Data Services for SQL Server
• Top 5 things you must do to SQL Server
• Are we there yet? The slow road to SQL Azure
• Do you need to harden SQL Server 2008 R2?
• BI for SMBs: What's good for the big boys might be bad for you
• Uncovering database file information with T-SQL metadata functions
• Inspecting property settings with T-SQL metadata functions
• Exploring T-SQL metadata functions in SQL Server 2008
• Using file_guid as a unique identifier for SQL Server instances
• Top seven things you don’t know about SQL Server 2008 R2
• Top five things you’re doing wrong with SQL Server
• Getting started with Microsoft SQL Azure Database
• SQL Server index tuning for peak performance
• An introductory look at T-SQL system functions
• Digging deeper with T-SQL system functions and language tools
• Three strategies for launching business intelligence in your company
• Sysprep utility speeds up SQL Server 2008 R2 deployments
• The basics of SMO scripting for database objects
• Dissecting the SELECT query syntax in T-SQL
• Q&A: SQL Server business intelligence meets the cloud
• SQL Server tool alleviates documentation headaches
• Weighing the performance impact of SQL Server indexes
• Combining T-SQL subqueries with operators in SQL Server
• T-SQL subquery basics: When and how to apply them in SQL Server
• Master data management without a SQL Server 2008 R2 upgrade
• Programming SMO applications for improved management, automation
• Is an Excel pivot table really business intelligence (BI)?
• Free sqlmap tool helps ward off SQL injection attacks
• Getting ‘trigonometric’ with T-SQL mathematical functions
• Applying algebraic and numeric functions in SQL Server 2008
• Scalability options for really big SQL Server databases
• Walking through the database auditing process for SQL Server 2008 R2
• Reporting Services 2008 R2 eases SQL Server report building
• SQL Server tools take the time out of database searches
• Weighing visual output options for SQL Server business intelligence
• Seizing stats and grouped data with T-SQL aggregate functions
• The nuts and bolts of T-SQL aggregate functions in SQL Server 2008
• Pros and cons of the DACPAC with SQL Server 2008 R2
• Supporting packaged SQL Server apps: What you can get away with
• Microsoft brings PHP integration to SQL Server Reporting Services
• Shining the light on PowerPivot for SQL Server 2008 R2
• Where business intelligence project planning goes wrong
• T-SQL string functions: The ins and outs for SQL Server
• Using T-SQL string functions to convert and report on data
• Top hacker tricks to exploit SQL Server systems
• Loading data into a Master Data Services repository
• Quick tips for monitoring SQL Server performance issues
• Top tips for SQL Server database failover success
• Why BI? Business intelligence concepts defined
• Getting started with Master Data Services in SQL Server 2008 R2
• Data collection the automated way in SQL Server 2008
• Open source tool simplifies database synchronization for SQL Server
• When (and why) to move SQL Server to the cloud
• Enter the matrix with Report Builder 3.0
• Creating matrix reports with Report Builder 3.0
• Matrix configuration techniques for Report Builder 3.0
• Native string manipulation functions for SQL Server
• Getting set up for multi-server management with SQL Server 2008 R2
• SQL injection tools for automated testing
• Log shipping: Four tips to maintain RTO and RPO with SQL Server
• Adding a polygon layer to a map in Report Builder 3.0
• Finalizing maps with Report Builder 3.0
• Geospatial mapping made simple with Microsoft SQL Server
• The ultimate SQL Server security faux pas: Overlooked systems
• SQL Profiler: A network trace for SQL Server
• Tweet-SQL: Interacting with Twitter through SQL Server



• More