Switching blog website
For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with...
2018-11-14
179 reads
For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with...
2018-11-14
179 reads
The title says it all, this year I have been selected as a speaker at the world’s largest Microsoft Data...
2018-10-31
250 reads
I am pretty hyped to be able to finally announce a new project of mine that I have been working on for...
2018-03-13
333 reads
In a previous article I discussed the various methods available in SQL Server 2016 & 2017 to perform in-database analytics. In...
2017-12-25 (first published: 2017-12-11)
1,995 reads
Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and...
2017-10-17
1,874 reads
When you are working with Machine Learning there are many things you need to keep an eye on. You need...
2017-07-21
2,175 reads
With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning...
2017-05-24 (first published: 2017-05-14)
3,619 reads
Good news!
The recording of my session “Introducing the SQL Server 2016 Query Store” at the GroupBy conference 2 weeks ago...
2017-05-19 (first published: 2017-05-05)
1,401 reads
I remember writing an article about Query specific wait statistics being available inside execution plans in SQL Server 2016 SP1....
2017-05-01 (first published: 2017-04-23)
1,620 reads
In case you didn’t know this already, dbatools is an awesome collection of Powershell functions that will help you immensely...
2017-03-08 (first published: 2017-02-27)
2,262 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers