Anyone Can Click Through Once
Using some sort of scripting or automation is important for your career.
2021-02-10
154 reads
Administration
2021-02-09
1,022 reads
2021-02-08
452 reads
Reassess Your Configuration
It's a good idea for anyone managing systems to periodically check them and see if anything needs to change.
2021-01-12
88 reads
A Need for Monitoring without Administration
A recent hack through a network monitoring system is scary, but Steve thinks that we ought to not require these systems to have privileged access.
2021-01-06
168 reads
2020-12-28
519 reads
Scheduling SQL Scripts Using Jenkins
Learn how a Jenkins server can be used to schedule SQL scripts to execute against SQL Server.
2020-12-22
27,591 reads
2020-12-14
594 reads
2020-11-30
507 reads
2020-11-27
551 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...