The speed, flexibility and collaboration of DevOps can be difficult to achieve against the rigid schemas, manual processes, and silos in the world of data management. Join Microsoft Data Platform MVP, Grant Fritchey to discover the key strategies you can implement to bridge the divide between data management and DevOps in your organization.
2020-11-11
In this article we take a look at using GUID columns in your SQL Server database tables and the impact GUID columns may have on indexing.
2020-11-11
Well tuned storage is essential for SQL Server performance. In this article, Robert Sheldon explains the metrics that are important to watch.
2020-11-10
Redgate are Gold sponsors of PASS Virtual Summit, which this year is available to all online. It's time to accelerate your data career by joining Redgate's Advocates who will be presenting a variety of sessions, as well as demo solutions throughout the week of 11 - 13 November. See what's happening and register today.
2020-11-09 (first published: 2020-11-03)
In this article we walk through how to build a SQL Server Reporting Services report based on database level security settings by user to show different results to each user that runs the report.
2020-11-09
Redgate have launched their very own Online SQL Formatter powered by SQL Prompt. Visit the page here to try formatting your SQL code with a few pre-defined styles, or find out how to create and share your own styles with SQL Prompt.
2020-11-06 (first published: 2020-10-30)
In this article we look at how you can easily build virtual desktops that you can deploy to your teams using Amazon WorkSpaces.
2020-11-06
Phil Factor answers some questions you've been itching to ask about SQL Prompt, covering ranked code completion suggestions and auto-fixing SQL code smells, and suggesting where in the tool to find other nuggets of hidden treasure.
2020-11-06
In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.
2020-11-05
In this tip we walk through an exercise of developing a data model based on the characteristics of the data requirements.
2020-11-04
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