|
 |
| Recent SQL Server Blog Posts |
|
|
|  |
|  |
By colindolly on 12/28/2009 2:43 PM
Stellar Phoenix SQL Recovery is an efficient SQL Repair tool to surpass all SQL database corruption scenarios. The software incorporates advanced scanning methods to repair database created in SQL Server 2008, 2005, and 2000. It is designed for Windows 7, Vista, XP, 2003, 2000 and NT. Read More » | By colindolly on 12/23/2009 2:35 PM
Stellar Phoenix SQL Recovery is a powerful utility that repairs logically corrupted database components and restores the repaired components on user-specified destination. Designed for Windows 7, Vista, XP, 2003, 2000 and NT, the SQL Repair software supports SQL Server 2008, 2005, and 2000. Read More » | By colindolly on 12/21/2009 4:56 PM
Stellar Phoenix SQL Recovery is a powerful tool that repairs corrupt databases and restores them on the user-specified location. Compatible with SQL Server 2008, 2005, and 2000, the software repairs almost all database objects including tables, views, rules, etc. Read More » | By colindolly on 12/19/2009 3:20 PM
Stellar Phoenix SQL Recovery is a powerful application to repair corrupt database objects (tables, views, rules, etc.) created in SQL Server 2008, 2005, and 2000. Compatible with Windows 7, Vista, XP, 2003, 2000 and NT operating systems, the SQL Repair software provides risk-free repair of database objects, without making any modifications in original database file. Read More » | By colindolly on 12/16/2009 2:46 PM
Stellar Phoenix SQL Recovery provides an answer to all SQL database corruption queries. The software can easily repair SQL Server 2008, 2005, and 2000 databases and restore them on default or new location. Compatible with Windows 7, Vista, XP, 2003, 2000 and NT operating systems, the SQL Repair tools is completely non-destructive in nature. Read More » | By Davidpoul on 12/15/2009 2:20 AM
Microsoft SQL Server system is a full-fledged relational database management system (RDBMS) that offers the user an exclusive variety of a number of administrative tools to ease the burdens of database development, maintenance and adminnistration. Sometime while working with SQL Server you may receive the following error messages: Read More » | By colindolly on 12/14/2009 4:28 PM
Stellar Phoenix SQL Recovery is a professional SQL Repair software used by both technical and non-technical users. The software repairs database created in SQL Server 2008, 2005, and 2000 and recovers all database objects, such as, tables, stored procedures, views, etc. Read More » | By colindolly on 10/23/2009 11:53 AM
Stellar Phoenix SQL Recovery is finest SQL Repair application that repairs SQL database created in created in SQL Server 2008, 2005, and 2000 after almost all database corruption scenarios. The non-destructive repair utility recovers MS SQL database objects, such as, views, triggers, stored procedures, and more. The application supports Windows Vista, XP, 2003, 2000, and NT operating systems. Read More » | By colindolly on 9/29/2009 3:24 PM
Microsoft SQL Server is an advanced RDBMS (Relational Database Management System), which include a service called SQLServerAgent for managerial operations of MS SQL Server, known as Jobs. Read More » | By colindolly on 9/23/2009 5:04 PM
SQL Recovery is the most advanced and powerful software to successfully recover damaged SQL Server database. It works well with Microsoft SQL Server 2008, 2005 and 2000. This software is compatible with Microsoft Windows Vista, 2003, XP, 2000 and NT. Read More » | By colindolly on 9/19/2009 5:06 PM
SQL Recovery is the most excellent solution for all MDF corruption situations. It works well with Microsoft SQL Server 2008, 2005 and 2000. This softwre is compatible with Microsoft Windows Vista, 2003, XP, 2000 and NT. Read More » | By colindolly on 9/18/2009 3:30 PM
Microsoft SQL Server is the most advanced and widely used RDBMS (Relations Database Management System). It stores all of your critical data in MDF (Master Database File), in the form of tables. But in case if the SQL Server gets damaged, it does not allow you to properly mount the database and access data from it. Read More » | By colindolly on 9/17/2009 12:52 PM
SQL Recovery is the best ever made and the most advanced tool to ensure absolute recovery of all MDF file objects. It works well with MS SQL Server 2008, 2005 and 2000. This softwre is compatible with Microsoft Windows Vista, 2003, XP, 2000 and NT. Read More » | By colindolly on 9/15/2009 12:34 PM
Index is the most critical component of a relational database. It ensures easy, quick and managed accessing of data from the database. In Microsoft SQL Server, a non-clustered index is an index that stores both logical and physical order of indexes and tables. But in case of corruption if the logical order of index doesn't match the physical order or rows on hard drive and thus you can not access data from the database. Read More » | By colindolly on 9/14/2009 3:01 PM
Stellar Phoenix SQL Recovery is the most advanced and effective tool to repair and restore SQL Server database in all cases of corruption. It repairs MDF files of SQL Server 2008, 2005 and 2000. This software is compatible with Microsoft Windows Vista, 2003, XP, 2000 and NT. Read More » | By jahalva on Monday, August 17, 2009 4:05 PM
Hello PASS Summit Unite 2009 is the biggest, intensive, and collaborative Microsoft SQL Server and BI conference in the world. This year’s PASS Summit conference takes place November 2 – 5th in Seattle, WA. Microsoft will be present in full force with hundreds of team members on hand to meet with customers. Conference highlights include: · 168 top-quality sessions scheduled across 5 SQL Server and BI tracks, plus 15 pre/post-conference seminars and workshops · Keynotes by senior Microsoft executives Bob Muglia, Ted Kummert, Tom Casey, and David DeWitt · Direct access to Microsoft engineering and support teams and MVPs for immediate answers to your mission-critical questions · A great lineup of top experts, authors, presenters, thought-leaders, and community influencers, including Kalen Delaney, Paul Randal, Kimberly Tripp, Itzik Ben-Gan, Kevin Kline, Greg Low, Louis Davidson, Steve Jones, Andy Warren, Brian Knight... and the list goes on and on The conference will be in Seattle, WA, Nov. 2-5. See the conference agenda for sessions and speakers and view attendee testimonials to learn more about the value of attending PASS Summit. Visit the conference website for full details Read More » | By Raoul_illyes on 8/3/2009 12:45 PM
SQLSTAT2005 is a open source performance data warehouse tool for SQL Server 2005 much like the data collector tool in SQL Server 2008. It supports all versions of SQL Server 2005 including the Express version and uses DMV and DMF data Read More » | By Richard Rickard on 7/21/2009 2:33 PM
The worst thing about going back to college is the classes that have nothing to do with your degree, but you have to take them anyway. Read More » | By Cindy Gross on Thursday, March 12, 2009 9:25:01 PM
Thanks to Lara Rubbelke for teaching me about PBM! See the attached PBM.zip for a full slide deck and demos of the "on change" functionality. Install • Get updated policies from the feature pack item “Microsoft SQL Server 2008 Policies” • In Management Studio expand your instance then Management.Policy Management.Policies.Import Policy • Import from C:\Program Files\Microsoft SQL Server\100\Tools\Policies\DatabaseEngine\1033 Policy-Based Management • Combines prior features such as − Agent for schedules and alerts − DDL triggers as event handlers − Best Practices Analyzer − Surface Area Configuration Tool PBM Components • Facets − Groupings of properties that encapsulate a target such as Surface Area Configuration or Table • Conditions − States such as true/false or on/off for given settings − Almost anything that can be verified programmatically • Policies − Verification of a condition and the required state for a defined target(s) PBM - Facets • Contains properties that can have conditions set • Example: Table facet has properties such as Name, HasClusteredIndex, IsPartitioned, CreateDate, etc. • Cannot be modified or added • Are not executed directly PBM - Conditions • Are set for facet properties • Can be tested programmatically • Can be limited to targets such as certain databases or objects • Example: For the Table facet you can set @HasClusteredIndex = True AND @Owner = dbo PBM - Policies • Applies a check condition against targets such as “every table” • Can be on demand or scheduled − Scheduling is through SQL Agent jobs − On demand has the option of "apply" for some conditions to correct exceptions • Can be exported then imported to other servers • Or execute against a group of servers in SSMS PBM – "On Change " Enforcement • Not available for all conditions • On Change – Log Only − Allows a change away from the policy to occur but logs the change to SQL Server error log and Windows application log • On Change – Prevent − Prevents changes from occurring if they are against policy − Enforced through DDL triggers Permissions • To set/change policies, add users to role PolicyAdministratorRole in msdb – note that this an attack vector as a possible elevation of privilege • On Schedule evaluation mode uses SQL Server agent jobs owned by SA References • List of evaluation modes for each facet • Evaluating Policies On Demand Through PowerShell • Administering Servers by Using Policy-Based Management • Take Control of the Enterprise: Effective Solutions for Governing your Environment With Policy Based Management Read More » | By Cindy Gross on Monday, March 09, 2009 12:15:56 AM
Want to provide feedback on any Microsoft product? Want access to the latest CTPs (sometimes known as betas)? Create an account on http://connect.microsoft.com/ and you can file bugs or wishes and vote on what other people have submitted. You can also find CTPs and evaluation editions of various products. For example, to get the CTP of SQL Server 2008 SP1 go to http://connect.microsoft.com/SQLServer. From the same page you can access the SQL Server feedback section as well as the SQL Server discussion forums. Please vote on your favorite bugs/requests/wishes as this increases the chance they will change for a future version of SQL Server. Read More » |
|
|  |
| | |
|