Browse by Tags

Egg pelted on Steve Ballmer, Microsoft CEO

Published 21 May 8 10:45 AM | SSQA.net

Microsoft CEO Steve Ballmer had to dive for cover behind a lectern during a visit to a Budapest University after a student decided to throw eggs at him. Well, will you take cover or not? The student managed to miss all the three and was heard shouting...

Filed under: microsoft, integration, coward, steve ballmer, act

Disruption to the internet due to damage in undersea

Published 31 January 8 5:34 AM | SSQA.net

Can you sustain a disruption to your Internet service? I cannot, when I have tried to call one of the mobile service provider got this message that "Severed cables disrupt internet"?? Eventually I found that Internet services have been disrupted...

Filed under: business continuity, sql server, integration, best practices, disaster recovery, internet, high avialability, indian

Real-time replication with SQL Server reporting, strategies and resolution to the problems?

Published 30 January 8 12:23 PM | SSQA.net

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that...

Filed under: sql server, microsoft, data, integration, security, download, replication, reporting services, magazine, windows it pro

You can pre-order the Kalen Delaney SQL Server Internals Course on DVD

Published 30 January 8 8:52 AM | SSQA.net

Great news to all SQL Server users! The DVD - Kalen Delaney SQL Server Internals course (part1) is almost ready and you can pre-order a copy right now! This is our first in what we hope to be will be an entire series of outstanding SQL Server training...

Filed under: sql server, integration, tuning, kalen delaney, tutorial, training, dvd, friends, lessons

Security best practices - personally & technically

Published 26 January 8 8:12 AM | SSQA.net

See this awesome post about how best you can adopt security and beaware about which is right and which is wrong Avoiding the bad guys - detecting potentially malicious advertising campaigns that is applicable on both personal security & techinical...

Filed under: business continuity, sql server, microsoft, blogs, integration, security

How to find which version of Analysis Services you are running?

Published 5 November 7 11:54 PM | SSQA.net

Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when connected to that SQL Server instance. What if to know same for the Analysis Services components, we don't have such an easy way to find out!...

Filed under: sql server, databases, microsoft, integration, ssis, ssas, version, Analysis Services

Configure Reporting Services on a DMZ environment?

Published 2 October 7 11:29 AM | SSQA.net

Few things you need to consider before letting the users use Reporting Services within a DMZ environment where the Servers are exposed to the INternet and to safeguard the servers from hackers. In this case you must be aware that SQL Server uses TCP port...

Filed under: sql server, integration, security, error log, reporting services, internet, dmz, browser

Your Disaster Recovery plan is only as good as the backup systems at its foundation?

Published 27 September 7 4:34 AM | SSQA.net

So how does your DR plan look like when it comes to reality? And you know the stats aren't pretty when it comes to business success rates after a disaster has hit. Make sure your data backup and DR plans are in check to avoid becoming a statistic...

Filed under: webcast, backup, integration, plan, disaster recovery, implementation, virtualization

How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions

Published 30 August 7 2:56 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to enable the SQL Server 2005 Integration...

Filed under: sql server, integration, ssis, services, kba, process, file, dump, exception

On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

Published 23 August 7 3:15 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, integration, ssis, ssms, services, plan, kba, maintenance

Simple steps to monitor Replication activities

Published 23 August 7 10:6 AM | SSQA.net

There are few simple steps involved to monitor the replication actvites, as usual with Replication Monitor is useful to monitor the overall health of a replication topology. Replication Monitor provides detailed information on the status and performance...

Filed under: sql server, integration, security, replication, monitor, troubleshoot, transactional

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). [ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found

Published 21 August 7 9:6 AM | SSQA.net

--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState...

Filed under: sql server, high availability, integration, security, ssms, error, surface, not found

Dust out few tasks to gain transactional replication performance in SQL 2005

Published 16 August 7 4:20 AM | SSQA.net

Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at...

Filed under: sql server, performance, integration, tuning, ssas, ssms, replication, transactional, hardware

Business Intelligence virtual labs

Published 1 June 7 4:51 AM | SSQA.net

Why not take advantage of testing your knowledge or make use of technology from Microsoft's Business Intelligence features. Microsoft has setup VirtualLabs for BI solutions in order to give in hand information on advantages & features. Excitingly...

Filed under: microsoft, integration, ssis, bi, ssas, business, intelligence, virtual, sharepoint, labs

What we have and what we need in BI?

Published 30 May 7 5:15 AM | SSQA.net

There is no doubt that from SQL Server 2005 version onwards Business Intelligence (BI) solutions has been better as compared to the previous versions. Still it is interested to know what is the Microsoft's strategy on the expansion of BI. Having the...

Filed under: sql server, integration, ssis, bi, ssas, ssrs, business, intelligence

Discover The Value of Business Process Platforms‎

Published 21 May 7 1:2 PM | SSQA.net

- Does your organization need to be more process driven? - Are you suffering from inflexible enterprise applications that limit your business agility? - Do you want to reuse your valuable information assets to create new applications? - Are you looking...

Filed under: webcast, integration, it, world

Beginner in SQL Server Business Intelligence

Published 16 May 7 1:30 PM | SqlServer-QA.net (SSQA)

You may be aware that SQL Server 2005 version provides many new features as compared to other Business Intelligence products with rich media presentations, not only on the presentation layer if you deep dive into the new features there many more to integrate...

Filed under: sql server, microsoft, integration, ssis, ssas, ssrs, business, reporting, intelligence

Reset cached plan - how to and what to?

Published 14 May 7 3:53 AM | SqlServer-QA.net (SSQA)

I don't believe you would need to reset the cache on a production server, it is not a best practice to perform in this case. Most of the times in development or test environments for the purpose of benchmarking you would need to reset the cache for...

Filed under: sql server, package, indexes, memory, integration, perfmance, plan, cache

Discover The New Releases with Microsoft and Industry Experts - IT Pro Connections

Published 13 May 7 11:25 AM | SqlServer-QA.net (SSQA)

19-20 June 2007 Post-Conference Workshops 21 June 2007 Amesterdam, The Netherlands Amsterdam RAI Explore these topics: *Windows PowerShell - Windows Vista *Windows Server "Longhorn" *Advanced Group Policy * SharePoint Portal Server 2007 *Microsoft...

Filed under: sql server, microsoft, integration, community, windows, it

OLAP Design best practices for Analysis Services

Published 13 May 7 2:57 AM | SqlServer-QA.net (SSQA)

We have got best practices articles on BPA , Security , IndexOptimization for SQL 2005 (non BI) and BP(suggested) for SSIS and I was searching for similar in OLAP - Business Intelligence on Analysis Services in SQL Server 2005. Here it is, a collection...

Filed under: databases, integration, data mining, business, olap, intelligence