Fixing a SQL Server That Wont Start Due To Max Memory Being Set Too Low
I recently came up against a SQL Server instance that wouldnt start, after going through the event log the reason...
2017-08-09
242 reads
SQLCLR vs. SQL Server 2017, Part 2: “CLR strict security” – Solution 1
As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...
2017-08-09
971 reads
Getting Started with GitHub for dbatools
I’ve recently started contributing to the dbatools project and it’s all done through GitHub. Prior to this, I’d never used git and GitHub for anything more than an offsite...
2017-08-09
10 reads
Exploring SQL Server With Powershell And SMO Basics
SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You get to work with database objects as in...
2017-08-09
17 reads
Exploring SQL Server With Powershell And SMO Basics
SqlServer Powershell Cmdlets 2017 - Initialize Look Diving into the Sql Server Management Objects library can be a pretty interesting process. You get to work with database objects as...
2017-08-09
29 reads
Exploring SQL Server With Powershell And SMO Basics
SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You...
2017-08-08
1,391 reads
TSQL Tuesday #93: 2 Job Interviews
T-SQL Tuesday #93
I decided to join the T-SQL Tuesday blog series that Kendra Little is leading this month, on the...
2017-08-08
571 reads
I Hate Interviews – TSQL2sDay
This month’s T-SQL Tuesday is hosted by Kendra Little and is on the topic of interviews
I hate interviews as an interviewee....
2017-08-08
524 reads
SQL Server on Linux Series: Backing up over the network
One of the challenges with any SQL Server business continuity strategy is backing up your databases and logs on a...
2017-08-08
572 reads
Power BI – Problem, Design, Solution (Text Search Slicer)
There is a video that walks you through the solution in depth, please find the video at the end of...
2017-08-08
672 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers