Browse by Tags

All Tags » users (RSS)
List of Technology User Groups within United Kingdom
Published 16 June 8 5:39 PM | SSQA.net
During a recent discussion within a local User Group I have been asked with the above question that where can I get list of User Group information for Microsoft Technologies. Please find the following list of Usergroups that are convened within geographical...
Filed under: , , , , , ,
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: , , , , , , , ,
Query Execution Plans security and new feature within SQL Server 2008 Management Studio
Published 4 March 8 2:4 AM | SSQA.net
If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by...
Filed under: , , , , , , , , , , ,
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 2008 February CTP - report a bug and get a chance to win XBOX!
Published 25 February 8 2:20 AM | SSQA.net
I feel this type of contest by Microsoft will make this (2008) SQL Server release as a best release as more and more users will be interested to j oin the SQL Server 2008 February CTP Bug Bash Contest that will gain chance to win XBOX. These are the OfficialRules...
Filed under: , , , , , , , ,
DevWeek 2008 - SQL Server DEVCON 2008 mark your diaries
Published 4 February 8 3:11 PM | SSQA.net
The 11th annual DevWeek conference, the UK's biggest dedicated event for software developers, features a choice of 16 all-day workshops and over 70 breakouts sessions on a wide range of topics, including .NET Framework 3.5, Silverlight, WCF, Visual...
Filed under: , , , , , , ,
SQL Server 2008 Change Data Capture - Do you really want to log all the data activities such as audit trails?
Published 1 February 8 9:50 AM | SSQA.net
In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log...
Filed under: , , , , , , , , , , ,
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 2005 Enterprise Edition - make data available while creating indexes on large tables!
Published 25 January 8 3:41 AM | SSQA.net
Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...
Filed under: , , , , , , , , , , , , ,
SQL Server 2008 express specifications, any difference from previous versions?
Published 14 January 8 3:18 AM | SSQA.net
Flood of questions fromthe users during a recent usergroup meeting. What will the specification for the SQL Server 2008 Express version be? What will be the differences between it and the 2005 version, not with MSDE? How about SQL Agent attachment to...
Filed under: , , , , , , , ,
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: , , , , , , , , , , , ,
Using feature of Creating Reports within SQL Server express 2008
Published 3 January 8 3:5 AM | SSQA.net
SQL Server Express team in Microsoft are asking users to register their opinion in developing a new report designer tool to include in SQL Server Express 2008! I should clarify that this feature will be included in SQL Express 2008 with Advances Services...
Filed under: , , , , , ,
SQL Server 2008 virtual training available during January
Published 2 January 8 3:7 AM | SSQA.net
Got this exciting news for the SQL Server users to get acquaintance in the next release which is 2008, Microsoft is offering several training opportunities before getting the RTM version to the public. This time the training opportunity is provided by...
Filed under: , , , , , , ,
SQL Server 2005: Deny Server-Level Dynamic Management Views to public group
Published 21 December 7 7:47 AM | SSQA.net
As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic...
Filed under: , , , , , , , , , ,
SQL Server is waiting for an internal operation to complete, message on SQL Server Management Studio
Published 17 December 7 2:49 AM | SSQA.net
Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message " Microsoft SQL Server Management Studio is waiting...
Filed under: , , , , , , , ,
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: , , , , , , ,
November 2007 update SQL Server 2008 Books Online CTP - update your local copies
Published 2 December 7 6:46 AM | SSQA.net
As the subject states you have to update (uninstall & install) the local copy of Books Online for SQL Server 2008 CTP that is released in November 2007. This BOL update consists all the changes from the previous CTPs and what's new with current...
Filed under: , , , , , , , ,
SQL Server 2005 ETL process - made simple and easy to learn with SSIS tutorials
Published 5 November 7 9:47 AM | SSQA.net
Still most of the users in SQL Server 2005 are afraid of using SSIS - SQL Server Integration Services for their ETL process and procedures. I would say the newbie users are in luck to obtain help easily on the web by referring to the blogs and forums...
Filed under: , , , , , , , , , ,
Note for SQLPASS 2007 attendees
Published 7 September 7 8:16 AM | SSQA.net
PASS2007 conference is just weeks away from now, I would like to share the Recommendations for PASS attendees posted by James Luetkehoelter . Above all I like and will follow: This extends to speakers: don't feel shy. Go up and ask someone a question...
Filed under: , , , , , ,
Getting Started with SQL Server 2008
Published 7 September 7 4:53 AM | SSQA.net
Recently I have had few emails asking about how to get hands-on in SQL Server 2008. As of now still July 2008 CTP is available to download as per this OtherBlogPost. Further as usual I would suggest the SQL 2008 'newbie' to review the books online...
Filed under: , , , , , ,
More Posts Next page »