SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
Browse by Tags
All Tags
»
blogs
(
RSS
)
2005
2008
affected
application
attacks
authentication
backup
backups
begin
benchmarking
best practice
best practices
black-box
blocking
business continuity
cache
changes
checkpointl
clustered
clustering
compress
consistency
cpu
css
ctp
cu7
cumulative update
data
data capture
data compression
database
databases
dba
dbcc
dbcc checkdb
defrag
disk space
diskkeeper
dmf
dmv
downgrade
download
environment
excel
execution plan
external
FAQ
features
file
filestream
flush
format
forums
full
global
high availability
high cpu
i/o
indexes
installallation
kba
links
linq
management
microsoft
monitoring
msdn
mvp
new features
online
package
performance
product release
pss
query
resource governor
resources
schedule
schema
security
service pack
service pack2
services
servicing model
set
share
sharepoint
showcontig
simple
sites
slow query
sp3
sql server
sql server central
ssms
support
technet
testing
tsql
tvp
Cumulative Update 8 package for SQL Server 2005 Service Pack2
Published 16 July 8 4:50 AM |
SSQA.net
I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA...
SQL Injection attacks - don't forget to visit guidance information from Microsoft
Published 31 May 8 3:59 PM |
SSQA.net
One of the biggest threats in IT industry & Database world is unprecedented attacks aka most commonly termed as 'SQL injection'. There is no doubt that biggest database vendors, one of them as Microsoft so far providing recommendations regarding...
SQL Server CTP6 Error FILESTREAM feature is disabled - save your day!
Published 16 May 8 9:16 AM |
SSQA.net
I have had annoying moment when I'm trying to restore the sample database AdventureWorks on the test database server that consists SQL Server 2008 CTP6 and previous to this I have tried bits and pieces on FILESTREAM, but it seems CTP6 has changed...
SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?
Published 14 May 8 3:23 AM |
SSQA.net
I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...
Most popular blog posts since we started blogs here: sqlserver-qa.net
Published 12 May 8 4:30 PM |
SSQA.net
Post Subject Post Views Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>' 4,845 SQL Server 2005 & 2000 - Index optimization best practices 4,425 SQL Server 2005 - Ad hoc updates to system...
SQL Server databases - checkpoint, cache and I/O request - what you need to know?
Published 22 April 8 1:51 PM |
SSQA.net
Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...
SQL Server 2005: What percentage of changes happened within the database after the last successful backup?
Published 21 April 8 3:1 AM |
SSQA.net
No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures. Where the...
SQL Server 2005 Service Pack 3 - work started
Published 15 April 8 4:37 PM |
SSQA.net
Ok here is the hot news for SQL 2005 users!!! From the Are you ready for SP3 post here, it has been officially announced the SP3 for SQL Server 2005 will be available in CY2008 (calender year 2008) that means before 31st December 2008! More from this...
Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)
Published 15 April 8 3:58 PM |
SSQA.net
Here is another candidate of 7 within Cumulative Update service for SQL Server 2005 SP2. SQL Server Release Services team has announced (yesterday) that another instalment of Cumulative Update ( series here ) for SQL Server 2005 on Service Pack 2, it...
SQL Server 2008 TSQL enhancements - what I like?
Published 4 April 8 9:58 AM |
SSQA.net
Simple, short and crisp - I would like to say about TSQL enhancements within SQL Server 2008. You may already aware about what's new and how best you can take advantage within your code, most of the Developers would agree about IntelliSense functionality...
What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?
Published 26 March 8 3:1 AM |
SSQA.net
Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best...
Various blog links for sharepoint and office products
Published 19 March 8 7:32 AM |
SSQA.net
Though I'm an expert within SQL Server arena, sometimes I find it bit difficult when the sharepoint database are involved with an added flavour of performance issues within this farm. So in this regard recently I have been searching through the web...
SQL Server 2008 - What's new and what's coming up!
Published 17 March 8 3:11 AM |
SSQA.net
You may be aware that MVP s have the advantage of getting to know about the product information before it is let to the user community, that is the main advantage (I feel) to make the most of MVP award experience, Microsoft keeps MVPs informed of award...
SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?
Published 29 February 8 4:4 AM |
SSQA.net
Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the...
Few hours to go for Windows Server, Visual Studio and SQL Server 2008 launch, here is big deal on SQL release date!
Published 27 February 8 2:1 AM |
SSQA.net
I have been following Dan Jones's blog on " Launch_T-1 , Launch_T-3 & Launch_T-5 " series about SQL Server Launch in US (PST), as a Development Program Manager they have huge task ahead to complete and its not that easy to manage as...
How long DBCC CHECKDB process runs on SQL Server instance?
Published 14 February 8 5:43 AM |
SSQA.net
In order to keepup the database logical and physical integrity of all the objects, you must run the DBCC statement such as DBCC CHECKALLOC, DBCC CHECKTABLE and DBCC CHECKCATALOG. Overall you can do this with another statement DBCC CHECKDB that will avoid...
See how Resource Governor can help you 'in action' in managing SQL Server resources?
Published 8 February 8 2:11 AM |
SSQA.net
As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption. It will enable you to specify limits on the amount of...
SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?
Published 5 February 8 2:57 AM |
SSQA.net
SQL Server Performance Tuning, sounds familiar on a DBA perspective and though it sounds like an easy words but when you start analyzing the problem it is far deeper inside. When you refer to the web resources such as forums/newsgroups then a common question...
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...
SQL Server indexing - when to reorganize or rebuild?
Published 21 January 8 4:30 AM |
SSQA.net
Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts...
More Posts
Next page »
Search
Go
This Blog
Home
Contact
About
Tags
2005
2008
best practice
best practices
blogs
database
databases
dmv
download
error
high availability
indexes
kba
management
microsoft
performance
query
replication
reporting services
security
server
sql server
ssis
ssms
tsql
Community
Home
Blogs
Media
Groups
Archives
July 2008 (18)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
News
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go