Rudy Panigas

Execution of Code on Multiple Servers Remotely

Do you have more than 10 sql servers you must manage? Most DBA s do, I have over 120 sql instances to manage. Before I used to use ISQL/OSQL in a batch to execute a command on all these instances. It works but not very nice. Below is the code I use to collect information […]

5 (1)

2006-12-28 (first published: )

737 reads


Why I Support Code Automation Tools Like ORMs


I know I’m a weirdo. I’ve always been a weirdo. When I was a...

#PowershellBasics: Run a file and pass it a parameter.


I realized in my last #PowershellBasics post that I was talking about running a...

SQL Undercover TV – Instant File Initialisation


Adrian has a look at the performance benefits of instant file initialisation Below is...

Read the latest Blogs


In-memory database


Hi, Currently i am processing records in SQL Server itself. Any recommended in-memory database,...

Replication CDC -- Cannot Truncate Table

By GonnaCatchIT

Dear All, We just enabled Replication services (CDC) on few of the databases. Now...

Verify Server online status using sql server query

By Rock

Team I have populated list of ServerName from the sql server query. I would...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers