Browse by Tags

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

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

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

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

Taking advantages of Cryptographic features in SQL 2005 - security

Published 12 May 7 5:16 AM | SqlServer-QA.net (SSQA)

When I had a chance to know about encryption features in SQL Server I always go with books online as a first hand information, but there is more to ask about this feature in 2005 version: Have you ever thought about encryption in SQL Server, how to implement...

Filed under: sql server, integration, ssis, security, ssas, cache, entry

Data explosion and attributes in BI

Published 10 May 7 8:4 AM | SqlServer-QA.net (SSQA)

One of our Business Manager has asked can we handle the data explosion and BI requirement to handle billions of rows for their Sales pitch using SQL Server Analysis Servers. The obvious answer was 'yes' using the latest version of SQL Server and...

Filed under: sql server, analysis, integration, ssis, bi, ssas, attributes, business

Row versioning-based transaction isolation features in SQL 2005

Published 6 May 7 4:47 AM | SqlServer-QA.net (SSQA)

More information about nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications...

Filed under: sql server, performance, integration, isolation, blocking

Optimal Performance with SSIS lookups - SQL Team blog

Published 6 May 7 4:44 AM | SqlServer-QA.net (SSQA)

Most users see good performance from SSIS packages using out-of-the-box configurations and with little tuning. Sometimes, though, it is necessary to do tuning to get optimal performance. One of the most commonly used transformations is the Lookup transformation...

Filed under: sql server, msdn, integration, ssis, backupl

First-ever Worldwide Microsoft Business Intelligence Conference - Seattle

Published 3 May 7 5:40 AM | SqlServer-QA.net (SSQA)

First-ever Worldwide Microsoft Business Intelligence Conference - Seattle Gain insight from industry thought leaders, learn about the success of other Microsoft BI customers from your peers, discover best practices and gain valuable product knowledge...

Filed under: sql server, microsoft, integration, ssas