Inspector V1.4 now available
The SQL Installation script can be found here The Inspector sample report has been updated here All of the below Git Issues can be found on the V1.4 Project...
2019-05-20
22 reads
Blog Posts
Learning Containers
I find that I’m using containers more and more to get things done with SQL Server. They’re so easy to set up for testing, spin ’em up, do stuff,...
2019-05-20
76 reads
Quick Tip – How to fix SQL Server 2017 install error on Ubuntu 18.04: E: Could not get lock /var/lib/dpkg/lock-frontend – open (11: Resource temporarily unavailable)
Problem Recently, when I tried to install SQL Server 2017 (mssql-server package) in Ubuntu 18.04, I encountered the error below: The command that I used to install the mssql-server...
2019-05-20
2 reads
SQL Server Large Memory Pages
SQL Server Enterprise Edition can leverage large memory pages to reduce the amount of memory pointers required for larger SQL Server deployments. Reducing the number of pointers makes the...
2019-05-20 (first published: 2019-05-06)
481 reads
Back with a new focus
First let me say wow can’t believe that it has been almost 3 years since I have blogged. The last few years my career have been focused on transitioning...
2019-05-19
18 reads
SQLDay 2019 – day 3 (last)
SQLDay 2019 has come to an end. Three days with workshops, technical sessions, networking and knowledge. All done by community for community. I think this is the reason the...
2019-05-19
23 reads
2019-05-17T15:59:50-05:00
TEST Kids learn so quick. It's amazing how fast my son has picked up #origami. He often has to wait for his slow-poke dad.
2019-05-17
3 reads
Azure Cosmos DB – Real-time ETL using Change Feed and Azure Functions
Many people who read my Cosmos DB articles are looking for an effective way to export data to SQL, either on-demand or in real-time. After performing a search term...
2019-05-17 (first published: 2019-05-05)
1,571 reads
Launching ADS from SSMS
If you haven’t heard, SSMS v18 went GA (Generally Availability) recently. You can download it from Microsoft, though if you have a preview version, you do need to uninstall...
2019-05-17 (first published: 2019-05-06)
562 reads
Security Learning Pathway at PASS Summit.
This year PASS is trying something new at PASS Summit. There are going to be Learning Pathways. A learning pathway ... Continue reading
2019-05-17
14 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers