Community TechDays at Ahmedabad was a great successful event. In fact, this can be considered the biggest event held in Ahmedabad thus far along with community. This event was held by Microsoft and PASS (Professional Association of SQL Server). The goal of this event was to dive deep into the world of Microsoft technologies and get trained on the latest from Microsoft. Well, we could successfully achieve the same and build real connections with Microsoft experts and community members.
SQL SERVER – Choose Right Edition of SQL Server Express for Your Application
SQL Server Express is better alternative of MySQL. I have recently helped quite a few organizations to move to SQL Server Express recently. However, one question keep on coming up quite often regarding which is the right edition for SQL Server Express. SQL Server Express have more than one edition…
Read MoreSQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition
Database Encryption in SQL Server 2008 Enterprise Edition SQL Server Technical Article Writers: Sung Hsueh Technical Reviewers: Raul Garcia, Sameer Tejani, Chas Jeffries, Douglas MacIver, Byron Hynes, Ruslan Ovechkin, Laurentiu Cristofor, Rick Byham, Sethu Kalavakur Published: February 2008 TDE does not replace cell-level encryption, EFS, or BitLocker. This white paper…
Read More
SQLAuthority News – SQL Server 2008 – The Other Side of Index – Community Tech Days
Community Tech Days are here Tomorrow in Ahmedabad on Oct 3, 2009. I will be presenting the session ‘SQL Server 2008 – The Other Side of Index’. I will be available there whole day if you want to meet and discuss SQL. I will be starting my session with following cartoon. You will have to attend the session in person to see what I am going to cover in the session.
SQL SERVER – SQL Server Management Studio and Client Statistics
Client Statistics is very important. Many a time, people relate queries execution plan with query cost. This is not a good comparison. Both are different parameters, and they are not always related. It is possible that the query cost of any statement is less, but the amount of the data…
Read MoreSQLAuthority News – Community Tech Days – Oct 3, 2009 – SQL Server 2008 – The Other Side of Index
Microsoft Community Tech Days are here! Dive deep into the world of Microsoft technologies at the Community TechDays and get trained on the latest from Microsoft. Community Tech Days are coming to Ahmedabad on Oct 3, 2009. I will be presenting the session ‘SQL Server 2008 – The Other Side…
Read MoreSQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries
Working with SQL Server has never seems to be monotonous – no matter how long one has worked with it. Quite often, I come across some excellent comments that I feel like acknowledging them as blog posts. Recently, I wrote an article on SQL SERVER – Execution Plan and Results…
Read MoreSQLAuthority News – Download IIS Database Manager
IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager. IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network. Once connected, IIS Database Manager provides…
Read MoreSQLAuthority News – FILESTREAM Storage in SQL Server 2008
This white paper describes the FILESTREAM feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. This white paper is Written By: Paul S. Randal (SQLskills.com) Read the white paper here. Reference :…
Read MoreSQLAuthority News – FIX : An error occurred while executing this command. If this error persists, please contact your Live Meeting administrator.
Recently, while I was scheduling a live meeting for one of my online training sessions, I kept receiving the following error message repeatedly. I had never encountered this type of error before, and despite searching online for a long time, I could not solve this problem. After several failed attempts,…
Read More