Data Analyst AI tool
See how ChatGPT can be used to analyze a dataset, produce charts, and train a model.
Deleting a Database
Who among us hasn't deleted a production data file? Steve hopes most of us have not.
Evaluating the Randomness of SQL Server Random Number Functions
Microsoft provides T-SQL developers with three functions (rand, newid, and crypt_gen_random) for generating random numbers. Each of these functions is effective at returning random values, but feature sets associated with each function make them best suited to different use cases. This tip’s Solution section presents an overview of common use cases for random numbers in SQL Server along with references to learn more about random numbers in SQL Server.
How Do You Know You Are Right?
I spend a significant amount of time working alone at my desk. I write articles, edit them, and share my opinions. However, I am constantly concerned about being wrong. How can I overcome this feeling? If this were a live session, I would eagerly listen to the answers to this question. Since it isn't, I […]
Database DevOps Recommendations
DevOps and databases aren't always considered compatible, but that is changing. DORA now has recommendations for database changes on their site.
Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD
Learn how to work with dates and calculate particular dates or elapsed time periods with some of the functions available in SQL Server.
Developer Time is More Valuable Than Ever
Today, Kendra Little talks about how DevOps adoption affects developer productivity and time.
Exploring the SQL Server CHOOSE Function
I preface a lot of what I write with whether or not it is for a “practical” use. One of the Simple Talk authors used this function in a forthcoming article. and I realized I hadn’t heard of it before (or I forgot about it… which is not completely unlikely.) The practical use was to generate some data and have at least a little variety to the values.
How Helpful is a GenAI Copilot
Steve looks at a trial using Microsoft's Copilot and how helpful it was for workers.
Level 6 of the Stairway to Synapse Analytics: Dedicated SQL Pool
This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.
Blogs
A New Word: Lookaback
By Steve Jones
lookaback– n. the chock of meeting back up with someone and learning that your...
Azure Vulnerability Assessments
Regarding managing databases in the cloud, security should never be an afterthought. That’s where...
Speaking at the NYC Lunch and Learn–May 23
By Steve Jones
In a couple of weeks, I’ll be in New York City for the Redgate...
Forums
Deleting a Database
Comments posted to this topic are about the item Deleting a Database
Data Analyst AI tool
Comments posted to this topic are about the item Data Analyst AI tool
Removing Log Shipping
Comments posted to this topic are about the item Removing Log Shipping
Question of the Day
Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers