Queries to Monitor SQL Server Replication Backlog
When replicating data to other servers it is always a concern that the subscribers may be far behind. Check out these queries to help monitor SQL Server replication row counts.
Tim consults for FinTek Development and teaches the course Automating ETL on Udemy. He's worked with technology since high school, helping his school win its first TCEA award and continues to work in automation, data architecture, back-end development, and smart contract architecture. Tim enjoys testing new technologies early in the diffusion of innovation curve and was an early adopter of NoSQL and smart contract development. He has a blog at http://www.fintekdev.com/ and helps contribute to local technical and financial events in Texas.
Automate file cleanup on SQL Server drives using PowerShell
Learn about a technique to use configuration tables with PowerShell for SQL Server drive management to monitor archive files, delete old backups and more.
Queries To Debug SQL Server Replication Issues
This tip provides some quick queries to get started when a replication issue arises that may help minimize the amount of troubleshooting time.
Using PowerShell To Record SQL Server Virtual Log File (VLF) Growth
Read this tip to learn how to use PowerShell to collect VLF (virtual log file) counts for all databases on all SQL servers.
Using PowerShell for SQL Server Replication Tracking
Learn how to track SQL Server snapshot and transactional replication counts for sources and destinations with PowerShell to determine discrepancies.
Handling error converting data type varchar to numeric in SQL Server
Error converting data type varchar to numeric may occur when trying to import data that looks like numbers, but doesn't act like a number. Read how to solve this issue.
PowerShell and ADO.NET Connection String Settings for SQL Server
Learn how to handle certain PowerShell connection issues when connecting to SQL Server.
Troubleshoot SQL Azure Bacpac Import Failures
Learn how to Troubleshoot SQL Azure Bacpac Import Failures including Data plan execution failed with message One or more errors occurred and An error occurred during deployment plan generation. Deployment cannot continue.
Using SMO With PowerShell To Obtain SQL Server Job Information
Scripting SQL Server Agent Jobs is useful for backups, disaster recovery or saving revisions and in this tip we will look how to do this with PowerShell.
SQL Server Archive and Data Retention Considerations
Learn about SQL Server Archive and Data Retention Considerations in terms of preliminary questions, archived data usage frequency, automate the data archiving process, the data archive time frame and more.
Automate Azure File Uploads and File Deletes With PowerShell
This tip includes PowerShell scripts and examples to help you automate Azure file uploads and file deletes as well as options to enhance the scripts.
Caution – Azure SQL Version 12 Restore Times Take Longer
We recently updated SQL Azure version 11 databases to version 12. After doing so, we noticed issues with point in time restores taking longer than they did in version 11.
Reading Text Files With PowerShell For Configurations Part I
Using text files for configurations can be especially useful in some environments, to avoid re-use or long arrays with many elements in them. Can we use PowerShell with a configuration text file, where we could extract the contents of the file and then us
Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell
We have moved some of our SQL Server databases to Azure and we want to do periodic checks to make sure the databases are responsive. We want to setup a scheduled heartbeat check against the Azure databases. Check out this tip to learn more.
Automate Retrieving SQL Azure Bacpacs With PowerShell
We would like to store backups of Azure databases locally, for both local testing as well as possible disaster recovery. Can we use the SMO library with Azure-SQL and is it possible to automate this with PowerShell?
Troubleshooting Common SQL Server Bulk Insert Errors
The following tip addresses some of the questions I get asked about using bulk insert as an ETL tool.
How To Calculate Behavioral Streaks in SQL Server Data
One popular question I receive from either gamers or traders is how to measure a behavioral streak with SQL Server data? In some cases, these clients may not be tracking their measurements in a compatible manner, so this will also address the question, ho
Time Testing SQL Azure Point In Time Database Restores
We need to do a time test for restoring an Azure SQL database from a point in time. Can we automate this through PowerShell and what guidelines would you recommend?
Interview Questions for Hiring PowerShell Database Developers
We're looking to hire a database developer with PowerShell skills. We want to know: what are some good questions to ask to identify good candidates? Can you provide any suggestions?
Consider New Ideas for SQL Server Data Analysis
One of the most popular questions I've been asked relates to how we look at data. Most are derivatives of the question, What are some other ways I can look at these data, whether that's in the form of other dimensions, correlations, comparable data sets
Verify SQL Server Backups Existence in the File System with PowerShell
We recently discovered that on some days, we don't have the full database backups that we should for each SQL Server instance. Apparently, the application terminates, but never notifies us that it failed. We verify backups as often as we can in our restri
Using PowerShell With Configuration Tables in SQL Server
I have a need to run the same processes on multiple SQL Servers and I want to use PowerShell, but I also want to pass in values from a configuration table to make this dynamic. In this tip we will look at an example of using PowerShell with configuration
Executing scripts on multiple servers by SQL Server version and edition using PowerShell
I maintain different SQL Server environments by version and was curious if you had any useful approaches to automating and obtaining scripts depending on the version of SQL Server. In this tip we show how to use PowerShell to help identify what scripts t
Extracting API Data Using PowerShell and Loading into SQL Server
We'd like to minimize using third party tools to extract data from APIs to load into SQL Server and wanted to know if we could implement solutions with PowerShell without too much overhead.