Browse by Tags

SQL Server Open World - 2008, mark your diaries

Published 5 March 8 4:3 PM | SSQA.net

Wow, its almost one year for me to talk about SQL Server Open World! Last year I have given 2 presentations on Effective usage of Database Mirroring & Business Continuity mesaures & practices, blog posts here for a reference: http://sqlserver...

Filed under: sql server, microsoft, users, best practices, 2005, open world, conference, usergroup, agenda

SQL Server 2005 error while importing images using ASP page: “ASP Error ‘ASP 0104: 80004005′”

Published 26 February 8 2:33 AM | SSQA.net

One of the web application user complained about the above error during the upload process of images to SQL Server database! Most of the web applications have a lot of images used in it. Its not a best practice to store the Image/BLOB type data on the...

Filed under: sql server, ado.net, users, error, best practices, images, 80004005, upload, web page, asp page

SYSMON (PERFMON) counters that will help you to resolve SQL Server Integration Services issue

Published 31 January 8 3:45 AM | SSQA.net

As you are aware that SYSMON (PERFMON) provides very useful counters to analyze the system performance or to schedule a historical growth of your system usage. From the changes (upgrade) to the Operating System and SQL Server we now have new set of SQL...

Filed under: sql server, performance, ssis, users, best practices, sysmon, perflib, data flow, integration services

SQL Server Reporting Services - Do you cache popular reports for better performance?

Published 7 January 8 5:30 AM | SSQA.net

Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required...

Filed under: sql server, performance, security, search, update, users, report builder, BOL, best practices, reporting services, books online, caching, cache reports

Want to see Paul S Randal and Kimberley presentation extract?

Published 13 December 7 10:18 AM | SSQA.net

This will be an interesting news for all the SQL Server users and any conference attendees about Paul Randal & Kimberly, may be you or your friend might have asked one of them whether they are writing a book or have any extracts of their presentation...

Filed under: sql server, microsoft, sql queen, users, best practices, beginners, conference, paul