Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-10-11
287 reads
Si vis pacem, para sql
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
746 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
18 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
37 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
294 reads
Be a good administrator
Administering SQL ServerBelow are the topics every Administrator has to keep up with.Backup / Restore:Understand the backup / restore options SQL Server...
2016-09-19
190 reads
Be a good administrator
Below are the topics every Administrator has to keep up with. Backup / Restore: Understand the backup / restore options SQL Server provides for you. Implement those on your...
2016-09-19
10 reads
Be a good administrator
Below are the topics every Administrator has to keep up with. Backup / Restore: Understand the backup / restore options SQL Server provides for you. Implement those on your...
2016-09-19
10 reads
Be a good administrator
Below are the topics every Administrator has to keep up with.
Backup / Restore:
Understand the backup / restore options SQL Server provides for...
2016-09-19
189 reads
Target Recovery Interval and Indirect Checkpoint
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log...
2016-07-12
53 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers