Build SQL Server CLR Triggers
In this article we look at how to create SQL Server triggers using Common Runtime Language (CLR) along with examples and a step-by-step guide.
DevOps 101 with Grant Fritchey
More and more organizations are turning to DevOps to improve the efficiency and quality of software delivery, and increase value to their business. But what exactly is DevOps and what does it mean for you and your organization?
Disaster Recovery in Another Region
Years ago I worked at a large company, and we purchased a SAN appliance to consolidate our storage. This was at a time when the majority of our servers used locally attached storage. This was a big purchase, and we knew that we had to plan for issues. So, we actually purchased two appliances and […]
An Active Job Search
Steve wants you to manage your career and actively find the job that is best for you.
Running SQL Server on Oracle and Google Cloud
In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.
ICYMI: What's behind the explosive growth in data?
In case you missed it: IDC’s recent Global DataSphere Forecast, 2021-2025, predicts that global data creation and replication will experience a compound annual growth rate (CAGR) of 23% over the forecast period. But what’s causing the growth? Where will all of that extra data be stored? And how should we, as data professionals, prepare for it?
Learn Python Complex Built-in Data Types including List, Tuple, Range, Dictionary and Set
In this article we present complex built-in data types in Python along with several examples of how to use complex data types.
SQL Log File Too Big
Is your SQL database log file too big? Maybe it is. But maybe it’s not. When log files keep growing and appear to be too big some might suggest switching to Simple recovery, shrinking the log file, and switching back to Full recovery. While this will work to shrink the file and free up disk […]
The NoSQL Rise and Fall
The NoSQL class of databases were very popular for awhile, but it seems many companies are sticking with an RDBMS in many cases.
"I started lobbying to just toss the tool aside."
In a total 180° turn, find out which Redgate product Grant Fritchey wanted to get rid of a few years ago, why he changed his mind and why it's now one of the reasons he is so proud to work at Redgate!
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers