Monday Morning SQL Break – July 11, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. I spent the weekend with family...
2016-07-11
875 reads
StrateSQL
SQL Server Indexing Book Giveaway – Week 5
It’s time for week 5 of giving out some copies of Expert Performance Indexing for SQL Server. So far, I’ve sent...
2016-07-05
680 reads
SQL Server Indexing Book Giveaway – Week 5
It’s time for week 5 of giving out some copies of Expert Performance Indexing for SQL Server. So far, I’ve sent out four copies of the book based on comments from...
2016-07-05
22 reads
Tuesday Morning SQL Break – July 5, 2016
Yesterday was a holiday here in the United States, so I’m starting the week on Tuesday. For those in the...
2016-07-05
817 reads
Monday Morning SQL Break – June 27, 2016
The best way to make the most of the week is to set your goals. One of the things I...
2016-06-27
891 reads
SQL Server Indexing Book Giveaway – Week 4 (the late edition)
So… it’s Saturday night and I missed getting this out on Friday morning…
But, in past three weeks’ posts (1, 2, 3),...
2016-06-26
727 reads
SQL Server Indexing Book Giveaway – Week 4 (the late edition)
So… it’s Saturday night and I missed getting this out on Friday morning… But, in past three weeks’ posts (1, 2, 3), I talked about how I’ve got a few copies...
2016-06-26
18 reads
Monday Morning SQL Break – June 20, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-06-20
873 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for...
2016-06-17
722 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for SQL Server to give away. This is a book that I...
2016-06-17
9 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
Alamat Kantor BCA KCU Tasikmalaya Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. HZ. Mustofa No.300, Tuguraja, Kec. Cihideung, Kab. Tasikmalaya, Jawa...
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
Alamat Kantor BCA KCU Dago Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung,...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers