-
Recent Posts
Archives
Categories
Meta
-
Join 202 other subscribers
RSS
Category Archives: SQL
Schema changes and row size
I was working on a stored procedure that was misbehaving on a rather massive and embarrassing scale. The code seemed solid. The data model made sense. And yet… Every time I ran this proc it crashed and burned. There were … Continue reading
Downloading the Results of a Twitter Search using PowerShell and SQL (part 3)
Part one of this series is here and part two is here. You’ll need the SQL scripts from part two in order for the code below to work but you can skip part one unless you’re curious to see the … Continue reading
Posted in PowerShell, SQL
Tagged database, PowerShell, script, scripting, sql, sql server, Twitter
Leave a comment
Downloading the Results of a Twitter Search using PowerShell and SQL (part 2)
I’ve expanded a little on my Twitter project. (See part 1 here.) I adjusted the PowerShell script to page through the data going back as far as Twitter holds the data. There is still a lot to be done. Left … Continue reading
Posted in PowerShell, SQL
Tagged data, database, demos, PowerShell, rdbms, script, scripting, sql, sql server, Twitter
1 Comment