SQL Server Synonyms
SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the many reasons to consider using them.
SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the many reasons to consider using them.
As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
Learn how to orchestrate your Databricks notebooks through Azure Data Factory in this article with a step by step walkthrough.
Phil Factor's manual for taming machines, applications, and other wild beasts.
Steve asks what you might want to achieve or accomplish in your career.
Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates
The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.
Apache TinkerPop is an open source graph computing framework. A graph computing network is a set of vertices and edges in the network. If we compare a graph database to traditional relational databases, we can assume that every row in a table of a relational database is equivalent to a vertex in graph network. Similarly, […]
Are computers getting smart enough to pass the Turing test or are humans getting worse at representing themselves as intelligent?
As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
I'm trying to get this string_agg to put all the 'comments' into one result...
Comments posted to this topic are about the item Vectors in SQL Server 2025
Comments posted to this topic are about the item Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers