The convenience, competitive pricing, resiliency, and ease of maintenance of the SQL Database Platform as a Service (PaaS) offering hosted on the Microsoft Azure platform are partially offset by a lack of support for some of the features. These limitations can be eliminated by taking advantage of the Microsoft Azure IaaS capabilities and installing a SQL Server instance in an Azure-hosted VM.
Providing support for your manager or boss in getting his or her job is a good thing. Steve Jones comments on what benefits you might get and why this could enhance your career.
As you may have noticed, we have been suffering recently from increased spam posts on the forums. This is something we're currently working to resolve.
Alex and his team are developing a game about software and some of the people who make it. He looks at how games affected his office culture, what he’s learned about designing games to do more than just be fun, and how his team are hoping to share their passion with the developer community.
Over the years I've had many discussions with other SQL Server Database Administrators as to whether or not you should have the database buffer pool loaded with data pages or empty when testing queries for performance. This tip will take a look at the effects on query performance for both cases by using the DBCC DROPCLEANBUFFERS statement to empty the buffer pool.
This is an introduction to the SQL Server Microsoft Linear Regression Algorithm.
This is an introduction to the SQL Server Microsoft Linear Regression Algorithm.
Are you in a rut? Feeling a bit bored at work writing the same ole code? Or perhaps you need a job and only wish you could be bored "at work"!
In the grand finale to Michael Sorens' series of PowerShell one-liners, we come to the handling of data, reading it in and writing it out, whether by files; input/output streams or a database. It shows how it can be done in a variety of formats including CSV, JSON, and XML.
If the level cloud storage encryption are so high, then why is the cloud security industry experiencing such distrust?
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