-
Recent Posts
- SQL Server install fails due to SQL Browser not starting
- Broaden your vision
- Data Modeling, Conciseness and Philosophy
- Importing Column Documentation from a CSV into a Sybase PowerDesigner Data Model
- SSRS report throws an error that says a parameter doesn’t exist when the report designer clearly shows the parameter exists
Archives
Categories
Meta
RSS
Author Archives: Richard
Broaden your vision
Where there is no vision, the people perish (Proverbs 29:18A, KJV) It’s old wisdom but still valid. When you have no direction you flounder and sometimes the people around you flounder, too. This is true in the tech world as … Continue reading
Posted in Business, Data Modeling, Life, PowerShell, spirit, Sybase PowerDesigner, Tools, Uncategorized
Tagged data modeling, PowerShell, spirit, vision
Leave a comment
Data Modeling, Conciseness and Philosophy
Graeme Simsion and Graham Witt use the term conciseness to describe one of the most interesting aspects of a data model. Simsion and Witt write that a good data model implicitly defines a whole set of screens, reports and processes … Continue reading
Posted in Data Modeling, Life, Uncategorized
Tagged conciceness, data modeling, philosophy
Leave a comment
Importing Column Documentation from a CSV into a Sybase PowerDesigner Data Model
I’m a big fan of data modeling tools. I used to chafe against them as so often it was easier for me to think in code. But the advantages of using tools like E/R Studio, Toad Data Modeler and Sybase … Continue reading
Posted in Data Modeling, PowerShell, Sybase PowerDesigner, Tools, Uncategorized
3 Comments
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
Who needs people?
Whoever isolates himself seeks his own desire; he breaks out against all sound judgment. Proverbs 18:1 Last week I wrote a bit about parenthood. I’ve been dwelling a lot on fatherhood and that’s forced me to take a good look … Continue reading
Downloading the results of a Twitter Search using PowerShell
I’m trying to learn PowerShell because I need to automate some things. I was a little skeptical about all the hype surrounding PowerShell. What could it possibly do the Perl didn’t? But I knew it integrated really well with .NET … Continue reading
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
