Azure SQL Database DTU Versus vCore
I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At...
2018-12-17
878 reads
Blog Posts
Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell
30/11/2018 – Function has been updated to deal with named instances.
Last week the Tiger Team released their Availability Group Failover Detection...
2018-12-17 (first published: 2018-11-28)
1,999 reads
How to automatically Discover SQL Server instances
DBAs have plenty of day-to-day tasks to do as part of the administration, but one overarching task is managing the...
2018-12-17
254 reads
MongoDB – Basic
MongoDB is a great Database NOSQL and easy to use and learn. if you know java scripting and database concept...
2018-12-17
828 reads
PowerShell Multithreading with PoshRSJob
Intro PowerShell has had a native method for spawning multiple “threads” ever since I can remember, in the form of the *-Job functions. They work OK, but there are...
2018-12-17
39 reads
Processing Multiple Files in SSIS with the Foreach Loop
Yesterday I wrote about the little-known but still useful multiple flat file connection manager. In this post, I will briefly...
2018-12-17
196 reads
Processing Multiple Files in SSIS with the Foreach Loop
Yesterday I wrote about the little-known but still useful multiple flat file connection manager. In this post, I will briefly show a more commonly used alternative approach for processing...
2018-12-17
29 reads
Redgate Reviews 2018, Predicts 2019
Our boss came to us and said, “We need one more webinar to round out the year.” Well, we’re just...
2018-12-17
178 reads
Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error...
2018-12-17
1,033 reads
SQL Server services will not start automatically after server reboots
This blog post is about a situation where after windows patching the SQL Server service and SQL Server Agent services...
2018-12-17
324 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers