-
Yukon - The next generation ...
-
I understand that Yukon is full of promise. And I just can't wait to get my hands dirty... :) ... But I know that there is enough public information around you can get ...
They give you a good insight into what all features are in store for us in the next release. Proposed to release early 2004 for Public Beta I thought to visit some of the sites that host such information and compile a list of some of the key features discussed in each of these sites.
Visit my new article that compiles info from all these sites http://www.extremeexperts.com/sql/articles/Yukon.aspx. Interesting. These is just a part of the many links that show the capabilities of Yukon.
Happy reading ...
-
To many spams ... :( ...
-
The last month saw every Systems Administrator scramble to update their servers with security patches. I’m not blaming anyone except the virus writer for the problem. But I’d like to ask you to update your virus definitions and do a virus scan and be sure it’s not on your system. With the MDAC buffer overrun and the Blaster Virus hitting worldwide it is an important task to do. Back when Slammer released, we had quite the series of discussions on why patches hadn't been applied, the implications of blindly installing patches on production servers and what that meant for rapid response to security issues like Slammer. Basically, it meant that responding quickly to a new patch or update is incredibly difficult and can cause huge problems...
And now I start getting tons of spam also. With the emphasis on security we move to spams ... I am somewhat not given one good reason for all the spams that are hitting most of our email IDs. Even though automated I feel that people have to get more constructive in getting their technology skills for useful purposes ... Just a thought.
-
My Tech Ed Experience ...
-
My Tech Ed. experience was very rich. And the data tier track I attended was fun filled.
SQL Server 'Yukon' - .Net Programming features
Speaker – Rajiv Sodhi, Developer Advisor – Microsoft India
- Yukon is developing as a scalable, secure, enterprise data management platform. Key features are Enterprise Data Management, Programmability and Business Intelligence.
- The session concentrated on Programmability aspect of Yukon server.
- Notable features in Yukon are
- .Net Integration
- XML Support
- API Languages
- Developer Tools
- Relational Extensions.
- With Integration of .Net in Yukon, we can program .Net Assemblies for SQL server and register them. We will have System.Data.SqlServer as a new namespace for integration.
- With XML integration we can have new data type as XML and we can attach schema for the same.
- XQuery can be used for retrieving specific XML elements.
- The best feature would be SQL server exposing a web service that can be used on any platform.
- I am also in the process of consolidating information from all the sites and release an consolidated features list ... :) ...
Useful Links :
http://www.itwriting.com/sqlyukon.php
http://www.win2000mag.net/Articles/Index.cfm?ArticleID=38509
http://www.fawcette.com/dotnetmag/2003_06/magazine/columns/sqlconnection/
http://www.sswug.org/see/15436
http://www.microsoft.com/sql/evaluation/yukon.asp
http://www.microsoft.com/sql/evaluation/bi/reportingservices.asp
http://www.microsoft.com/sql/evaluation/news/yukon.asp
http://www.fawcette.com/dotnetmag/2003_06/magazine/columns/sqlconnection/
http://searchwin2000.techtarget.com/qna/0,289202,sid1_gci911794,00.html
Extending SQL server functionality with User-Defined Functions: Hidden Tricks
Speaker – Srimathi, Sr. Software Architect, Vishwak Systems
- The possibility of redefining system Stored Procedures as UDF has lots of exciting possibilities.
- This practical session concentrated on some tips and tricks on combining UDFs and Indexed Views or indexed columns to combine extra flexibility and performance at the same time.
- Many undocumented UDFs were demonstrated that could be used for optimizing the database queries
Useful Links:
http://www.novicksoftware.com/
http://www.sqlservercentral.com/columnists/achigrik/
http://www.umachandar.com/technical/SQL2000Scripts/Main.htm
http://www.extremeexperts.com/SQL/Articles/default.aspx
http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860
http://www.sqlserverfaq.com/content/books/samples/springer/BenGanSC.pdf
http://www.microsoft.com/sql/
Designing for Performance
Speaker – Praveen Srivatsa, Director, In4Velocity, MSDN Regional Director
- This was an interesting session was based on Planning, Optimizing for performance and Preserving Performance on SQL Server.
- It highlighted the changes expected in Yukon.
- Effective logging, Table width optimization for optimal storage, vertical and horizontal partitioning (covering) and fragmentation were explained in detail.
- Some of the key notes I got from this session is the use of multiple columns can reduce selectivity. Some example in Matrix context is using extra joins like, If a table has a join on CMN_ApplicationsInstancesID and if there is a possibility of joining on CMN_Students also then use the same also. Because there are chances that SQL Server can find a better selectivity.
Useful Links :
http://www.sql-server-performance.com/
http://www.sqlteam.com/FilterTopics.asp?TopicID=103
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=98
http://www.perftuning.com/
http://www.devarticles.com/art/1/489
http://www.only4gurus.com/v2/ShowCat.asp?Cat=SQL%20Server
http://gatton.uky.edu/Faculty/leepost/622/class4.html
http://www.txsqlusers.com/howto/DBCC_SHOWCONTIG.asp
http://www.databasejournal.com/features/mssql/article.php/2238211
-
User Group Meeting on Sep ...
-
Well, I am a part of the Bangalore User Group. And it has been conducting interesting sessions for a while now. And I try to make the sessions interesting by chipping in some SQL Server Tips and tricks. Yesterdays tip was to the use of NULL in SQL Server. And this tip was useful to most of them. They never knew now NULLs can give different results in SQL Server. Just to give all a small insight into the tip ...
Create table tableA (id Int)
Create table tableB (id Int)
GO
Insert into tableA values (1)
Insert into tableA values (2)
Insert into tableA values (NULL)
Insert into tableB values (1)
Insert into tableB values (2)
Insert into tableB values (3)
Insert into tableB values (4)
GO
Select * from tableA
Select * from tableB
GO
Now that we have created two tables. My simple requirement was to get all the vales in TableB that are not in TableA and the first solution that came to everyones mind was to use the following Query.
Select b.id from tableB b
Where b.id NOT IN (Select a.id from TableA a)
GO
And that was a win for me to make them understand what this really means. Since the presense of NULL would make the query false for all the values and hence you will get no. rows. To avoid this we mave a couple of options. Starting from using ISNULL and the IS NULL expressions to eliminate the NULL values. Or the best solution that I would recommend is:
Select id from tableB b
Where NOT Exists (Select 1 from TableA a Where a.id = b.ID)
Go
Faster and more efficient ... This is something we need to keep in mind while coding for our applications. I also understand that if we were to SET ANSI_NULLS OFF then also this behaviour is observed. But I donot recommend that approach.
-
My passion for SQL Server ...
-
This is my first attempt to start blogging ... I have been seeing loads of blogger sites in the past few months. And I thought of starting one. And here I am with you to share my blog through the sqlxml.org site ...
If you would like to see a intro about me. Then I co-host www.ExtremeExperts.com site and I share the same passion as you people ... SQL Server ... :) ... I have been writing a lot of exams for the past three years and some of them are listed here.
I've been interested in .NET technologies and my site is written on .NET. Using page templates. You will hear more about me and my efforts to build the site more here at my blog ...
Next tool set released:
I released the next tool for finding the SQL Server Service pack version. This is a simple tool and can tell you the version you are currently installed on your SQL Server. Can be useful for any admin. View Tool.