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,331 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,331 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,253 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,106 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
796 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
906 reads
On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days...
2016-09-29
597 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
642 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
420 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,916 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers