Here is a real world scenario I came across on the MSDN forums. The forum poster wanted a method to dynamically create HTML hyperlinks, for keywords/phrases , within the description of the current column text. Enter this challenge and see how your T-SQL skills match up.
2009-11-16
2,633 reads
In your development environment if you have locked down permissions for developers, but still need them to execute stored procedures you will need to grant execute rights each time a new stored procedure is generated. In this tip I will show you a way of doing this automatically each time a new stored procedure is created without granting your developers additional permissions.
2009-11-13
3,474 reads
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
1,085 reads
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
348 reads
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
329 reads
After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This...
2009-11-13
2,276 reads
Despite the down economy, the 2009 PASS Summit attendance was down only 8% compared to the 15% of other conferences...
2009-11-13
371 reads
Have you ever been required to create a database with nothing but a specification in Excel?
2009-11-12
7,665 reads
Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2009-11-12
509 reads
Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2009-11-12
802 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Comments posted to this topic are about the item Having a Little Fun at...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers