Browse by Tags

MSDN & Technet webcast for SQL Server 2008 and SQL Server Compact 3.5 versions

Published 3 September 8 4:4 PM | SSQA.net

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

Filed under: sql server, msdn, webcast, microsoft, technet, community, version, best practices, comact

Technical Rollup email pertaining to SQL Server, documents & guidelines

Published 3 September 8 3:59 AM | SSQA.net

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

Filed under: sql server, technet, documentation, best practices, technical

SQL Server Technical Rollup July 2008 - Important & Interested links for you

Published 7 July 8 2:51 AM | SSQA.net

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

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?

Published 28 April 8 3:1 AM | SSQA.net

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

Filed under: sql server, performance, microsoft, technet, i/o, article, disk, best practices, monitoring, deployment, layout

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

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

Published 28 March 8 6:45 PM | SSQA.net

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

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

Published 18 March 8 6:23 AM | SSQA.net

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

Filed under: sql server, high availability, technet, database, best practices, sharepoint, database mirroring, failover, links

Microsoft Empower Program - good deal for ISVs

Published 28 February 8 4:11 AM | SSQA.net

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

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.

Published 26 February 8 4:45 AM | SSQA.net

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

Filed under: sql server, performance, microsoft, technet, data mining, version, virtual, labs, 2005, loading

SQL Server 2008 February CTP, is availble to download now!

Published 20 February 8 5:37 AM | SSQA.net

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

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?

Published 11 February 8 3:38 AM | SSQA.net

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

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

Published 18 December 7 4:25 AM | SSQA.net

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

Filed under: sql server, msdn, technet, update, localhost, BOL, 2005, books online, download center

Rename a SQL Server instance, a little catch

Published 14 December 7 4:4 AM | SSQA.net

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

Filed under: sql server, msdn, technet, instance, read, best practices, installation, servers, rename, local

MSDN labs - Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005

Published 11 December 7 10:11 AM | SSQA.net

Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product . Similar...

Filed under: sql server, msdn, technet, replication, best practices, virtual labs, merge, compact edition, mobile, developement

SQL Server: How do I identify the queries that are worth tuning?

Published 16 November 7 7:2 AM | SSQA.net

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...

Filed under: sql server, performance, management, microsoft, blogs, technet, dmv, dba, best practice, slow query

Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)

Published 15 November 7 7:16 AM | SSQA.net

It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read &...

Filed under: sql server, performance, microsoft, technet, dmv, top, tsql, reads, system resources, expensive query, identity, writes

How to find whether that service pack file is a 32 bit or 64 bit?

Published 1 November 7 6:44 AM | SSQA.net

Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...

Filed under: sql server, msdn, microsoft, blogs, technet, download, kba, best practices, x64, testing, begin

NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?

Published 16 October 7 7:18 AM | SSQA.net

You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and...

Filed under: sql server, performance, microsoft, technet, disk, partition, testing, hardware, lun, clustersize

SQL Server Virtual Labs - fully featured virtual environment for testing!

Published 5 October 7 11:4 AM | SSQA.net

Virtual labs - in simple words its simple to use where a pre-installed environment is setup to try out /test SQL Server installation for your databses upgrade, that has full-featured labs. Not only this you have an option to download manual with a 90...

Filed under: sql server, microsoft, technet, database, download, upgrade, virtual labs, 2000, 2005

Featured downloads - from Technet center

Published 5 October 7 10:56 AM | SSQA.net

Have you seen the Technet Center flash recenlty, how many of you get/follow the Technet center flash? I get to update myself with other Microsoft technologies with that flash letter. The TechNet Flash is full of pointers to in-depth technical information...

Filed under: sql server, microsoft, technet, download, techCenter, web seminar, flash, letter