Browse by Tags

SQLBits - Cubed: Don't miss the opportunity!

Published 26 August 8 7:46 AM | SSQA.net

Did you see the new logo of SQLBits: IN continuation to the earlier SQLBits-Cubed_Notification post here, now we got the update about final agenda that is fixed for September 13th 2008. For more information refer to MainAgenda page on SQLBits website...

Filed under: sql server, community, users, sqlbits, conference, usergroup, education, cubed, learn

SQL Server Heroes UNITE - PASS community summit 2008

Published 1 August 8 12:41 PM | SSQA.net

HeroesHappenHere is finished and now PASS organisation comes up with new chant that 'SQL Server Heroes UNITE' for upcoming community summit 2008 in Seattle, US between November 18-21 2008. No doubt that PASS Community conferences in the past and...

Filed under: sql server, pass, community, users, summit, conference, us, professionals

SQL Server get current executing statements - SP_WHO or SP_WHO2 or sys.dm_exec_requests

Published 30 July 8 11:43 AM | SSQA.net

As a SQL Server user or DBAs using SP_WHO or undocumented stored procedure SP_WHO2 is a common occurrence. For this there are times when you will need to run sp_who on your SQL Server to figure out who is on and what are they doing. The output is quite...

Filed under: sql server, dmv, users, sp_who, statement, system catalog

Get ready for SQL Server 2008 RTM release!

Published 14 July 8 9:56 AM | SSQA.net

Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 is set to RTM'd during the month of August 2008, as per Bob...

Filed under: sql server, developer, users, 2008, 2005, visual studio, launch, windows server, rtm, itpro, rc0

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, microsoft, users, scotland, usergroups, meetings, united kingdom

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

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, performance, ssms, query, users, execution plan, monitoring, new features, .xml, plan cache, document, .sqlplan

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

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: sql server, microsoft, users, 2008, bug, testing, win, report, xbox

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, dba, developer, users, conference, devcon, architects, devweek

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: sql server, users, ctp, environment, cdc, best practice, testing, triggers, new features, audit trial, change data capture, stored procedures

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 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, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation

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, download, community, users, edition, 2008, 2005, compatibility, express

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

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, users, 2008, ctp, bids, reporting services, newfeatures

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, users, 2008, virtual, seminar, best practice, session, training

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, package, performance, security, dmv, users, view, best practice, public, monitoring, server state

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: sql server, performance, microsoft, users, sql express, service pack2, management studio, slow, delay

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