When Was SQL Server Last Restarted? – Interview Question of the Week #225
Question: When Was SQL Server Last Restarted?
First appeared on When Was SQL Server Last Restarted? – Interview Question of the Week #225
2019-05-20
Administration
A Self-Serve System to Refresh Databases (Part 3)
This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.
2019-05-16
2,949 reads
Underused sp_WhoIsActive capabilities: @delta_interval
Great Ghost In the last post, we looked at how to see if your query is misbehaving, or if things…
2019-05-10
Log File Expansion Automation
SQL Server Database Log file expansion can be fairly tedious if you need to make the log bigger in many reasonably-sized growth increments. It can be tedious because you...
2019-05-10
Access is denied – Using DTCPing utility between two Windows Server 2016
Few days ago a client requested the configuration of MSDTC (Microsoft Distributed Transaction Coordinator). NOTE: If you want to know more about it here is a nice FAQ from...
The...
2019-05-10
Life behind a proxy server: downloading content for SSMS Help Viewer
Life behind a proxy server can be problematic. Not every software out there is tested correctly for proxy interaction and oftentimes the experience for the corporate user is a...
The...
2019-05-09
Underused sp_WhoIsActive capabilities: @get_avg_time
Ablazemalls Look, it’s impressive enough that sp_WhoIsActive works as well as it does. Most people who’ve been using it for…
2019-05-09
Why is my log file not shrinking when I do regular backups?
I often times get the question similar to “Why is my log file not shrinking when I do regular backups”? It goes to show there the functionality of the...
2019-05-08
Unable to Start Execution – Login Doesn’t have Permissions to use the Proxy
Proxy accounts for PowerShell, SSIS, and Operating System (CmdExec) job steps are instrumental when performing certain actions in SQL Server Agent. Once you’ve set up a proxy, and configured...
2019-05-08
Default Backups and Feature Awareness
Default backup schemes for databases would be a nice enhancement.
2019-05-08
257 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers