About
This blog is mostly about my work, but expect an occasional home project, productivity tip and tooling review.Search
Categories
- Conference (20)
- Development (208)
- Security (17)
- Test (32)
- Tooling (166)
- Uncategorized (167)
Most used tags
Tag Archives: sqlserver
EF query optimisation
We have a view that is very slow when you don’t use a filter on the name field. Everywhere in our stored procedures and (sub)queries we have this applied. In our web applicatie we use Entity Framework. The business layer … Continue reading
Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server
We use SSIS packages to import files. These SSIS packages are run with sqljobs. During deployment the sqljobs are created with a script. That is the plan. While running the script to create the sqljobs we got an error: Error … Continue reading
Start-SqlJobAndWait
We have some SqlJobs that we run in our regression tests. To automate this we need something that can start the job and wait for it to finish. Based on this post we know we need to poll the sysjobhistory … Continue reading