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
248 reads
Blog Posts
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
817 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
23 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
23 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
185 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
174 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,012 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
284 reads
The Data Catalog from Redgate
One of the important tasks that is needed for any organization that wants to better protect their sensitive data is...
2018-12-17
353 reads
Why do we think water and databases are similar?
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup opening ceremony. That was also the year (1998) when...
2018-12-17
8 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers