What is Application and Multi-server Management?Microsoft’s investments in Application and Multi-server Management will help organizations manage database environments more efficiently at scale with visibility into resource utilization for consolidation and improved efficiencies across the application lifecycle. These improvements will offer DBAs increased visibility and control, resource optimization, and efficiencies, ultimately leading to a healthier, more [...]
What does StreamInsight mean for customers?While OLTP databases have matured and are capable of processing thousands of transactions per second; they are not optimized for processing continuous high volume, low latency streams of data. Microsoft’s innovative StreamInsight™ platform allows customers to use their own proprietary algorithms to build custom real-time applications, ISVs to build industry [...]
Because tables model real life objects, the process of designing and building a table must start on the business side, gathering the rules and real life use cases. Jennifer McCowan, Midnight DBA Guru, gives us the first 3 of 6 essential steps to creating tables in SQL.
Jennifer McCown, MidnightDBA Guru, shares with us 3 important guidelines to keep in mind when creating SQL Server tables.
In SQL Server 2008 there are 3 recovery models you can use: simple, bulk-logged, and full. These recovery models really just define how log management behaves so you can have what you need to perform your desired backups.
Microsoft® SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 with new technologies and capabilities specifically designed to make actionable intelligence accessible to all employees in the enterprise. It delivers a comprehensive data platform that provides built-in security, availability, and scale coupled with robust business intelligence offerings—helping enable high service levels [...]
Microsoft SQL MVP Sean McCown outlines the steps to follow in order to uncover the queries causing SQL database slowness.
Designing a backup strategy in SQL is fairly straightforward, but it can get complicated when you’ve got a lot of moving pieces in your scenario. Sean McCown, Microsoft SQL MVP, takes the readers through the "best" practices to follow.
Microsoft SQL MVP, Sean McCown, takes us through the pros and cons of using Windows authentication vs SQL and Windows Authentication when installing an SQL server 2008.
Important insight on managing large numbers of files in SQL from Microsoft SQL MVP, Sean McCown.
Because users don't want to manually backup their SQL databases every day, Sean McCown Microsoft SQL MVP, provides us with several ways to create a backup job in SQL Server 2008.