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 Memory Cache - take help of DMV for optimal query plans

SQL Server query optimization and keepup of performance is not a black-art, it can be achieved in a fair manner if you treat your queries with plans with a are reused or recompiled plans that can help you design well-performing applications. There are...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Feb 24 2010
Filed under: Filed under: sql server, memory, technet, security, query, cache, BOL, best practice, configuration, plan guide, benchmarking
May 2009 Monthly Technical Rollup about Business Intelligence technologies - Biztalk

Here is the email extract that we get as a part of MVP program from the Microsoft, similar information is already available from relevant Technet/MSDN blogs. This consists the news extracts and downloads information with regard to Biztalk server technologies...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 5 2009
Filed under: Filed under: sql server, backup, technet, download, technical, biztalk, rollup, casestudies
IT PRO specific resources, Best bets with career and learning leads - make most out of it

As a part of Microsoft MVP programme every now and then set of email communication will be received from MVP leads (thanks to Akim & Vicki). Most of them are already available/posted on MSDN & Technet blogs by MSFT professionals and for few of...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Apr 15 2009
Filed under: Filed under: sql server, msdn, webcast, microsoft, technet, virtual labs, knowledge, it pro, professionals, technet radio
SQL Server - Service Broker and Messaging, take care of MSDB sizes

You may notice that from SQL Server 2005 version onwards MSDB system database has got more importance than any other system database, I believe. It is a fact that if any problem ocurrs on the system databases such as MODEL or TEMPDB or MSDB the SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Feb 2 2009
Filed under: Filed under: sql server, technet, dba, best practices, service broker, msdb, messaging, beginner, system databases, free space
Register now for TechNet Event: Self Service Business Intelligence

Here is the chance for SQL Server users in Edinburgh to know about Business Intelligence from Microsoft's IT Pro Evangelist - Andrew Fryer , many more on tools too. TechNet Event: Self Service Business Intelligence Event Overview Overview: The challenge...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jan 12 2009
Filed under: Filed under: sql server, technet, solution, events, business intelligence, itpro, office tools
Technet events & webcasts - SQL Server related

High Performance Computing (HPC) Traditional computing takes the form of an application running on a server or workstation. All of the commands for the application are processed on the local system. High Performance Computing (HPC) instead uses the processing...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jan 9 2009
Filed under: Filed under: sql server, performance, technet, events, change data capture, troubleshooting, webcasts
Upcoming and On-demand Technet events for UK based IT users

Here is the long list of events that are lined up for UK based IT users by technet and you can register to attend free UK technical events SPOTLIGHT EVENT Oct 01 2008 WEBCAST: TechNet Presents: MCS Talks Enterprise Architecture session 5 – Identity and...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Sep 26 2008
Filed under: Filed under: sql server, technet, events, conference, uk, roadshow
MSDN & Technet webcast for SQL Server 2008 and SQL Server Compact 3.5 versions

TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300) Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 3 2008
Filed under: Filed under: sql server, msdn, webcast, microsoft, technet, community, version, best practices, comact
Technical Rollup email pertaining to SQL Server, documents & guidelines

Here is the list of information which is a Technical Rollup email we receive from TRM team. The list is ongoing and I have outlined the important ones that I feel and fits for 'generic' SQL Server environment. Make sure to review, download, test...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 3 2008
Filed under: Filed under: sql server, technet, documentation, best practices, technical
SQL Server Technical Rollup July 2008 - Important & Interested links for you

As you may be aware all the Technical information roll-up on MSDN & Technet is sent out in email format, in this regard I wanted to share the important and interested links for you on SQL Server arena. Downloads Source Code Analyzer for SQL Injection...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 7 2008
Filed under: Filed under: sql server, msdn, technet, download, best practices, information, beginners in sql serever
SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Apr 28 2008
Filed under: Filed under: sql server, performance, microsoft, technet, i/o, article, disk, best practices, monitoring, deployment, layout
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
Webcast: 24 Hours of SQL Server 2008: Ensuring Your Data Is Secure with a Trusted Platform

Another part of Technet webcast series on SQL Server 2008. In this part a focus on IT professionals and the SQL Server 2008 the Trusted Platform. In the first part of the series we spent time looking at how Contoso was using SQL Server 2008 as a productivity...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Mar 28 2008
Filed under: Filed under: business continuity, sql server, high availability, technet, security, 2008, trusted platform, data loss, data platform
SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions

You may be aware that Database Mirroring is an important High Availability [HA] option available within SQL Server 2005 version. Having this HA option within your Sharepoint farm where the databases are associated to failover, then you must note few issues...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Mar 18 2008
Filed under: Filed under: sql server, high availability, technet, database, best practices, sharepoint, database mirroring, failover, links
Microsoft Empower Program - good deal for ISVs

Microsoft has rolled out new program called - Empower Program that will enable the ISVs to receive software, support and additional resources designed to help you lower your development costs, test your software and speed your solution's time-to-market...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Feb 28 2008
Filed under: Filed under: sql server, msdn, microsoft, technet, community, sharepoint, beginners in sql serever, benefits, isv, subscription, visio, office, program
BI Virtual labs on MSDN - specific to data mining and top 10 classed in Tech-ed.

As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Feb 26 2008
Filed under: Filed under: sql server, performance, microsoft, technet, data mining, version, virtual, labs, 2005, loading
SQL Server 2008 February CTP, is availble to download now!

Continuing from this SQL2008CTP blog post it seems there is a confusion on the SQL 2008 CTP downloads page The technet link 851664 refers that Evaluate Microsoft SQL Server 2008 today page was p ublished: November 12, 2007 and further after registering...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Feb 20 2008
Filed under: Filed under: sql server, microsoft, technet, download, 2008, ctp, share, new features
SQL Server OLAP - back to basics for Cube access from front-end application?

One of the [SSP] forum user asked about what is OLAP, how the process flow occurrs when update happens to a fact table! It sounds like the basic question for Analysis Services user, OLAP - On-Line Analytical Processing for BI - Business Intelligence is...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Feb 11 2008
Filed under: Filed under: sql server, technet, bi, olap, dimension, table, whitepaper, cube, business intelligence, architecture, fact, what if
SQL Server 2005 Books Online September 2007 available for download - update your local copy

As we blogged much on Books Online importance and recent changes to availablility of updated books online for SQL Server 2005 under BOL-Sep2007-MSDN-Technet the same update is available to download. Do not forget to update your local copies as it will...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Dec 18 2007
Filed under: Filed under: sql server, msdn, technet, update, localhost, BOL, 2005, books online, download center
Rename a SQL Server instance, a little catch

Can I rename an instance of SQL Server after I have already installed it on the computer? Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Dec 14 2007
Filed under: Filed under: sql server, msdn, technet, instance, read, best practices, installation, servers, rename, local

Page 1 of 2 (36 items) 1 2 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.