Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Earlier sql server was having diagnoses tool.
Default trace.
SQLDiag
And other tools but could not...
2012-05-24
1,424 reads
Denali – Day 23: Data Quality Services(DQS)
Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data...
2012-05-23
1,452 reads
Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
As stated earlier on blog on “LocalDB” discussion, developers are involved...
2012-05-22
904 reads
Denali – Day 21: Security
Security wise Microsoft sql server is going great and on compare with other RDBMS in the market...
2012-05-21
776 reads
Denali – Day 20: More Programmability Feature
Native XML Web Services (SOAP/HTTP endpoints) is Removed:
Earlier version of sql server support Web services...
2012-05-20
926 reads
Denali – Day 19: Programmability Feature -T-Sql
ORDER BY .. OFFSET and FETCH :mysql LIMIT (srno ):
OFFSET is a location of the rows...
2012-05-19
1,018 reads
Denali – Day 18: Engine: Express LocalDB–Command line
Express LocalDB is an express edition with minimum files required to start sql server...
2012-05-18
1,954 reads
Denali – Day 17: Distributed Replay
Distribution replay a new command prompt utility provided by Denali, this works same as Profiler Reply...
2012-05-17
1,025 reads
Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
As blogged on “Denali – Day 11: SSMS enhancement” about Features added on...
2012-05-16
812 reads
Denali – Day 15: Support for Windows Server Core
Windows Server Core: Microsoft Server has so many features which is not required...
2012-05-15
953 reads
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers