The 10 Basic Concepts of T-SQL
For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the...
2017-08-29
1,322 reads
For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the...
2017-08-29
1,322 reads
In this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution...
2017-05-15 (first published: 2017-05-03)
1,246 reads
Last week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of...
2017-05-02
2,096 reads
Are you a software developer?
Did you ever get to develop a software that works with a Microsoft SQL Server database?
...
2017-03-13
795 reads
One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and...
2017-01-23
2,218 reads
Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel.
It was a great experience,...
2016-12-30
901 reads
On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days...
2016-09-29
594 reads
A month ago, my wife and I were in Barcelona for a short vacation.
In one of the days, we entered...
2016-06-29
641 reads
I’m excited to say that I will be delivering a session in this year’s PASS Summit in Seattle later this...
2016-06-24
419 reads
One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they...
2016-05-10 (first published: 2016-04-27)
3,909 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...
WhatsApp+19254941544 La guía definitiva para obtener una licencia de conducir en California El Departamento...
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