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,696 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
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
458 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,107 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,160 reads
Waiting Tasks Reveal Pain Points
Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I...
2018-02-14 (first published: 2018-02-06)
2,746 reads
Layman’s Guide to Performance Tuning
Performance tuning is one of those things that is hard to get right when you do not have an established...
2018-02-08 (first published: 2018-01-30)
3,518 reads
My Favorite SQL Prompt Features
SQL Prompt from Redgate Software is one of the tools that I cannot live without. Well, that’s probably an exaggeration...
2018-02-02 (first published: 2018-01-23)
3,098 reads
How To Split Table Partitions Automatically
Table partitions can bring a lot of benefits to the manageability and performance of your SQL Server – that is if...
2018-01-16
946 reads
SQL Operations Studio As Monitoring Dashboard
Microsoft as a company has entered a new phase of innovation under the leadership of their CEO Satya Nadella. In...
2018-01-09
562 reads
My Tech Reading List to Start the Year
My bold learning goals call for adequate preparation and proportionate action. Before plunging into the challenge, I need to get...
2018-01-12 (first published: 2018-01-02)
1,789 reads
Blogs
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
Check Power BI report interactions with Semantic Link Labs
It can be tedious to check what visual interactions have been configured in a...
Forums
SQL MI Next-gen general purpose tier
Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers