This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.
Phil Factor demonstrates some PowerShell tasks that will produce a high-level overview, or narrative, of the main differences in the metadata between two versions of a database, during Flyway Teams migrations.
Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
Every year I'm responsible for a portion of the Database Weekly newsletters. I used to do half, but right now Kathi, Grant, and I are on a rotation. Our boss puts out a schedule each year, which tells me the weeks for which I am responsible. Each January I then set up a recurring appointment […]
Introduction This article will introduce you to the SQL Server Dacpac in Azure Data Studio. We will also learn about the Bacpac. In the Azure Data Studio, we have an extension named SQL Server Dacpac which allows us to deploy, extract Dacpacs, create a database from a Bacpac and export a schema and data to […]
In this article we look at how to add the zoom feature to your charts and graphs in Power BI reports for a better user experience.
Got wanderlust? We thought it would be fun to look at where the best place to live in the world is as a DBA. Find the winners and weigh in on the debate here!
Some of the most problematic T-SQL code I’ve seen over the years originated because the developer approached T-SQL with techniques more suitable for developing applications. I often saw these issues in my consulting days and always took the opportunity to teach the customer instead of only fixing the problems. One reason is that SQL is […]
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Spring Connections and Learning at...
How do I easily get the next 12 sequence values from a sequence object?
See possible answers