Blog: SQLUndercover

210 blogs updated: 38 min. ago
Selecting a Random Row From a Table
A couple of times recently I've seen the question asked, How can I select a single row at random from a table?'. There are often a few ways ...
20-07-2018 12:16:42 SQLUndercover SQL Server
T-SQL Tuesday #104 – My Undercover Toolbox favourites
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here. Bert has a great topic fo...
10-07-2018 12:25:51 SQLUndercover SQL Server
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 thought to myself, I wonder if it'...
18-06-2018 16:27:49 SQLUndercover SQL Server
Resend an email sent from SQL Server using TSQL
Sometimes emails from SQL Server go missing, especially when you share an inbox with colleagues. On most occasions it doesn't always matter ...
05-06-2018 23:09:27 SQLUndercover SQL Server
Convert a Positive Number To a Negative In SQL With a Spot of Bitwise Logic
Now this is something that I've seen asked a few times and it's always a question that gets a fair number of different answers. How do we go...
24-05-2018 16:54:36 SQLUndercover SQL Server
Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling the procedure might have? Pe...
02-05-2018 19:03:14 SQLUndercover SQL Server
T-SQL Tuesday #101 – My day of Essential SQL Server tools.
This month's T-SQL Tuesday is brought to you by Jens Bestergaard the subject is Essential SQL Server tools, the original invitation can be f...
11-04-2018 01:24:36 SQLUndercover SQL Server
Encrypting SQL Server Database Backups
We all go to great lengths to make sure that our databases are secure (or at least I really hope that we do), we make sure that only authori...
04-04-2018 19:25:43 SQLUndercover SQL Server
‘Object Reference Not Set to an Instance of an Object' When Failing Over an Availability Group Using SSMS <= 17.5
Here's a quickie that I've just stumbled across. I've just tried to initiate a manual failover of an availability group and received the fol...
29-03-2018 16:39:15 SQLUndercover SQL Server
TempDB Filling Up On Secondary Replicas
Have you ever had an issue where TempDB was filling up on your secondary replicas? Do those secondaries happen to be read only replicas? Whe...
21-03-2018 15:50:50 SQLUndercover SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.