Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 20 2009
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Dec 3 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Sep 4 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 1 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Aug 8 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jul 16 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sat, May 31 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, May 16 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, May 14 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, May 12 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 22 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Apr 21 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 15 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 15 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Apr 4 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 26 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 19 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Mar 17 2008
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Feb 29 2008
Filed under: Filed under: sql server, performance, blogs, environment, clustered, clustering, san, best practice, monitoring, benchmarking
Few hours to go for Windows Server, Visual Studio and SQL Server 2008 launch, here is big deal on SQL release date!

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Feb 27 2008
Filed under: Filed under: sql server, msdn, microsoft, blogs, 2008, 2005, visual studio, launch, windows server, product release

Page 1 of 3 (41 items) 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

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.