SQL Server CROSS APPLY and OUTER APPLY
Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.
Should Production Databases Be in a VCS?
Steve Jones talks version control, but from the production perspective.
Introduction to Azure SQL Database Elastic Database Pools
Traditional deployments of Azure SQL Database involve identifying projected resource requirements and selecting individual Azure SQL Database instances. For fluctuating workloads, this frequently results in over- or under-provisioning. To address this challenge, Microsoft offers another approach to sizing Azure SQL Database that relies on Elastic Database Pools. Marcin Policht takes a look.
Zero Downtime for 2016
Someone made a call to architect zero downtime for databases. Steve Jones isn't sure this is the best thing you could do.
Using R Machine Learning Script as a Power BI Desktop Data Source
You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom visuals. Here is a simple example that shows how to connect to data sources over the Internet, cleanse, transform and enrich the data through the use analytical datasets returned by the R script, design the dashboard and finally share it.
The Push to Upgrade from SQL Server 2005
There's a push to upgrade those SQL Server 2005 instances with support ending this April.
Moved to the Cloud?
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
SQL Server System Views: The Basics
When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys and indexes. SQL Server's plethora of system catalog views, INFORMATION_SCHEMA views, and dynamic management views contain all the metadata you need, but it isn't always obvious which views are best to use for which sort of information. Many of us could do with a simple explanation, and who better to provide one than Rob Sheldon?
Reasonable Timeframes
Steve Jones talks about the timeframes for updating and fixing security problems in applications.
SSIS: Case sensitivity may expose issues with change deployment
Because SSIS is case sensitive, random VS_NEEDSNEWMETADATA errors on case-insensitive databases may indicate issues in your database change management & deployment process.
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat Kantor BCA KCP Talavera Telp/Wa:0821-8200-233
CSO 08218200233 Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec....
Alamat BCA KCP Mega Kuningan Telp/Wa:0821-8200-203
CSO 08218200203 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan Setiabudi,...
Alamat BCA KCP Wisma Mulia Telp/Wa:0821-8200-174
CSO 08218200174 Jl. Gatot Subroto No.42 Suite G02, RT.3/RW.2, Kuningan Bar., Kec. Mampang Prpt.,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers