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?
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers