Browse by Tags

All Tags » SQL (RSS)
Friday, December 19, 2008 10:06 AM

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...
Posted by sweisfeld | with no comments
Filed under:
Monday, December 15, 2008 7:34 PM

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...
Posted by sweisfeld | with no comments
Filed under:
Sunday, November 23, 2008 2:58 PM

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 by sweisfeld | 1 comment(s)
Filed under: , ,
Thursday, October 23, 2008 8:43 AM

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...
Posted by sweisfeld | with no comments
Filed under: , ,
Friday, September 05, 2008 12:48 PM

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...
Posted by sweisfeld | with no comments
Filed under:
Wednesday, August 20, 2008 7:46 AM

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 by sweisfeld | with no comments
Filed under: , ,
Wednesday, August 13, 2008 6:59 AM

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....
Posted by sweisfeld | with no comments
Filed under:
Wednesday, August 13, 2008 6:44 AM

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...
Posted by sweisfeld | with no comments
Filed under:
Friday, May 02, 2008 11:50 AM

SQL Saturday Jax May 3 2008

Tomorrow will be the long awaited third installment of SQL Saturday in Jacksonville FL. I want to thank Brian, Andy and the team for all their hard work putting the event together. If you attended my talk or just want to see some cool stuff about using...
Posted by sweisfeld | with no comments
Filed under:
Friday, April 25, 2008 2:55 PM

Need to delete lots of data, do it in small chunks

By adding a top clause to your delete statement you can delete a chunk of records at a time. By combining it with a while you can put it in a loop and wipe the entire table. WHILE EXISTS ( SELECT * FROM Foo ) BEGIN DELETE TOP ( 100 ) FROM Foo END Had...
Posted by sweisfeld | with no comments
Filed under:
Saturday, April 12, 2008 6:03 PM

Drop Me!

I was trying to get rid of all the objects (tables, procedures, views) in my database and whipped up this little script and while it is far from perfect it is well worth sharing. . . SELECT CASE WHEN type = 'P' THEN 'DROP PROCEDURE ' ...
Posted by sweisfeld | with no comments
Filed under:
Sunday, February 17, 2008 6:56 PM

2008 SQL Saturday Tampa

SQL Saturday Tampa 2008 was great, a big thank you to the organizers Pam, Wes, and team, great job guys! To those that attended my session on the SQL CLR I have uploaded my presentation here ( http://cid-afc22ba66ea68f7d.skydrive.live.com/self.aspx/Public...
Posted by sweisfeld | with no comments
Filed under: , ,
Monday, January 21, 2008 8:55 AM

Pivot/Cross Tab Queries in SQL Server

There are many ways to turn rows of data into columns in SQL Server, I figured I would outline some of them and talk about some of the pro/cons of each. Sample 1: Using the SQL Server 2005 PIVOT operator. This is a great feature of SQL Server 2005 but...
Posted by sweisfeld | with no comments
Filed under:
Sunday, November 11, 2007 12:37 PM

Orlando SQL Saturday 2007 & .NET SQL CLR

Yesterday was the first ever SQL Saturday, mad props to Andy Warren from End2End Training ( http://www.endtoendtraining.com/ ) for all his work organizing this event. Over 200 people showed up to hear about some SQL server goodness. Andy defiantly raised...
Posted by sweisfeld | with no comments
Filed under: ,
Friday, October 26, 2007 3:14 PM

SQL Server 2005 Bulk Inserts

Need to dump a large amount of data into sql server? Have I got some tools for you! Recently I needed to, from a stored procedure, copy a large amount of data from a text file on the disk into my sql server. This is nice an easy with SQL Server 2005....
Posted by sweisfeld | with no comments
Filed under: ,
More Posts Next page »