Browse by Tags

All Tags » features » sql server (RSS)
SQL Server 2008 Performance Data Collection and Analysis, how best you can take advantage?
Published 11 September 8 2:11 AM | SSQA.net
How many tools (new and enhanced) are available within SQL Server 2008 when you have a need to monitor the performance of queries that are executing/generated? The initial ones you remember is PROFILER and PERFMON (SYSMON) tools, even further few will...
Filed under: , , , , , , ,
SQLTeach/DevTeach Montreal registration open -- early bird discounts
Published 4 September 8 3:30 AM | SSQA.net
En français Get a 300$ early bird discount by registering before September 13th. We are offering an early bird of 300$ CAD for attendees that are registering before September 13th, 2008. Registered attendees have access to the DevTeach Archive sessions...
Filed under: , , , , , ,
SQL Server 2008 Learning Live Webcast series from IDERA - win SQL admin toolset
Published 19 August 8 9:27 AM | SSQA.net
Date: Wednesday, August 20, 2008* Time: 4 PM Eastern | 3 PM Central | 1 PM Pacific Speaker: SQL Server MVP, Hilary Cotter Attend and win! Find out how! *Want to attend but can’t make this date? No worries! Each webcast will be archived for up to 6 months...
Filed under: , , , , , ,
SQL Server 2008 RTM is released, its official now!
Published 6 August 8 1:40 PM | SSQA.net
Microsoft press announces that SQL Server 2008 is available for users and as per PressRelease : . ..announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence...
Filed under: , , , , , ,
SQL Server Data Encryption and Backup - any guidelines to follow?
Published 4 August 8 3:0 AM | SSQA.net
When it comes to the data encryption within SQL Server 2008 you would think about Transparent data encryption (TDE) which is a new encryption feature. It sounds good that this is a high level security feature you can deploy to secure the data, and a catch...
Filed under: , , , , , , ,
SQL Server 2005 or 2008: SQL Native Client or MDAC - which is best one to use?
Published 16 June 8 3:53 AM | SSQA.net
SQL Native client or MDAC - which is best one to use? This was the question I was asked during my presence at DAT booth at the Tech-Ed ITPRO conference in Orlando. The sensible answer will be 'it depends'. Practically I have seen that there are...
Filed under: , , , , , ,
SQL Server 2008 - Replication and Filestream, are both supported together?
Published 26 May 8 4:1 AM | SSQA.net
Ok, replication concepts and technology has been continuing since the olden days (version 70) within SQL Server journey. To talk about new features within SQLServer 2008 comapring to the previous versions, FILESTREAM where much of data is created every...
Filed under: , , , , ,
SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)
Published 2 May 8 9:12 AM | SSQA.net
Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because...
Filed under: , , , , , , ,
SQL Server 2008 - What's new and what's coming up!
Published 17 March 8 3:11 AM | SSQA.net
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...
Filed under: , , , , , , , ,
SQL Server 2008 - Activity Monitor a new key to DBA!
Published 11 March 8 3:14 AM | SSQA.net
Have you looked at the Activity Monitor screen within the Managment Studio? I feel this is somewhat surprise features included from February CTP (or was it there before?). This is more useful to the DBAs to have a look at resource activity and locking...
Filed under: , , , , , , , ,
SQL Server 2008 Data Security - TDE: Transperent Data Encryption what you need to know
Published 5 March 8 2:5 AM | SSQA.net
What kind of security features you adopt to protect your data? Login security, permissions and unauthorised access to your data, there is more you can do with SQL Server 2008 new feature called TDE - Transperent Data Encryption that is provided automatically...
Filed under: , , , , , ,
What's new, rather removed features from SQL Server 2008 (CTP6)
Published 21 February 8 2:11 AM | SSQA.net
It has been a 'very busy' month sofar, in particular to Microsoft world and sub-domains of Windows Server, Virtual Server & SQL Server and you know why from here. Not a 'real' launch for SQL Server folks out there, but a concession...
Filed under: , , , , , , , ,
10 Best Practices for Data Archiving - all platforms
Published 31 December 7 6:44 AM | SSQA.net
When you think about effective data management, archiving will also play important role to manage your data. In this regard Windows Magazine has included best practices for your data management. Data privacy and identity theft have a higher profile in...
Filed under: , , , , , , , ,
SQL Server 2008 - enhanced feature in database mirroing "log compression"
Published 15 October 7 4:11 AM | SSQA.net
Database Mirroring - new feature from SQL Server 2005 within High Availability ranch, a software based solution for database availability. Very important for the DBAs to keep up the database recovery model to FULL at all the times to achieve the High...
Filed under: , , , , , , ,
New feature in SQL Server 2008 - compression how it works?
Published 3 October 7 9:42 AM | SSQA.net
Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature, so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and...
Filed under: , , , , , , , , ,
SQL Server 2008 - what would be cost for licensing as compared to SQL 2005 version?
Published 19 September 7 2:30 AM | SSQA.net
Since the release of SQL Server 2008 CTP most of the blogs are filled with 'whats new' feature within this release or going to create a highlight as compared to SQL 2005. The best of all those blogs I would recommend (thanks to) Bob Beauchemin...
Filed under: , , , , ,
SQL 2008 Training Available : free e-learning
Published 10 July 7 2:57 AM | SSQA.net
Here is the link to attend a free e-learning on SQL Server 2008 eLearning78337 link. Title: Clinic 7045: What's New in SQL Server 2008 Course Type: Self-paced Course (at your ease) Available Offline: Yes Estimated Time of Completion: 2 Hours Language...
Filed under: , , , , , ,
Up close and personal with SQL Server 2008 (Katmai)
Published 22 June 7 4:33 PM | SSQA.net
In this two-part podcast series, we take a close look at SQL Server 2008. Microsoft product manager Francois Ajenstat discusses the key features of the upcoming version of SQL Server, what Microsoft is doing to scale SQL Server 2008, plus progress being...
Filed under: , , , ,
SQL Server 2008 - Change Data Capture: new feature
Published 20 June 7 4:34 PM | SSQA.net
Let us talk briefly about the new feature that is introduced within SQL Server 2008 aka Katmai. Change Data Capture (CDC) is (similar to triggers: INSERTED & DELETED tables) the 'new boy in SQL Server town' that records the DML activities...
Filed under: , , , , , ,
LINQ vs TSQL - Where it is going?
Published 17 June 7 2:58 PM | SSQA.net
There are few discussions around that is TSQL will cease to work as LINQ and another point of impact on C# here. As LINQ is more kind of development language as Microsoft promoting for develpers, IMHO it is not a replacement for TSQL at all. There are...
Filed under: , , , ,
More Posts Next page »