Collect Data from Multiple Instances Using SSIS and Powershell
Use SSIS to pull data from multiple instances. Combine with powershell to run multiple instances simultaneously.
2015-02-23
7,502 reads
automation
Database Build Automation – The First Step to Continuous Integration
So you're keen to take the first steps to the continuous integration of your database. You have to start by getting your database into source control. You can then begin to automate your build processes in order to generate and test a database. By doing this regularly, you'll be much better prepared for the deployment process because you'll have solved integration issues when they happen, and facilitated the broader testing process.
2014-12-30
9,861 reads
Runbooks in SQL Azure
SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud” enabling automation of time consuming, repetitive tasks.
2014-12-02
5,401 reads
Database Configuration Management for SQL Server
It is not just the rapid and painless testing, deployment and update of databases that requires care in the retention and management of configuration information. Configuration information is also essential for audit, resilience, and support. The range of documentation varies widely with the database and its setting, but the underlying principles remain the same. Without appropriate configuration management, automation is likely to be futile.
2014-11-12
10,784 reads
Automating Red Gate SQL Compare with MSSQL Server Agent
How to compare two databases and email the results to every one who needs to know
2014-10-29
1,561 reads
Data Mining: Part 16 Automating Data Mining Processes
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
2014-09-08
2,910 reads
Data Mining: Part 16 Automating Data Mining Processes
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
2014-09-08
2,923 reads
Artist or Scientist?
In your work, are you an artist or a scientist? Steve Jones knows we need to be both, but when is each appropriate?
2021-02-03 (first published: 2014-08-19)
337 reads
Automate Your Central Management Server Registrations
Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.
2014-08-18
4,242 reads
Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS)
This tip looks at how to use a control file that lists the structure to use within SSMS and a PowerShell script that will automatically maintain the list of registered servers within SSMS.
2014-07-16
12,484 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers