Most SQL Server programmers know to use the SET NOCOUNT command to prevent the number of rows message from being returned to the client. But how does this affect performance? Does it make sense to qualify the owner on your objects? SQL Server guru David Poole brings us some performance analysis of how your stored procedures perform.
Visa has developed Payment Applications Best Practices and will begin implementing mandates concerning them
When we talk about something being reliable, we're referring to it being dependable and predictable. When it comes to software, however, there are other key attributes that must also be present for the code to be considered reliable.
Storing sensitive data in your database leads to security risks. Learn how not storing sensitive data indefinitely is a form of data protection.
Cell phones are great communication tools, but that's mostly what they do, even for IT folks. But Steve Jones talks about some other possibilities and potential problems.
Using data modeling tools should be something that all SQL Server DBAs involved in development use, but most of us cannot afford the tools or have the expertise to use them. Jambu Krishnamurthy brings us a new article that shows how you can use Erwin to work with your data model.
Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.
Buck Woody's SQL Server Reference Guide is your "one-stop shop" into the world of Microsoft's SQL Server, providing you with the information you need to manage and program SQL Server.
Microsoft is unbundling their new hypervisor from Windows. Could this happen with SQL Server?
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 This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers