SSQA.net

Knowledge Sharing Network
Welcome to SSQA.net Sign in | Join | Help

Blogs on this site

SQL Server Tools

Blog Author(s) Last Post Posts Articles Comments Trackbacks
SQL Server Storage Engine & Tools (SSQA.net)
SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
SQLMaster  Cumulative Update 9 for SQL Server 2005 Service Pack 2 - another update package in line  311  14  479 
SQL Server Knowledge Base articles (SSQA.net)
Microsoft support engineers regularly document the solutions to problems that customers call in with, they are Knowledge Base articles or we call them as KBA.
SQLMaster  SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages  261  384 
SQL Server Replication (SSQA.net)
Another methodology to distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
SQLMaster  SQL Server Replication - resolving too many snapshots issues?  15  33 

High Availability & Business Continuity

Blog Author(s) Last Post Posts Articles Comments Trackbacks
Business Continuity (SSQA.net)
Business continuity & Contingency planning - essential and unavoidable tasks.
SQLMaster  Internet Database based Services find a suitable service provider  82  35 
High Availability (SSQA.net)
Importance of Service Delivery within your environment, know more here.
SQLMaster  Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy - Tech-ed Online Panel video available to view  29  28 

Reference

Blog Author(s) Last Post Posts Articles Comments Trackbacks
Sharepoint Server and SQL Server connectivity (SSQA.net)
Content Management, Paperless office and share your information in an Enterprise. Tips and Tricks in using Sharepoint along with your SQL Server database.
SQLMaster & Akthar  IDERA Admin Toolset tip: Monitor growth of sites and libraries  20  42 
Other Blogs we recommend (SSQA.net)
A seperate section for a recommendation of blogs that I follow regularly within the SQL Server community.
SQLMaster & Respective Blog owners  Did You Know: My Fall Travel Plans  449 

Like, Whats Up!

Blog Author(s) Last Post Posts Articles Comments Trackbacks
Events, Webcasts, Conferences and many more in cyber world (SSQA.net)
Service interactive happenings and offers outside the SQL world with a schedule in future, now and past.
SQLMaster  SQLTeach/DevTeach Montreal registration open -- early bird discounts  149  159 
External Links & References (SSQA.net)
All the useful links and resources readily available on the web, such as third party tools.
SQLMaster  Technical Rollup email pertaining to SQL Server, documents & guidelines  140  144 

Security, Performance & Tuning

Blog Author(s) Last Post Posts Articles Comments Trackbacks
SQL Server Security, Performance & Tuning (SSQA.net)
SQL Server - Optimization, Index Tuning, problem with slow queries, data normalization and know here how to attain the performance with the available tips & features. Also considering the importance of Security that can help to achieve performance with peace of mind.
SQLMaster  Lock Down SQL Server 2005  157  314 
All about Business Intelligence (SSQA.net)
SQL Server 2005 provides many new and enhanced business intelligence features designed to give you a competitive advantage, still performance is most required ingredient.
SQLMaster & Dinesh Asanka  SQL Server Business Intelligence - handling data mining and mission critical applications  45  67 
SQL Server Transact-SQL (SSQA.net)
Transact-SQL (TSQL) features control-of-flow language, local variables with various support functions for string processing, date processing, mathematics, etc. Here you will find the TSQL tips, tweaks to improve the code to attain the performance.
SQLMaster & Madhivanan  Fun with GO  110  209 
All about SQL Server X64 Edition (SSQA.net)
SQL Server 64 bit editions - higher levels of scalability with 64-bit components that are optimized to run x64- or Itanium-based servers on 64-bit Operating System.
SQLMaster  Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process  11  24 

SQL Server 2008

Blog Author(s) Last Post Posts Articles Comments Trackbacks
SQL Server 2008 (SSQA.net)
Trusted, Productive and Intelligent enterprise data platform.
SQLMaster  Installation gotchas and guidelines - SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1   107  10  260 
Powered by Community Server (Commercial Edition), by Telligent Systems