How are you navigating the database landscape? Our latest report sheds light on the current state of database management and offers valuable insights into how organizations can navigate and simplify the growing complexities of the database landscape.
2025-04-18 (first published: 2025-03-10)
There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity.
2025-03-07
There was a post on X I read today about valuing your time. The gist was that since this person had waited 9 minutes to save $4, they valued their time at $27 an hour. I get the point being made. Time is valuable and you need to set the value of your time. It […]
2025-03-01
87 reads
Learn how to emulate Azure storage for files, blogs, and queues.
2025-02-24
1,721 reads
See a walkthrough of setting up a maintenance plan in SQL Server.
2025-02-21
4,164 reads
Learn how to recover a database from a missing or corrupt transaction log file.
2025-02-19
9,380 reads
I just saw one of "those" questions. You know the ones: 'We're hitting an error with a stored procedure. What is the maximum number of parameters you can have?" <sigh> Look, I get it. Breaking the land speed record is cool. Getting the most people into a phone booth (look it up), also cool. Fastest, […]
2025-02-15
133 reads
As organizations move to the cloud, the once essential role of the Database Administrator (DBA) as the guardian of system optimization, has been overshadowed, often viewed as a bottleneck to innovation. Yet, as technology evolves, the one thing I know is history repeats itself, and optimization skills are once again emerging as a critical necessity. […]
2025-02-01
102 reads
Introduction JSON (JavaScript Object Notation) has become a popular data format for storing and exchanging information. Microsoft SQL Server, starting from version 2016, introduced built-in support for JSON, allowing developers to work with JSON data more efficiently within the relational database environment. This article will explore how to store, retrieve, and manipulate JSON data in […]
2025-01-31
16,227 reads
In my family’s history of the past 10+ years, we have become well versed in nagging, ongoing, non-debilitating pain. In some ways, the lessons we have learned about physical pain correlate all too well to the types of pain that we technical people are involved with daily. But there is a huge difference, even if […]
2025-01-25
81 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers