Deploy an SSIS project to the SSIS catalog.
You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project...
2017-08-21
839 reads
SQLStudies
Creating an SSIS project
Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open...
2017-08-30 (first published: 2017-08-16)
1,892 reads
Installing the (currently) latest Data Tools
I’m working on a project right now and it’s going to require me not only to refresh my SSIS skills...
2017-08-14
528 reads
500 posts
Well, that’s something to be proud of. This is my 500th post on this blog. Not including a handful of...
2017-08-10
405 reads
Interview Patterns and Anti-Patterns Combined
It’s that time again. T-SQL Tuesday. The monthly blog party started by Adam Machanic (b/t) seven and a half years...
2017-08-08
383 reads
SQL Homework – August 2017 – Create a table
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month...
2017-08-02
416 reads
DBA Dice
I’ve always thought it would be fun to have a DBA themed magic 8-ball. Now you may not be aware...
2017-07-31
578 reads
Performance is bad. Did you change anything recently? No. Are you sure?
Ever have this conversation?
Dev: Hey, can you help me? The performance on my application is terrible all of a sudden.
DBA:...
2017-08-11 (first published: 2017-07-26)
3,196 reads
Default SQL Agent Reports – Top Jobs
Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several...
2017-07-24
458 reads
Default Database Reports – Disk Usage by Table
Every now and again you need to know how big a table is. Or several tables. Or all of the...
2017-08-03 (first published: 2017-07-19)
1,832 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?