March 2007

  • Solve SQL Server permissions and authentication problems

    For the past two weeks I've been trying to resolve a permissions problem, an authentication problem, or both. I've run out of ideas of where to look. Here is what I have: (1) SQL Server 2005 on a...30 Mar 2007

  • Restoring from msdb with only .mdf and .ldf files

    I am working on an issue with an undocumented application, and the info is/was on a SS7 database, that was not maintained properly.

    How can I restore jobs from msdb when all I have is either a backup

    ...30 Mar 2007

  • Improve query performance with SQL Server 2005 execution plans

    SQL Server 2005 allows you to feed a full execution plan to your query. Outsmart query optimizer with a faster query plan. One new tool – the plan guide – allows you to inject query hin...29 Mar 2007

  • Extended stored procedure to back up databases

    Does SQL Server 2005 (any edition) come with an extended stored procedure, allowing you to back up databases? If so, what is it called? I've looked all over the internet but only found third party ...26 Mar 2007

  • Create username and password for new SQL Server database

    I have created a SQL Server 2005 database and I plan to protect it with a username and password. I'm unclear as to how to do this. How can I make a security system for my new database with its secu...26 Mar 2007

  • Recover password in SQL Server 2000

    I have forgotten my password root in SQL Server 2000. Is there some way to recover it without having to install SQL Server again?26 Mar 2007

  • SQL Server 2005 performance tuning tools A-Z

    Make sure your SQL Server 2005 databases and applications are at optimal performance levels. Once you identify problems, you'll need to know the tools to fix them. This collection of tips from our ...26 Mar 2007

  • Back up stored procedure only

    Is it possible to back up the stored procedure only? If so, how?23 Mar 2007

  • Change tempdb from 'C' drive

    Is it possible to change tempdb from the 'C' drive, to any other drives?23 Mar 2007

  • Protect against SQL Injection by whitelisting

    OK, admittedly the best practice for guarding against SQL Injection attacks is to white-ist acceptable characters. However, given that knowledge is power, is there a comprehensive list of special c...23 Mar 2007

  • User password display in SQL Server

    I am trying to find out which password I have assigned to the user schema on my SQL Server 2000. I know that you can change the password, but I've had some grief with that application in the past. ...23 Mar 2007

  • Analysis Services 2005 delivers new features -- start to finish

    Microsoft Analysis Services 2005 is designed to improve business intelligence performance in SQL Server. Among its new features are the Unified Dimensional Model, Data Source View, new aggregation ...21 Mar 2007

  • How to use SQL Trace definition

    Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace,...19 Mar 2007

  • Tracing statements in SQL Server 2005

    Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace,...19 Mar 2007

  • Tracing statements in SQL Server 2000

    Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace,...19 Mar 2007

  • Script example for SQL Trace

    Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace,...19 Mar 2007

  • Targeting SQL Profiler to determine performance problems

    Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace,...19 Mar 2007

  • SQL Trace results in SQL Profiler

    Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace,...19 Mar 2007

  • Restoring database without .mdf file

    I have the .ldf file but don't have the .mdf file of my database. Can I restore my database from the existing .ldf file?16 Mar 2007

  • Tempdb changes in SQL Server 2005

    SQL Server 2005 has improved tempdb, and that means faster performance for your SQL Server operations. Serdar Yegulalp shares the tempdb advances taking place behind the scenes, including changes t...15 Mar 2007