Thoughts about the PASS BoD Nomination Process
I know I was one of the more vocal ones these past two years when the set of nominees were...
2010-09-06
881 reads
Renaming a column in Sql Server
We often need to change the name of a column of a table to a new name. We can do...
2010-09-06
724 reads
Labor Day Bloopers
Happy Labor day to everyone. A day off for me, but I’m posting a few bloopers from the past couple...
2010-09-06
1,102 reads
In the Interest of Disclosure
Yesterday I attended an internal training course on social networking. The class was targeted toward the 100 level, but like...
2010-09-03
426 reads
Re-learning how to think
Cross-posted from The Goal Keeping DBA:
Re-learning how to think is always a difficult process. My oldest son is starting the...
2010-09-03
1,497 reads
September S3OLV Meeting
Another month has crept up upon us. It is time once again for the Las Vegas User Group /PASS Chapter...
2010-09-03
495 reads
A Community Divided
People have been screaming from rooftops for a month now about the PASS election process, ever since a beloved member...
2010-09-03
968 reads
MDX Puzzle #7 - Solution
Puzzle #7 had an interesting twist. You were required to add a column to the result set that dynamically displayed...
2010-09-03
600 reads
Free SQL Server Training for the Week of September 6, 2010
Tuesday
PASS Performance Virtual Chapter - Introduction to SQL Server Statistics - Andy Warren
Wednesday
Idera - Building a Data Mart with Integration Services - Stacia Misner
SQL...
2010-09-03
902 reads
Recursive Hiearchies in Reporting Services
I am not a Reporting Services guru and nor do I play one on TV. I am however forced to...
2010-09-03
2,657 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