It’s That Time Again
“It’s the most wonderful time of the year…”
No, not the end-of-year festival of repetitive music, overeating, and trampling on other...
2014-10-31
1,025 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
Resolving SSDT-BI Installation with IsVisualStudio2012ProInstalled() error
Recently I was building a new virtual machine for presentations, and loaded up my usual battery – Windows 7, SQL Server...
2014-09-24 (first published: 2014-09-22)
6,465 reads
Four things I wish I’d known back then
In the blogging meme of the day, I was tagged by my friend Tim Costello to share four things I...
2014-09-05 (first published: 2014-08-28)
8,200 reads
Mile High Tech Con
There’s a brand new business intelligence conference launching next month in Denver, Colorado. The Mile High Tech Con is a...
2014-06-27
1,238 reads
SSIS Parent-Child Architecture in Package Deployment Mode
This is the second in a series of posts about SSIS parent-child architecture. You can find the index page here.
In...
2014-06-26
6,002 reads
Speaking at the SQL PASS 2014 Summit
I’m happy to announce that I will be speaking at the SQL PASS Summit this fall. The summit will be...
2014-06-25
835 reads
Upcoming Presentations in May
Next month, I’ll be making a couple of stops at SQL Saturday events in the south. On May 3, I’ll...
2014-04-18
758 reads
SQL Saturday Lisbon
It’s a little over a week until this year’s SQL Saturday festivities kick off in Lisbon, Portugal, and I’m very...
2014-04-01
705 reads
Lunch with someone new
I met up for lunch with a good friend and former coworker today, and among the topics of discussion was...
2014-02-19
839 reads
Parent-Child SSIS Architecture
This is the first in a series of technical posts on using parent-child architectures in SQL Server Integration Services. The...
2014-02-07
2,193 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
How do you keep track of the purpose for SQL Logins?
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers