![]() |
|
Spaces home Dinesh's Blog ...ProfileFriendsBlogMore ![]() | ![]() |
|
June 12 New article on TDEMy first article on SQL Server 2008 has been published at http://sql-server-performance.com. I wrote this article based on the tests I did regarding Transparent Data Encryption (TDE) that is newly introduced with SQL Server 2008. This articles covers;
You can read my article at http://sql-server-performance.com/articles/dba/Transparent_Data_Encryption_p1.aspx. Please let me know you thoughts on this, you can either add a comment to the article or send me an email to dinesh@sqlserveruniverse.com. I will writing two more articles on SQL Server 2008, will be publishing at http://sqlserveruniverse.com and http://sql-server-performance.com. June 03 Analysis Services Browser Views Add-InYossi Elkayam has done a nice add-in to the BIDS that allows you to save views created for SSAS and run them as new requests. Seems this is very useful if you are currently working on a SSAS project. May 30 What kept me silent?I am back. I did not write anything on my blog for last two months, I am not sure what kept me away from my favorite area, my blog. One reason would be, I guess, I was influenced by many things. Few things I want to make a note on; My Personal life
That's about few things happened in last two months. I will be writing technical related things again in my blog, so, stay tune. April 01 Presentation of first part of "Know before doing it" is publishedWe started a new series of sessions, called "Know before doing it" for SQL Server Sri Lanka User Group Meeting and the first part of it was presented at the last meeting. I did a the first part of it, demonstrating some of the internal process of SQL Server and feedback from the audience for the session of really good. March 26 SQL Server 2008 - The hierarchyid data typeGogula has written, good, properly explained article on SQL Server 2008, one of the newest data types, hierarchyid and has been published at http://sqlserveruniverse.com . It is a very useful article, worth to read it. Nuggets from my SSIS experienceI have been doing lot of development on SSIS for last two, three months and I made this note on what I faced during the project. It may useful for your future SSIS development, or brush up your SSIS knowledge. Read and see. March 11 Data Comparison with Data DudeMy latest article, Data Comparison with Data Dude has been published at www.sql-server-performance.com. This talks about the way of comparing the data between two data sources and scripting the changes. March 10 Faced another issue with SSISHad to spend few minutes on this, to resolve the issue but found no solution. The problem was really weird. It was with variable window; Give something good on SQL 2008 and win great prizesHere is a chance to show your colors and win very valuable prizes. All you have to do is, write some, creative, good code on SQL Server 2008 that will help to the community and send to CodePlex. February 26 Taking advantages of Instant File InitializationHave you ever tried this and seen the speed of file allocation process? Though I had heard about it, I had not tried (I might have but I cannot remember :)). The default file allocation of SQL Server is zero initialization that takes long time when you try to create a database with a large sized data file or when you try to restore a fairly large database that is not exist. These two processes (not only these two, other processes like adding a new file...) can be speeded up by enabling Instant Initialization. You can enable the Instant Initialization by giving proper permission to the server that runs the SQL Server instance. Let me show you the simple test I did; February 20 11th SS SLUG meeting - Scheduled to 21stSince the 20th is a Poyaday that is a mercantile holiday in Sri Lanka, we decided to have SS SLUG meeting on 21st, Thursday. Fiqri, ASP.NET MVP is going to join with us this time, showing his knowledge on SQL Server mobile edition. I am sure that Fiqri is going to deliver very valuable info for us because we have not discussed this topic before. February 08 Another article at sql-server-performanceAnother note of mine talks about "Schema Comparison with Data Dude" has been published at www.sql-server-performance.com. This shows the way of doing the schema comparison and how Data Dude addresses the changes. February 04 60th National Independence day celebrationWe, Sri Lankans celebrated 60th National Independence day today. It held on a grand scale at Gall Face, Colombo and all the media channels showed the program live. I am proud of being Sri Lankan because of the greatest history we have and wonders our ancestors had done. Though we celebrate our independence like this, the LTTE terrorists are slowly sweeping it away from us. They keep on killing innocents and destroying the country. They targeted some innocents people today too, at Colombo Railway Station, killing 12 including two school children. When we can see the peace? When we can live happily? Will they let our children live happily in this country? January 23 Two new articles publishedTwo of my articles have been published; one at http://sql-server-performance.com and http://sqlserveruniverse.com. January 19 SQL Server 2005 Best Practices Analyzer (January 2008) The latest version is available with new stuff; with new rules, enhanced facilities for documentation, more support for SSAS. I did not test anything yet but you ca start testing, using it. Download the BPA from here. January 03 MVP title renewedMy MVP title has been renewed, for the third year. I believe that I have done a fair community service last two years and thanks for Microsoft for evaluating and awarding me the title again. January 01 Another new year startsAnother year started with full of hopes and plans. I just went through the checklist of plans I had for year 2007 and found, wow, I have achieved almost all plans.
December 19 9th Consecutive SS SLUG meeting - with Christmas EveSQL Server Sri Lanka User Group meeting is happening today (19th) and yes, it is the last meeting for this year. Gogula will be doing a session regarding SQL Server 2005 Service Broker that we really wanted cover with previous meetings and Dinesh Asanka will be doing a session about one of the red-gate products; SQL Data Compare. November 23 New Article at SQL Server UniverseI published a new article regarding log shipping with SQL Server 2005. I have added details as much as possible and the way of implementation. Data Dude PresentationI have uploaded the presentation I did at SS SLUG meeting. You can download the presentation from here.
|
|
|