Browse by Tags

• /3gb
• access
• analysis
• application
• authentication
• awe
• blocking
• computing
• dac
• dba
• disable
• error
• idera
• iis
• investigation
• login
• memory
• Microsoft
• mixed
• named pipes
• pae
• performance
• pool
• remote
• report builder
• reporting
• sa
• sac
• security
• server
• services
• sql express
• SQL Server
• ssas
• ssis
• SSMS
• ssrs
• tcp
• third party
• Tools
• video
• webcast
• websites
• windows
• x64

• Web Server: What’s New in IIS 7 for IT Pros

  So what's coming wth IIS7, the overview session will highlight the key points of interests for IT Pros in Internet Information Services version 7. IIS7 modularity increases security by allowing a reduced installation footprint and creation of specialized, Read More... Posted Tuesday, September 04, 2007 11:34 PM from SSQA.net | (Comments Off) Filed under: SQL Server, management, webcast, reporting, iis, application, pool, websites

• Reporting Services setup in Vista, simple resolution

  Recently on our Development platform we have deployed the Vista operating system to test an application against this installation. Part of the project is to deploy reports for the users using reporting services components, I was able to fix the issues Read More... Posted Wednesday, August 22, 2007 11:23 PM from SSQA.net | (Comments Off) Filed under: SQL Server, management, services, ssrs, iis, report builder

• Life of Simon, SQL Server DBA - hilarious video

  Also see Idera's hilarious new video! "Life of Simon, SQL Server DBA" http://www.youtube.com/ideradotcom View Video Format: ??? Duration: --:--...( read more ) Read More... Posted Friday, August 17, 2007 5:43 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Tools, management, idera, third party, video

• Disable SA account on a live SQL Server2005 instance, any drawbacks?

  Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more Read More... Posted Monday, August 13, 2007 7:03 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, Microsoft, management, windows, sa, login, disable, authentication, mixed

• Whats with 64 bit computing on SQL Server

  What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage Read More... Posted Sunday, August 05, 2007 12:41 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, SSMS, x64, management, computing, ssis, ssrs, ssas

• Dedicated Administrator Console (DAC) - saved an important day for a DBA

  Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to Read More... Posted Sunday, August 05, 2007 12:09 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, blocking, management, dac, sac, dba, analysis, investigation

• An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)

  Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could Read More... Posted Thursday, July 26, 2007 10:49 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, SSMS, tcp, sql express, error, access, named pipes, remote, management

• /3GB /PAE and AWE blurb what is it you hear within your environment?

  You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From Read More... Posted Thursday, July 26, 2007 12:06 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, Microsoft, management, awe, /3gb, pae, memory, server, windows