A UDF is very convenient for centralising business logic as we can specify a set of business logic in one UDF which references multiple stored procedures and ad-hoc queries. However, they can lead to significant performance degradation due to their demands on the CPU
Just because we can view the source code for software doesn't mean it is more secure.
In June last year we got in touch to let you know that Redgate acquired ReadyRoll. Over the last few months, ReadyRoll went from a one-man project to having a team of developers, testers, and support engineers behind it. Dan Nolan, the founder of ReadyRoll, is now a product manager at Redgate. And next week it’s time for ReadyRoll to become a fully-fledged Redgate tool available from www.red-gate.com.
One of the most important features of the SQL Server 2016's new Query Store is the reporting. With these features, it is now possible to get a wealth of information on how your query workload is performing, either aggregated for the entire query workload or for a single query. With this information, you can see the effects of 'forcing' an execution plan for specific queries and get feedback of the consequences.
Learn about some Visual Studio features that help with automation, and use them to create an Asymmetric Key and Login.
Siddharth Mehta walks through how to automatically migrate reports from MS Access to SQL Server Reporting Services (SSRS) without having to rebuild anything from scratch.
Microsoft has changed their engineering to do amazing things in the cloud, especially with SQL Server. We could all learn from this.
Greg Larson looks at how to hide the value of sensitive data by applying Dynamic Data Masking.
In this new chapter we will show how to verify the accuracy of the mining models.
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers