This will give you a list of jobs that contain SSIS Packages should you have a project in which you may need to review changes to Packages.
2014-02-17 (first published: 2011-07-28)
1,737 reads
Sometimes logging onto a box for a simple change like this is not possible for the business. This allows you to change this directly from T-SQL without having to log on or RDP into the box.
2011-08-17 (first published: 2011-07-28)
455 reads
This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.
2011-08-08 (first published: 2011-07-28)
948 reads
These scripts will extract security for Windows Logins, Database Users, Roles, Objects and SQL Logins.
2011-08-03 (first published: 2011-07-28)
2,164 reads
2011-08-02 (first published: 2011-07-28)
3,003 reads
This will let you know which package had errors rather than sifting through all the package logs one by one.You just need to replace the date.
2008-06-23 (first published: 2008-05-20)
705 reads
The post The pros and cons of self-service BI: What every industry leader should...
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
insert into NewKms8081..members SELECT (select u2.Id from SecurityKms8081..users u2 join SecurityKms8081..Import_users_barghGharb i2 on i2.code_personeli=u2.PersonnelNumber...
I am running SQL Server 20.2. When I copy a query into the query...
Hi, i considered power bi with embedded for this. Not a big fan...
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers