Hear from Microsoft engineering experts on the latest features in SQL Server 2016 before the live event. Learn about new business intelligence capabilities like built-in mobile BI, fully integrated advanced analytics, security innovations, mission critical in-memory performance and new hybrid cloud solutions.
Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance
Learn about how to build value driven analytics with SQL Server and R.
Today we have a guest editorial from Andy Warren that examines the costs of family at work.
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.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Kantor Sahid Sudirman Residence, Jl. Jenderal Sudirman No.86 Lt. LG Unit 01, Karet Tengsin,...
Jl. Cideng Barat No.53, Cideng, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
CSTelpon : 0853-73737551 Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt....
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers