MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

Browse by Tags

Blogs

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

Syndication

News

Blog Archive List

What Makes for a Good Blog?

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...

Published Thu, Apr 2 2009 4:55 by <P>SqlServer-QA.net</P>

Filed under: blogs, community, knowledge, communication, blogger
SQL Server - Publish your database along with data in a few simple steps?

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...

Published Tue, Jan 20 2009 2:44 by <P>SqlServer-Qa.net</P>

Filed under: sql server, blogs, deploy, developer, environment, best practice, beginners, wizard, database publishing
What Makes a DBA is a real Database Administrator Indeed?

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...

Published Wed, Dec 3 2008 1:41 by SqlServer-QA.net

Filed under: sql server, blogs, dba, roles, responsibilities
SQL Server 2000 and 2005 versions: set databae option Page_Verify Option to CheckSum, to be or not to be?

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...

Published Thu, Sep 4 2008 3:00 by SSQA.net

Filed under: sql server, blogs, best practices, pages, backups, checksum, dbcc checkdb, Corruption, page_verify
Installation gotchas and guidelines - SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1

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...

Published Mon, Sep 1 2008 3:02 by SSQA.net

Filed under: sql server, blogs, sql express, installation, developers, new features, isv, guidelines, gotches
SQL Server 2008 installation vows on Windows Server 2008

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...

Published Fri, Aug 8 2008 4:23 by SSQA.net

Filed under: sql server, blogs, community, windows, 2008, development, installation, firewall
Cumulative Update 8 package for SQL Server 2005 Service Pack2

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...

Published Wed, Jul 16 2008 4:50 by SSQA.net

Filed under: sql server, blogs, best practices, service pack2, 2005, cumulative update, cu7
SQL Injection attacks - don't forget to visit guidance information from Microsoft

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...

Published Sat, May 31 2008 15:59 by SSQA.net

Filed under: sql server, blogs, security, best practice, injection, authentication, attacks, reference
SQL Server CTP6 Error FILESTREAM feature is disabled - save your day!

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...

Published Fri, May 16 2008 9:16 by SSQA.net

Filed under: sql server, blogs, filestream
SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?

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...

Published Wed, May 14 2008 3:23 by SSQA.net

Filed under: sql server, performance, blogs, ssms, dba, dmf, best practice, new features, resource governor, policy based framework
Most popular blog posts since we started blogs here: sqlserver-qa.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...

Published Mon, May 12 2008 16:30 by SSQA.net

Filed under: sql server, blogs, popular
SQL Server databases - checkpoint, cache and I/O request - what you need to know?

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...

Published Tue, Apr 22 2008 13:51 by SSQA.net

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl
SQL Server 2005: What percentage of changes happened within the database after the last successful backup?

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...

Published Mon, Apr 21 2008 3:01 by SSQA.net

Filed under: sql server, data, backup, blogs, simple, 2005, full, recovery model, changes
SQL Server 2005 Service Pack 3 - work started

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...

Published Tue, Apr 15 2008 16:37 by SSQA.net

Filed under: sql server, blogs, download, 2005, cumulative update, sp3
Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)

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...

Published Tue, Apr 15 2008 15:58 by SSQA.net

Filed under: sql server, microsoft, blogs, download, kba, service pack, cumulative update, downgrade, cu7, affected, releases
SQL Server 2008 TSQL enhancements - what I like?

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...

Published Fri, Apr 4 2008 9:58 by SSQA.net

Filed under: sql server, performance, blogs, technet, merge, tsql, plan guide, new features, tvp, table-value
What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?

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...

Published Wed, Mar 26 2008 3:01 by SSQA.net

Filed under: sql server, performance, blogs, dbcc, disk space, object, file, best practice, monitoring, showcontig, defrag, diskkeeper
Various blog links for sharepoint and office products

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...

Published Wed, Mar 19 2008 7:32 by SSQA.net

Filed under: sql server, microsoft, blogs, sharepoint, resources, links
SQL Server 2008 - What's new and what's coming up!

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...

Published Mon, Mar 17 2008 3:11 by SSQA.net

Filed under: sql server, blogs, mvp, download, features, 2008, ctp, whatsnew, product release
SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?

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...

Published Fri, Feb 29 2008 4:04 by SSQA.net

Filed under: sql server, performance, blogs, environment, clustered, clustering, san, best practice, monitoring, benchmarking

1 2 3 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

zines:andrewbelon.com

Browse by Tags

Blogs

Syndication

Recent Posts

Tags

News

Archives

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

What Makes for a Good Blog?

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

What Makes a DBA is a real Database Administrator Indeed?

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

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

SQL Server 2008 installation vows on Windows Server 2008

Cumulative Update 8 package for SQL Server 2005 Service Pack2

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

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

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

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

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

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

SQL Server 2005 Service Pack 3 - work started

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

SQL Server 2008 TSQL enhancements - what I like?

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

Various blog links for sharepoint and office products

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

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