Browse by Tags

Pipe "|" delimited files with Excel & SQL Server

I am constantly querying random data out of SQL Server and sending it to EXCEL files to email to a co-worker. Exporting to a comma separated or tab separated file is no good since those characters appear in my data frequently so I have switched to using a Pipe, “|”, character. This is easy enough to...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 12-19-2008
SQL PASS 2008 Feedback

I wanted to share the feedback that I got from my presentation this year at the PASS Summit. ( http://drowningintechnicaldebt.com/blogs/shawnweisfeld/archive/2008/11/23/sql-pass-2008-talk.aspx ) Again thank you to all that attended, and a special thank you to those that provided feedback it is an invaluable...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 12-15-2008
SQL PASS 2008 Talk

If you attended my talk at pass last week, you can get the slides & downloads here ( http://www.developerroundtable.com/Libraries/Downloads/PASS_SQL_CLR.sflb.ashx ). I hope you enjoyed the talk. Feel free to send me feedback!

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 11-23-2008
Data Dude!

Microsoft just changed the licensing for the Developer Team Edition for MSDN. If you have the Developer SKU you are now also licensed to use the Database Team Edition. (If you don’t know what SKU you have go to MSDN and check). Why does this matter to me? The Database edition has many cool features but...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 10-23-2008
find sql users and roles assigned to my databases

thanks to this article for the base script. i needed to get a list of all users and the roles they had in each db. this script is great in that you can use the raw base script (mine is slightly modified) and list things for every object instead of just at the db level. in my case and in most people's...

Posted to roy ashbrook (Weblog) by royashbrook on 09-05-2008
XML in SQL server

Question From NTSSUG - http://northtexas.sqlpass.org I am working on an application that has object data mapped to tables. The mapping was done many years ago, before the likes of Hibernate came along. It basically maps a class to a table. Object properties with multiple values get their own tables....

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 09-05-2008
Huston TechFest 2008

I will be giving my SQL CLR talk at the Houston TechFest on Saturday September 13 at the University of Houston. It will be a great event.

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 08-20-2008
Allow Remote Connections & Linked Servers

Got the following question via the North Texas SQL Server UG ( http://northtexas.sqlpass.org/ ) mailing list. Hi, I am trying to add linked server in SQL Server 2005 (let say server1)for a another remote server(server2) which is also SQL Server 2005. Do I need to create a login on the server2 in order...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 08-13-2008
The Top Ten Reasons to Attend the PASS Summit 2008

I read an article on SQL Server Central about the "The Top Ten Reasons to Attend the PASS Summit 2008" ( http://www.sqlservercentral.com/articles/SQLServerCentral.com/62979/ ) and I would like to propose one more. I will let you decide if it is #1, #11 or somewhere in the middle. If you attend...

Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 08-13-2008
'net' command (net user, net localgroup, etc)

it's depressing to me how many people that i run into today that have an excrutiatingly limited knowledge about the command line in windows, and yet they are considered experts on the platform. that aside, i figured i would share a couple of very simple uses. something people ask a lot is what domain...

Posted to roy ashbrook (Weblog) by royashbrook on 07-29-2008

Page 1 of 9 (86 items) 1 2 3 4 5 Next > ... Last »