How To Gain Access To SQL Server When No DBA
When I showed a draft of this article to a friend of mine, to...
2023-10-11 (first published: 2023-09-22)
893 reads
Database professionals of the world – I have a question. Has your organization defined service level agreements (SLAs) for your data estate? I’m talking specifically the Recovery Point Objective...
2023-10-11 (first published: 2023-09-18)
225 reads
Microsoft Fabric is an awesome product that has now been in public preview for five months. If you are not familiar with it, check out my recent video where...
2023-10-11
214 reads
I left home last Tuesday for work, heading to New Jersey for work. Over the weekend, I took a side trip to see my daughter play volleyball at university,...
2023-10-09
20 reads
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your...
2023-10-09
13 reads
As many of you know, I was diagnosed with ALS or Lou Gehrig’s disease a couple of years ago. Since then, I have 9 made it a personal mission...
2023-10-09
13 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking quite a bit about security. Do we really know how secure our SQL Servers are?...
2023-10-09 (first published: 2023-09-26)
859 reads
If you happen to be using C# there is a very easy way to set your application up to take advantage of Read-Only replicas.
Using this connection string: (Some portions...
2023-10-09 (first published: 2023-09-18)
1,151 reads
ringlorn – adj. the wish that the modern world felt as epic as one depicted in old stories and folktales – a place of tragedy and transcendence, of oaths...
2023-10-06
119 reads
Foreword
This month’s invitation is from Grant Fritchey (t|b), aka the Scary DBA, about Extended Events (XEs).
If you look at the Tags section of my blog, you can see that...
2023-10-06 (first published: 2023-09-13)
373 reads
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Hi, we put together an extract that runs every 15 minutes against what i...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers