Browse by Tags
All Tags »
setup (
RSS)
As promised SQL Server release services has done it again, a great job in releasing SQL Server 2008 Service Pack 2 . Continung from SQL-2008-CU10 blog post here, it is recommended (I say MUST) to go through the SP2 release notes the download link confirms...
There is a myth (rather a wrong impression) in database world that SQL Server setup is pretty easy, what you do is insert setup-media into drive and click next....next.....next, well it is not!!! .... read here ...
Whenever any user (forum or usergroup) asks me about Upgrade gotchas and FAQs I will refer this SQLUpgrade-blurb post that I have made from my experience. Further I would like to enhance the topic of upgrade and things you need to watch about Collation...
Transactions and Checkpoints are important factors for data consistency, when it comes for ETL processes that too on SSIS what is your stand? I'm covering this important task for the sake of newbie & junior DBAs, also the similar question was...
How can you change collation of a database? How do you check the existing collation setup on a database & tables? By using the below TSQL: --For database select databasepropertyex(db_name(),'collation') as collation_name go --Tables select column_name...
