Are SQL DBAs an unhealthy group?(www.texastoo.com)

submitted by ab5sr(285) 16 days, 16 hours ago

Are SQL data folks, as a group, unhealthy? read more...

add a comment |category: Community |Views: 3

tags: Community another

SQL writers, bloggers are not citing their sources(www.texastoo.com)

submitted by ab5sr(285) 3 months, 9 days ago

References? We don't need no stinking references! Or do we? read more...

add a comment |category: SQL |Views: 6

tags: SQL another

Dynamic SSIS Packages, Part 4.(www.texastoo.com)

submitted by ab5sr(285) 9 months, 17 days ago

Check out my blog series for creating true dynamic SSIS packages using the SSIS API read more...

add a comment |category: Database |Views: 3

tags: Database another

Generating 100,000 files from SQL Server, Part 2.(www.texastoo.com)

submitted by ab5sr(285) 1 year, 3 months ago

Here's a fast way to generate a bunch of files using c#. Can you think of a faster one or way to improve this code? read more...

add a comment |category: C# |Views: 4

tags: C# another

SQL Training Vid - | (Bitwise OR) operator(www.texastoo.com)

submitted by ab5sr(285) 1 year, 4 months ago

Ever wondered how you might use the bitwise operators in TSQL? Check out my vid on this and see if it helps open up some possibilities for you. read more...

add a comment |category: Database |Views: 3

tags: Database another

More Fast Processing in tempdb(www.texastoo.com)

submitted by ab5sr(285) 1 year, 4 months ago

I'm exploring the possibility of leveraging tempdb's ability to do DML faster than user databases. Check it out - we may be onto something. read more...

add a comment |category: Database |Views: 5

tags: Database another

Investigating Multiple Transaction Log Files in SQL Server(www.texastoo.com)

submitted by ab5sr(285) 1 year, 7 months ago

What's up with the multiple transaction log files in your database? Are they there for a reason? I looked into this a bit...thanks for reading. read more...

add a comment |category: Database |Views: 9

tags: Database another

Explicitly dropping Temporary Tables and performance – Myth or Fact?(www.texastoo.com)

submitted by ab5sr(285) 1 year, 10 months ago

Test to determine whether or not this is true...interesting find, so please check it out. read more...

add a comment |category: Database |Views: 3

tags: Database another

Demystifying the SSIS Script Component, Part 3(www.texastoo.com)

submitted by ab5sr(285) 2 years ago

Part 3 of a series on the SSIS Script component (level 100). read more...

add a comment |category: Database |Views: 27

tags: Database another

Updating a column to itself in TSQL(www.texastoo.com)

submitted by ab5sr(285) 2 years, 1 month ago

Someone asked me the other day what the ramification was on the transaction log in SQL Server if the value of a column got updated to itself. Check it out. read more...

add a comment |category: Database |Views: 4

tags: Database another

MongoDB vs. SQL Server - INSERT comparison(texastoo.com)

submitted by ab5sr(285) 2 years, 1 month ago

Geeking with MondoDB is cool; check this INSERT comparison to SQL Server 2008. read more...

add a comment |category: Database |Views: 44

tags: Database another

Interesting TSQL query plan for NOT IN vs. NOT EXISTS(texastoo.com)

submitted by ab5sr(285) 2 years, 1 month ago

Ever use EXISTS, NOT EXISTS, IN, and NOT IN? Check this out if you do... read more...

add a comment |category: Database |Views: 15

tags: Database another

Demystifying the SSIS Script Component, Part 2(www.texastoo.com)

submitted by ab5sr(285) 2 years, 1 month ago

A tutorial on the SSIS Script Component - SQL Server 2008 SSIS. This one explores the Transformation task using the Extension Methods in .Net read more...

add a comment |category: Database |Views: 46

tags: Database another

SSIS and LINQ, continued.(www.texastoo.com)

submitted by ab5sr(285) 2 years, 2 months ago

A continuation of my SSIS and Linq experiment. read more...

add a comment |category: Database |Views: 9

tags: Database another

SSIS and LINQ(www.texastoo.com)

submitted by ab5sr(285) 2 years, 2 months ago

SSIS and Linq experiment read more...

add a comment |category: Database |Views: 12

tags: Database another

Demystifying the SSIS Script Component, Part 1.(www.texastoo.com)

submitted by ab5sr(285) 2 years, 3 months ago

The Script Component can open up the power of .Net within SQL Server Integration Services. Check out this series of blogs as I show how you can incorporate it into your BI development. read more...

add a comment |category: Database |Views: 73

tags: Database another