SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : blogs

What Makes for a Good Blog?

Thu, 02 Apr 2009 09:55:00 GMT

If you are a blogger then you will understand - What Makes for a Good Blog? and how to pull users to your community, a must for every blogger....( read more ) Read More......(read more)

SQL Server - Publish your database along with data in a few simple steps?

Tue, 20 Jan 2009 08:44:00 GMT

It comes very handy for every SQL Server user to publish the database that will help the needs of developer/user to deploy a local database from the Development machine to a hosting environment (remote machine) with few simple steps.You may be aware that...(read more)

What Makes a DBA is a real Database Administrator Indeed?

SqlServer-QA.net — Wed, 03 Dec 2008 07:41:00 GMT

What Makes a DBA is a real Database Administrator Indeed? This looks like a small question but it requires a big answer to complete the definition of what makes a real DBA! Another question arises for the DBAs that how many servers/databases you manage...(read more)

SQL Server 2000 and 2005 versions: set databae option Page_Verify Option to CheckSum, to be or not to be?

SSQA.net — Thu, 04 Sep 2008 08:00:00 GMT

Recently we had a discussion at work place about setting up the PAGE_VERIFY option to CHECKSUM for few databases on one of the SQL Server 2005 instance (dedicated) that is being used extensively by an application that has very limited maintenance window...(read more)

Installation gotchas and guidelines - SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1

SSQA.net — Mon, 01 Sep 2008 08:02:00 GMT

You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage. No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present...(read more)

SQL Server 2008 installation vows on Windows Server 2008

SSQA.net — Fri, 08 Aug 2008 09:23:00 GMT

After I knew about the SQL 2008 RTM release news I have blogged SQL2008RTM-official here and as usual I have attempted to download the setup media from Technet which took a while (3 hours) to download the file, due to the obvious reasons of MSDN/TEchnet...(read more)

Cumulative Update 8 package for SQL Server 2005 Service Pack2

SSQA.net — Wed, 16 Jul 2008 09:50:00 GMT

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...(read more)

SQL Injection attacks - don't forget to visit guidance information from Microsoft

SSQA.net — Sat, 31 May 2008 20:59:00 GMT

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...(read more)

SQL Server CTP6 Error FILESTREAM feature is disabled - save your day!

SSQA.net — Fri, 16 May 2008 14:16:00 GMT

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...(read more)

SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?

SSQA.net — Wed, 14 May 2008 08:23:00 GMT

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...(read more)

Most popular blog posts since we started blogs here: sqlserver-qa.net

SSQA.net — Mon, 12 May 2008 21:30:00 GMT

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...(read more)

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

SSQA.net — Tue, 22 Apr 2008 18:51:00 GMT

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...(read more)

SQL Server 2005: What percentage of changes happened within the database after the last successful backup?

SSQA.net — Mon, 21 Apr 2008 08:01:00 GMT

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...(read more)

SQL Server 2005 Service Pack 3 - work started

SSQA.net — Tue, 15 Apr 2008 21:37:00 GMT

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...(read more)

Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)

SSQA.net — Tue, 15 Apr 2008 20:58:00 GMT

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...(read more)

SQL Server 2008 TSQL enhancements - what I like?

SSQA.net — Fri, 04 Apr 2008 14:58:00 GMT

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...(read more)

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?

SSQA.net — Wed, 26 Mar 2008 08:01:00 GMT

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...(read more)

Various blog links for sharepoint and office products

SSQA.net — Wed, 19 Mar 2008 12:32:00 GMT

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...(read more)

SQL Server 2008 - What's new and what's coming up!

SSQA.net — Mon, 17 Mar 2008 08:11:00 GMT

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...(read more)

SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?

SSQA.net — Fri, 29 Feb 2008 10:04:00 GMT

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...(read more)