It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots.
Erik Darling explains why sp_AllNightLog creates so many jobs by default.
Steve Jones talks about backup of data today and the challenges of managing this at scale.
The problem of ransomware seems to be increasing. Major organizations are being hit and their servers are being affected. K. Brian Kelley explains some of the basic things you can do to reduce your expose to ransomeware.
A look back at the random nature of finding information in libraries and bookstores. A feeling Steve Jones misses.
When we have to deal with and store a lot of data, it makes sense to aggregate it so that we store only the information we actually need. If we get this right, this works well, but the design of the system takes care and thought because the problems can be subtle and various. Joe Celko describes some of the ways that things can go wrong and end up providing incorrect, inaccurate or misleading results.
You are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.
Have you ever wondered how much database mail you have sent in the past day or week? What about those database mail items that were not successfully sent. In this tip, Greg Larsen shows you how to review the database mail items that have been processed by SQL Server.
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...
CSTelpon : 0853-73737551 Perumahan Citra Raya Blok KD.02 No. 10, 15, RW.Mardigrass, Mekar Bakti,...
Jl. Alternatif Cibubur RT.005/09. Kel. Harjamukti, Cibubur, Kec. Cimanggis, Kota Depok, Jawa Barat 16454
CSTelpon : 0853-73737551 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26 Blok A/24,...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers