Feature Request – Expand MSX/TSX Capabilities for HADR
Following my presentation of “How to HADR Your SQL Server Jobs” at the HA/DR PASS Virtual Group yesterday, David Klee (@kleegeek) and I continued chatting for a bit longer after the recording was concluded. During which, the MSX/TSX feature of SQL Server came up, and David suggested that I’d utilize my newly earned MVP status to push a feature request to expand these capabilities.
T-SQL Tuesday #130 – Eitan’s Laws of Automation
This month, Elizabeth Noble is hosting #tsql2sday with the topic of automation. This is very similar to previous couple of T-SQL Tuesdays hosted by Ken Fisher (127) and Jess Pomfret (123). I already wrote about the topic of automation extensively in those past posts. So, instead of repeating myself, I’m gonna write about this topic […]
I’m now officially a Microsoft MVP!
My hard work and public contributions during these past few years continue to pay off in spades, and I’m excited to announce that I have finally received the Microsoft MVP award!
Using Extended Events as a Buffer
Assume you have some kind of process outside the SQL Server which is supposed to record some kind of database activity. There are many ways to do it, most of which require constant and/or stable connection to the database. But what if that’s not good enough? Let’s consider our options.
Overriding the Authentication in SSRS for External Access
In this post, I hope to summarize the various methods that we have, in order to get rid of that annoying authentication prompt. Each method has its own advantages and disadvantages in terms of complexity of implementation, versatility, and the level of security that it provides. More specifically: the more secure and versatile a method is – the more complicated it is to implement.
How to Protect SQL Server from Hackers and Penetration Tests
On June 3rd, the InfosecMatter blog published a post titled “Top #10 Vulnerabilities: Internal Infrastructure Pentest“. This blog post detailed the top most common vulnerabilities in Windows servers and networks found during more than 60 internal infrastructure penetration tests around the world. After reading this article, I was prompted to actively look for similar resources […]
T-SQL Tuesday 128 – Learn from Others
This month’s #tsql2sday is hosted by the @AirborneGeek who asks us to learn from others’ mistakes. Hey, that’s my job description! Read on for more juicy details.
Migrating from CosmosDB to SQL Server
Wherever you look, you find tools and resources to help you migrate from something that is not Cosmos DB, to Cosmos DB. The Cosmos DB migration utility tool can only export a JSON file at most, but that can rarely be good enough if you need to move around more than a handful of documents.
It took me a while to realize that I’m not going to find a publicly available migration tool for the job. So, I decided to make my own.
T-SQL Tuesday 127 – Tips and Tricks to Automate Your Life
This month’s #tsql2sday is hosted by Ken Fisher (b|t) who asks us to share tips unrelated to database systems. I will take this opportunity to talk about what you can do to easily automate a lot of your daily tasks, and never miss a thing.
PASS Summit 2020 has gone virtual – register now for a discount!
Considering the whole COVID-19 mess that is happening this year, events being cancelled and re-launched in a virtual form… Is it any wonder that the PASS Summit is joining the trend as well? I’d be quite disappointed if it hadn’t. So, great news!
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
Other ways to find me:
Archives
- September 2020 (3)
- August 2020 (2)
- July 2020 (3)
- June 2020 (3)
- May 2020 (3)
- April 2020 (3)
- March 2020 (3)
- February 2020 (2)
- January 2020 (2)
- December 2019 (4)
- November 2019 (1)
- October 2019 (1)
- September 2019 (3)
- May 2019 (3)
- April 2019 (1)
- January 2019 (2)
- November 2018 (6)
- October 2018 (14)
