Backup Your On Premise SQL Server Directly to an AWS S3 Bucket
I’ve been having a little play around with AWS recently and was looking at S3 (AWS’ cloud storage) when I...
2018-06-18
713 reads
I’ve been having a little play around with AWS recently and was looking at S3 (AWS’ cloud storage) when I...
2018-06-18
713 reads
Sometimes emails from SQL Server go missing, especially when you share an inbox with colleagues. On most occasions it doesn’t...
2018-06-14 (first published: 2018-06-05)
2,314 reads
Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair...
2018-05-24
1,693 reads
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...
2018-05-14 (first published: 2018-05-02)
2,384 reads
This month’s T-SQL Tuesday is brought to you by Jens Bestergaard – the subject is Essential SQL Server tools, the original...
2018-04-10
1,092 reads
We all go to great lengths to make sure that our databases are secure (or at least I really hope...
2018-04-09 (first published: 2018-04-04)
2,457 reads
Here’s a quickie that I’ve just stumbled across.
I’ve just tried to initiate a manual failover of an availability group and...
2018-03-29
503 reads
Have you ever had an issue where TempDB was filling up on your secondary replicas? Do those secondaries happen to...
2018-03-28 (first published: 2018-03-21)
3,599 reads
So for this month’s TSQL Tuesday, Adam Mechanic has asked us to take a look into the future and think...
2018-03-13
431 reads
The other day I got thinking about what would happen if all databases on a single instance grew out, every...
2018-03-12
256 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers