SQL Server: Time To Switch Schema Of All Objects Away From “dbo”

What are Schemas for? All of you are familiar with the default and built-in schema "dbo". When you create an object without a schema, "dbo" becomes the schema for the object. Generally, it is NOT considered a good practice from a manageability or security perspective to have everything owned by "dbo".  The alternative is to …

Advertisement

Oracle – Fastest Way To Execute SQL Is? To, Not Execute It! – Query Result Cache – Part II

Before you read on, please check out my related post on "Function Result Cache". You may find it valuable in this context. Conversation sounds familiar? I am sure you have been privy to a conversation like this between an IT manager and a DBA: Manager:  My query is extremely slow. Can you make the query …

PowerShell: CTRL+E, instead of F8 for SQL folks to run selection in ISE

Hotkey to run selection in PowerShell ISE is F8. Hotkey to run selection in SSMS is CTRL+E. For those of us constantly switching back and forth between the two, you know very well how many times we hit the "other" hotkey! Well, now you can have the same key to run selection in both SSMS …