If you run across migrating or copying a database structure for some purpose, yet need to change the database references...
2013-08-13
1,936 reads
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child...
2013-08-13 (first published: 2013-08-07)
4,714 reads
The dmv sys.dm_os_performance_counters is awesome, if you can understand it. This is how I make it easy to read and...
2013-08-13
2,634 reads
It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #45 is...
2013-08-13
869 reads
We have the distinct pleasure once again to have a party full of SQL enthusiasts. The best part is that...
2013-08-13
805 reads
We have the distinct pleasure once again to have a party full of SQL enthusiasts. The best part is that few if any of us are even in the...
2013-08-13
5 reads
It’s T-SQL Tuesday time again, and this month Mickey Stuewe hosts the party. It’s an interesting topic, and one that...
2013-08-13
999 reads
“My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written,...
2013-08-12
1,664 reads
LinkedIn groups have the option to enable a Jobs section and associated discussion area. Potential employers can post jobs directly...
2013-08-12
818 reads
sys.dm_tran_locks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms190345.aspx
Returns information about currently active lock manager resources. Each row...
2013-08-12
1,256 reads
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Hub Via Wa:62817825533 Alamat Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa...
Hub Via Wa:62817825533 Alamat Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa...
Hub Via Wa:62817825533 Alamat: Wisma BCA BSD City, Kav. CBD, Jl. Pahlawan Seribu Lot...
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