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
279 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
76 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,538 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
381 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
143 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
362 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
101 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
311 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,301 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
297 reads
Blogs
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
Secure Your SQL Estate: Best Practices for Azure SQL Security
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Forums
Visual Studio SSIS Package Showing Up Blank
Hi all, this is my first time posting on this forum, thank you all...
MySQL 5.6 not writing any logs
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
How to resolve issue of custom Audit log table containing incorrect data?
We have created a parent table, child table & Audit log table in SQL...
Question of the Day
Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers