Browse by Tags

All Tags » Technology » SQL Server » Tips & Tricks (RSS)
Autonomous Transaction with SQL Server 2008
This was an interesting post on the Programmability teams blog. I have come across a number of people asking for this feature as it works with Oracle. This blog describes one of the server options enabled with SQL Server to achieve the task. Read the...
Posted 09-01-2008 by vinodkumar | 1 comment(s)
Filed under: , , ,
DataMining in the Cloud
Once this does happen, this will be exciting. Trust me !!! I have been using the Table Analysis from the Excel Add-in and whenever I have showcased them, people have just loved it. Catch this space for specifics.
Posted 08-26-2008 by vinodkumar | 1 comment(s)
Filed under: , , ,
Partitioned Tables - SQL 2008
Craig has a couple of post on SQL Server 2008 Partitioned tables and Partitioned Indexes . Most interesting is the way Criag uses the ShowXMLPlan to explain the concepts. I sort of like this approach and is easy when writing articles. Earlier I used to...
Posted 08-23-2008 by vinodkumar | with no comments
Filed under: , , ,
Did you know - Sort Warnings?
Here is a neat post around using Sort Warnings and how to use SQL Server Profiler to view the same. Read the post from Blogs.MSDN :).
Posted 08-01-2008 by vinodkumar | with no comments
Filed under: , ,
How to debug Slow response times in SQL 2008
Check out this cool article from the SQLOS team on the technet blogs. Read it here .
Posted 07-29-2008 by vinodkumar | with no comments
Filed under: , , ,
Server-quest Game !!!
Are you geek enough to win the entire office’s respect? Prove it. Play Server Quest, where you’ll navigate through the perils of office life, protect the server, and keep clear of the arrogant sales guy. Look for it online at www.server-quest.com . Play...
Posted 06-17-2008 by vinodkumar | with no comments
Filed under: , , ,
Latest on ExtremeExperts - May'08
I just uploaded a couple of articles on my website after a long time. Catch the same from the below links and feel free to drop your comments. Security in SQL Server 2005 - Part I DMVs - sp_who2 Script
Posted 05-26-2008 by vinodkumar | with no comments
Filed under: , ,
RS 2008 Memory Management
Some good explanation on Memory Management , though not exhaustive atleast gives you a head-start to where to find data.
Posted 05-23-2008 by vinodkumar | with no comments
Filed under: , , ,
GROUP BY ALL
Did you know such a thing ever existed? Check this post from SQLTeam on the GROUP BY ALL feature here .
Posted 05-09-2008 by vinodkumar | with no comments
Filed under: , , ,
How it works section
Catch some really cool posts by the PSS support engineers on various SQL Server topics. These are HOW TO topics , crip yet lots of internal behaviours explained.
Posted 04-23-2008 by vinodkumar | 1 comment(s)
Filed under: , ,
Performance Monitoring with SQL 2008
Check my blog post on TechNet over Performance Monitoring with SQL Server 2008 here . Feel free to pass your comments.
Posted 01-29-2008 by vinodkumar | with no comments
Filed under: , , , ,
BPA 2005 - Jan build
The January 2008 package contains: BPA UI and command line tools Rules (previous rules + ~60 new rules) Rich documentation Download it here .
Posted 01-26-2008 by vinodkumar | 1 comment(s)
Filed under: , , ,
101 with SQL CE 3.5
With Microsoft SQL Server Compact 3.5 and Microsoft Visual Studio 2008, developers have an easy-to-deploy solution for local data. Ranging from caching reference data to full offline scenarios, developers can use a single engine for their Windows Mobile...
Posted 01-23-2008 by vinodkumar | with no comments
Filed under: , ,
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance...
Posted 01-21-2008 by vinodkumar | 1 comment(s)
Filed under: , , , ,
Database Mirroring and Log Shipping Working Together
Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single...
Posted 01-19-2008 by vinodkumar | with no comments
Filed under: , , , ,
More Posts Next page »

Search

Go

This Blog

Tags

Community

Archives

My Web Site

External Sites

Other Misc Blog Links

Newsletter

Syndication

News


  • Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    Site Counter: Hit Counter