tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]
It can be a daunting task for new users to get to grips with PostgreSQL documentation, particularly if you are not from a developer background.
If you are not sure where to start, we are here to help break down the different resources available so you can make the most of them.
In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover:
- How to navigate PostgreSQL documentation
- The essential things you need to know about PostgreSQL documentation
- Other useful learning resources to help make your journey to using PostgreSQL easier
Register to join us on September 19th at 11am CT (5pm BST)
A query is sometimes super fast and sometimes very slow. One of the main reasons for this problem is Parameter Sniffing. There are several approaches to addressing the Parameter Sniffing issue and this article discusses effective methods for handling Parameter Sniffing in SELECT statements containing a TOP clause.
In 2012, Aaron Bertrand said most everything I knew (and a bit more) about the issues with using the sp_ prefix. Procedures prefixed with sp_ have special powers when placed in the the master database in that it can be executed anywhere on the server after that.
I've been traveling in Europe this week, partially for holiday and partially for work. It's been a nice break, and it's always interesting to experience the world in different places, away from the United States where I've spent most of my life. I get to come often, and I enjoy the experience, but I'm sometimes […]
Steve notes some advice from someone that he found useful and helpful to become a better person in life.
SQL databases are crucial for businesses, so it's critical to back them up. A dependable and affordable option is offered by Azure Blob Storage. Let's examine the advantages, the steps involved in backing up to and restoring from a device, recommended practices, and more.
In this tip, we will discuss the process of generating test data to verify query logic without relying on real-life data, along with some helpful guidelines. We will also cover various scenarios and their corresponding solutions.
The PASS Data Community Summit is back in Seattle this November, with hundreds of speakers covering a wide variety of database topics, including cloud computing. We feature two of those speakers in this webinar: Bob Ward of Microsoft and Steve Jones of Redgate.
By Steve Jones
If it fails where you thought it would fail that is not a failure....
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
Comments posted to this topic are about the item A Place where AI Technology...
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers