Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
As blogged on “Denali – Day 11: SSMS enhancement” about Features added on...
2012-05-16
818 reads
Vinay Thakur
Denali – Day 15: Support for Windows Server Core
Denali – Day 15: Support for Windows Server Core
Windows Server Core: Microsoft Server has so many features which is not required...
2012-05-15
958 reads
Denali – Day 14: New DMV & DMF
Denali – Day 14: New DMV & DMF
As there has been so many DMV/DMF already introduced in earlier version of Sql server,...
2012-05-14
743 reads
Denali – Day 13: FileTable
Denali – Day 12: FileTable
“FileStream” is introduced in sql server 2008, for storing BLOB data like varbinary(max), it is integrated...
2012-05-13
896 reads
Denali – Day 12: More Manageability Features
Denali – Day 12: – More Manageability Features:
-K switch
With new feature added in an engine to use that feature with different way...
2012-05-12
1,199 reads
Denali — Day 11: SSMS enhancement
Denali — Day 11: SSMS enhancement
SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA...
2012-05-11
668 reads
Denali — Day 10: Sequence object
Denali – Day 10: Sequence object
Sequence is an object introduced in Denali, this is similar to ORACLE sequence, earlier sql server...
2012-05-10
1,271 reads
Denali — Day 9: Additional Scalability Features
Denali – Day 9: Additional Scalability Features
15,000 Partitions earlier it was 1000For the enterprise system having huge amount of data to...
2012-05-09
494 reads
Denali — Day 8: Startup Parameter
Denali – Day 8: Startup Parameter
Startup Parameters means you are providing the parameter to sql server at the start of sql...
2012-05-08
759 reads
Denali — Day 7: Contained Database
Denali – Day 7 : Contained Database
Contained database is another new feature for sql server 2012 – Denali, earlier version has a big...
2012-05-07
1,219 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers