2018-12-11
877 reads
Administration
Your SQL Servers Are Misconfigured...
It's probably not your fault, but relying on the defaults of a SQL Server installation might be impacting the performance of your instance.
2021-02-05 (first published: 2018-11-01)
7,125 reads
2018-10-26
717 reads
The Pesky Windows Power Plan Oh My
The below script will build a csv file for import of the servers Power Plan Setting.
2018-11-06 (first published: 2018-10-19)
524 reads
Solving the Target Principal Name is Incorrect
One small point to note when we receive the below error while connecting SQL server: The target principal name is incorrect. Cannot generate sspi context
2018-05-31
28,068 reads
How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
2018-04-23
3,713 reads
2018-04-16
899 reads
How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
2018-04-10
3,427 reads
2018-01-22
938 reads
2017-12-04
774 reads
Blogs
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
Forums
CHECKDB (TEMPDB FULL)
It's been donkeys years since this has happened to me, but I cannot remember...
clean up accounts
EXEC sp_validatelogins <- Can we use this as a start to identify accounts in...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers