(Jack Vamvas) Question: How can I iterate through a list of SQL Servers , extract the count of the databases , place into a powershell data table and get the database count sum for all the servers?
Tag: sql server
Python vs PowerShell for System and SQL Server Administration
(Siddharth Mehta) PowerShell is evolving as a task management framework in the Microsoft technology stack. As Microsoft started its adoption of open-source into different Microsoft products and platforms, PowerShell has also joined the open-source alliance and its supported on non-Microsoft platform
Writing and Testing Azure Functions with Function Monkey – Part 4
(James) Part 4 of my series on writing Azure Functions with Function Monkey is now available on YouTube:
Azure SQL Data Sync – Replicate data and schema changes between Azure SQL databases
(Ranga Babu) In this article, we will review how to configure the sync group to replicate data between Azure SQL databases using Azure SQL Data Sync.
SQL SERVER – DBCC CLONEDATABASE Error – Msg 2601: Cannot Insert Duplicate Key Row in Object ‘sys.sysowners’ With Unique Index ‘nc1’.
(Pinal Dave) A few days ago, I wrote a blog about an error while creating a clone of a database using DBCC CLONEDATABASE command. Here is the link to read that blog. SQL SERVER – DBCC CLONEDATABASE Error: Cannot Insert Duplicate Key Row In Object ‘sys.sysschobjs’ With Unique Index ‘clst’.
Creating Basic Greater Than Or Less Than Rules With Power BI Conditional Formatting
(Chris Webb) Although the conditional formatting by rules feature in Power BI was released a long time ago, one very common cause of confusion is with how to implement basic “greater than” or “less than” rules.
Short circuiting an AND
(Kenneth Fisher) The other day I did a post on how an OR short circuits. It was a somewhat unusual type of post for me in that I wasn’t really sure what was going on and was hoping for comments and reactions to help me clarify things.
How to read the SQL Server Database Transaction Log
(Manvendra Singh) Have you ever wondered how SQL Server tracks transactions and what information SQL Server captures in the transaction log file? In this tip we will take a look at a SQL Server function that you can use to read the transaction log to see what entries are made for database transacti
Implement DevOps One Step At a Time
(Grant Fritchey) In preparation for my upcoming DevOps training days (see the bottom of this post for details) and for some articles I’m working on, I’ve been building all new automation processes for database deployments.
Is Intel Doomed in the Server CPU Space?
(Glenn Berry) If you have been paying attention to the technology press over the past 12-18 months, you may have noticed a rather large number of negative stories about Intel’s processor business.