How I Work: Data Professionals at Work
It has been a busy year so far. Last March, I did a review, as a Technical Reviewer, for a...
2018-11-02
298 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
Creating Facets in SQL Server 2017 Using R
SQL Server 2017 In-Database Machine learning has brought the analytics closer to the data. It is now convenient to do...
2018-04-11
953 reads
Creating Bar Graph In SQL Server 2017 Using R
Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a matter of finding the correct...
2018-04-05 (first published: 2018-04-03)
2,544 reads
Getting Things Done With SSMS
As a SQL Server pro, I spend most of my productive time in the SQL Server Management Studio (SSMS). I...
2018-04-04 (first published: 2018-03-27)
2,959 reads
Identify R Package Dependencies Using miniCRAN
Installing R packages in SQL Server 2017 is a breeze with the stored procedure sp_execute_external_script. But so far, it is limited...
2018-03-20
451 reads
Getting Started With R In SQL Server 2017
Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...
2018-03-22 (first published: 2018-03-13)
4,315 reads
Book Review: SQL Server 2017 Machine Learning Services With R
Disclaimer: I’m one of the Technical Reviewers for this book.
With the rising demand for cloud computing and wide adaptation of...
2018-03-19 (first published: 2018-03-06)
2,702 reads
Productivity For The Data Pro
Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate...
2018-02-27
466 reads
Killing A Service Broker SPID
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...
2018-03-06 (first published: 2018-02-20)
6,300 reads
Database Maintenance Without Breaking The Bank
Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of...
2018-02-22 (first published: 2018-02-13)
3,173 reads
Blogs
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers