Data Science for SQL Folks: Leveraging SQL and R
Learn about how to build value driven analytics with SQL Server and R.
Spousal Surcharges
Today we have a guest editorial from Andy Warren that examines the costs of family at work.
SQL Server T-SQL Tuning -TVF and Scalar Functions
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
Open is Not Necessarily More Secure
Just because we can view the source code for software doesn't mean it is more secure.
ReadyRoll is a Fully Fledged Redgate Tool
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.
The SQL Server 2016 Query Store: Built-in Reporting
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.
Stairway to SQLCLR Level 7: Development and Security
Learn about some Visual Studio features that help with automation, and use them to create an Asymmetric Key and Login.
Converting MS Access Reports to SQL Server Reporting Services Reports
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.
Learning from Microsoft
Microsoft has changed their engineering to do amazing things in the cloud, especially with SQL Server. We could all learn from this.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Alamat Kantor BCA KCU ASIA Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II, Kec. Medan...
BCA KCP Plaza Medan Fair CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Gedung Plaza Medan Fair, Jl. Gatot Subroto No.30 GF-1G, Sekip, Kec....
BCA KCP Sabang Telpon/wa.085373737699
BCA KCP Sabang Telpon/wa.085373737699.Jl. H. Agus Salim No.57 B, Kb. Sirih, Kec. Menteng, Kota...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers