Dynamic Management Views: Changes in SQL Server 2012
There were many new DMVs added in SQL Server 2012, and some that have changed since SQL Server 2008 R2. This is a brief overview of the biggest changes and what they mean to you!
There were many new DMVs added in SQL Server 2012, and some that have changed since SQL Server 2008 R2. This is a brief overview of the biggest changes and what they mean to you!
SQL Bits is only two weeks away! Join us for the free community day on July 19th, there is also a paid-for pre-conference day on July 17, as well as a paid-for special training day on July 18. There are a whole host of great speakers, including Grant Fritchey, Steve Jones, and David Atkinson (and Brent Ozar, and Benjamin Nevarez, and Karen Lopez...you get the idea). Register while space is available.
There are some aspects of tables in SQL Server that a lot of people get wrong, purely because they seem so obvious that one feels embarrassed about asking questions. Robert Sheldon reckons that no questions about SQL Tables are off-limits, and deserve frank answers.
In the next level of the Stairway to Biml, we breakdown the various elements in a Biml file to help you understand what parts of the files are used to control the package generation.
Phil Factor fluffs the feathers of the shared sandbox model of development.
Source control will allow you to maintain branches in the development of your database, but the subsequent merge isn't pain-free. How can the database developer support the rapid development and delivery of features in an application? Versioning, branching and merging is part of the solution, but what about the rest of the solution?
Today we have a guest editorial from Sarah Wagner that thanks all the people that have helped her become a better DBA.
Here is a short How To article on querying for permissions in a SQL Server database
Since many environments haven't committed to using a source control system, identifying mismatched objects can offer a challenge. Tim Smith offers a solution.
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