-
Recent Posts
Archives
Categories
Meta
-
Join 202 other subscribers
RSS
Tag Archives: sql server
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
T-SQL Tuesday # 13 – Asking the business good questions
Fatherhood involves more than just having dried food on your shirt. People expect you to do crazy things like wave your arms like a muppet or impart wisdom to the next generation. I don’t know that I have much wisdom … Continue reading
Posted in Business, Life, Parenthood
Tagged business, life, questions, sql, sql server, t-sql tuesday
3 Comments
Generating Random Data for Testing
Recently I was faced with the need to generate lots of data for a presentation. There is a temptation in situations like this to grab some data from a production system and obfuscate it somehow. My advice to you is … Continue reading
Posted in Testing
Tagged data, database, demos, rdbms, security, sql, sql server, testing
6 Comments