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,287 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,287 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,245 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,090 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
792 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
899 reads
On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days...
2016-09-29
590 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,904 reads
By Steve Jones
Today’s coping tip is to take a small step towards and important goal. One...
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
I was writing some dynamic SQL that generates some SQL statements to load my...
Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(TransactionDate)...
Hello, I'm pretty new to SSIS, but I have an Excel source that I...
Hi guys, I want some help with a code to count the number of...