Template Explorer (Day 18)
You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...
2018-01-18
281 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
Template Explorer (Day 18)
You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...
2018-01-18
80 reads
Template Variables (Day 7)
Do you have scripts that you need to run frequently, but every time you need to set some different parameters?...
2018-01-18 (first published: 2018-01-07)
1,544 reads
Add color to connections (Day 17)
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
383 reads
Add color to connections (Day 17)
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
148 reads
Assign a keyboard shortcut to menu items (Day 16)
You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode...
2018-01-16
364 reads
Assign a keyboard shortcut to menu items (Day 16)
You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode...
2018-01-16
105 reads
Query Shortcuts in SSMS (Day 15)
There are several shortcuts that can be assigned to run a stored procedure. Known as Query Shortcuts, these can be...
2018-01-15
315 reads
Split Screens (Day 2)
Have you ever wanted to see different parts of the same query window at the same time? Well, in SSMS,...
2018-01-15 (first published: 2018-01-02)
2,305 reads
Object Explorer Drag-N-Drop (Day 14)
Did you know that items in the Object Explorer can be dragged and dropped into a query window? This can...
2018-01-14
300 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers