What is the cloud? A beginner friendly guide: whose computers you rent, what changes for you, what stays your job, and common myths.
DEFAULT WITH VALUES: Fill Existing Rows on a New Column
DEFAULT WITH VALUES fills the rows that already exist when you add a column with a default. Without it, a nullable column keeps NULL in every old row. This post shows the three cases side by side, what a default never does, why the constraint needs a name, and how a large table takes the change in a millisecond.
SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice
An empty password on sa is a serious security failure. I stopped an e-commerce consultation after noticing passwordless administrator sign-ins.
Connections by Protocol: Shared Memory, TCP and Named Pipes
Connections by protocol tell you whether a client reaches SQL Server through shared memory, TCP or a named pipe, and from which address. This post reads the connection view for your own session, connects three ways to see each protocol, lists every connection with its host and program, and counts them by protocol.
User Statistics Report in SSMS: Who Is Connected
The User Statistics report in SSMS shows the users who are connected to a database. This post opens the report, answers the same question with a query over sys.dm_exec_sessions, and finds the one application that holds many sessions.
SSMS Command Line Options: Server, Database and Login
SSMS command line options open Management Studio already pointed at a server and a database. This post finds SSMS.exe, lists the switches that SSMS 22 documents in its own usage text, and shows how to turn them into a shortcut without saving a password.
Shaping Query Results as JSON With FOR JSON PATH
Shape FOR JSON PATH output with nested objects, child arrays, null options, and wrappers, then return one complete JSON value to clients.