Rename a Server with PowerShell
I’m sure many people are experimenting with VMs and SQL Server. If you’re like me, many of you just default...
2016-10-03
1,593 reads
Correlated Datetime Columns
SQL Server is a deep and complex product. There’s always more to learn. For example, I had never heard of...
2016-10-13 (first published: 2016-10-03)
1,811 reads
Mastering Index – Clustered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Clustered Index. Take...
2016-10-03
525 reads
Becoming a Microsoft MVP
I was awarded the Microsoft MVP (data platform) award on Saturday.
On the four days a year (one per quarter) when...
2016-10-03
646 reads
Future DBA – Big Data -MongoDB 1
We have discussed hadoop and its HDFS management tools for big data system, which works horizontal scaling for data distribution...
2016-10-03
488 reads
Query Store – Quick Tour
The query store, Borko Novakovic Senior Program Manager from Microsoft calls this feature “Similar to an airplane’s flight data recorder”....
2016-10-03
459 reads
Changing SQL Server name
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...
2016-10-02
752 reads
An observation about Unicode in SQL Server Management Studio
A week or so ago I read a blog post and tweet about using an emoji in SQL Server. This...
2016-10-14 (first published: 2016-10-02)
2,263 reads
Changing SQL Server name
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...
2016-10-02
38 reads
Changing SQL Server name
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...
2016-10-02
19 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers