2017-10-05 (first published: 2017-10-02)
16,696 reads
Scripts
SQL Agent jobs that run SSIS packages
Lists the job names and package names for jobs that execute SSIS packages (for packages stored in msdb).
2017-09-13 (first published: 2017-09-05)
2,082 reads
Add new Databases to a AG Setup with PowerShell
Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.
2017-09-12 (first published: 2017-09-07)
1,002 reads
CDC watchdog for databases in AlwaysOn AG
Stored procedure to ensure CDC job will be started once failover happen.
2017-08-25 (first published: 2017-08-22)
820 reads
SQL Server Agent Jobs Statistics
This script will give you a thorough report about sql server jobs based on historical data.
2017-07-26 (first published: 2013-09-25)
2,193 reads
Script DB Level Permissions v4.3
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
15,539 reads
2017-07-24 (first published: 2017-07-12)
641 reads
Add a login to multiple SQL Servers
This is a simple powershell script that will add a particular login to multiple SQL Server instances in a go.
2017-07-19 (first published: 2017-07-04)
1,961 reads
2017-07-18 (first published: 2015-10-16)
1,768 reads
XML import from a Cross-tab Report
Source xml is a rendition of a cross-tab report. I show the evolution of a Spackle solution for import as a SQL resultset.
2017-06-08 (first published: 2017-06-01)
508 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Pasar Minggu Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Raya Pasar Minggu No.6, RT.6/RW.8, Kalibata, Kec. Pancoran, Kota Jakarta...
Alamat BCA KCP Pejaten Telp:0821-8200-203
Telp/WA 62 821-8200-203 Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No....
Alamat BCA KCP Tebet Timur Telp:0821-8200-174
Telp/WA 62 821-8200-174 Jl. Tebet Timur Dalam Raya Blok GG No. 97, RT.3/RW.6, Tebet...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers