July 2011 UG presentation Material
We had wonderful session this month. I reached the venue on time and I could see some of the participants and after some time everyone started reaching the venue. I really appreciate all the participants who came to the session , it’s really nice to see you guys. I have started my session and then followed by Amit Bansal and then by Madhi. Surprising we had a volunteer speaker who wanted to take a 10 min session.
RamKumar is the guy who volunteered for taking the session, we granted him a 10 min space and he took SQL Server myth and realities. That’s also a good session. I really wanted to thank Amit Bansal who volunteered to take a session for the UG event. Thanks to Madhi and Ramkumar too. I’m uploading the presentations and scripts which we shown during the session, you can download and play with it.
Troubleshooting Tempdb and Best Practices by VIDHYASAGAR
All about Date time data type by MADHIVANAN
Database Unit Testing by AMIT BANSAL
SQL Server Myth and Realities by RAM KUMAR
I’m sharing some of the pics which we took during our session. And again thanks to you guys.
Update: Write up from Ram is here. http://www.sqlservercentral.com/blogs/livingforsqlserver/archive/2011/08/07/chennai-sql-server-user-group-and-me.aspx
Tags: chnsqlug, cssug, user group
Trackback from your site.
Amit Bhatt
| #
Hi Deepak,
Thanks for such a nice article.
You missed one thing to add in code:
@article = ‘all’,
Hence the script will be like this:
EXEC sp_addsubscription
@publication = ‘mypublication’,
@article = ‘ALL’,
@subscriber = ‘Subscriberservername’,
@destination_db = ‘mydestinationdbname’,
@reserved=’Internal’
Error 18486 | Platformblog
| #
[...] SQL-Articles » Troubleshooting Login failed Error 18456This is one of the infamous error message (and number) that most of the DBAs …. 18486. Login failed for user ‘%.*ls’ because the account is currently locked out. [...]
Setting and Changing Collation – SQL Server 2008 « Blog
| #
[...] to sql-articles.comRead more: http://sql-articles.com/articles/dba/how-to-change-server-collation-in-sql-server-2008/#ixzz1pu2S8XW… Like this:LikeBe the first to like this [...]
VidhyaSagar
| #
Naveen,
I’ll check this out and get back to you.
balakiran
| #
Thanks man, Very simple & easy to understand !!!!