Corporate Career Progression
Today Steve looks at the career paths that might, or might not, exist inside an organization.
Monitoring Amazon RDS SQL Servers to Optimize Performance and Manage Costs
Israel Valverde explains the triple benefits of extending SQL Monitor to cover your SQL Server instances running on Amazon RDS, in terms of SQL Server performance optimization, controlling AWS-hosting costs, and in having a single, unified view of the health of all your SQL Servers, regardless of where they are hosted.
SQL Server REPLACE
In this article we look at the SQL Server REPLACE function and show several examples of how this can be used to replace text values in strings.
Goodbye to PASS
On December 17, the PASS organization announced the news that it would cease operations on January 15, 2021. Since the announcement, folks have been scrambling to figure out how to keep their user groups and events going or downloading recordings. By the way, if you need assistance with your user group, please reach out to […]
Azure DWH part 14: PolyBase to access to Non relational data
In this article, we will learn how to work with PolyBase using Azure SQL DWH.
Merry Christmas 2020
Merry Christmas today. Happy Holidays to all of you, for whichever holiday you celebrate this time of year. It's been a long, hard year, but I hope you are healthy and happy as we close out 2020. Hopefully next year is more enjoyable for all of us.
Stored Procedure in SQL Server with R Code
In this article we will explore how to create custom stored procedures using R which is basically an R function that can be called from a SQL Server stored procedure.
Deep Learning with GPU Acceleration
Deep Learning theories have been around for many decades, but solutions have not always been practical due to hardware constraints. In this article, Shree Das explains how GPU Acceleration can help organisations take advantage of Deep Learning to speed up training of neural networks.
Download SQL Patch Info
This article shows how to download sqlserverbuilds.blogspot.com to build your own automated sql patch level check.
Blogs
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
Forums
Compatibility levels on database changing them and impacts.
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers