It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.
2009-11-16
699 reads
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,668 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
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers