Data and DevOps Predictions for 2022
All the Advocates at Redgate (Kathi, Grant, myself) got asked about some of the future predictions we might have, based on some of the data from The 2021 State...
2022-01-10
55 reads
Why Is “WHERE 1=0” Slow?
I saw a question the other day, questioning why they’re creation of temporary tables was so slow. What they were doing was (a much more complicated version of) this:...
2022-01-24 (first published: 2022-01-10)
913 reads
Architecture – The Perfect Enemy
When I was younger, I always wanted the perfect solution to an IT problem. I remember getting into argument after argument trying to insist upon the perfect configuration, setup,...
2022-01-21 (first published: 2022-01-10)
393 reads
Daily Coping 10 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-10
42 reads
SQL Server STUFF
The STUFF function in SQL Server is one of those little gems that is very under-used but when needed can be a real handy utility – at least that’s...
2022-01-10
40 reads
Connecting to an Azure SQL Database
Are you starting to experiment with Azure SQL Databases? Is your company interested in moving to the Cloud and asking you to investigate different options? This blog will show...
2022-01-08
245 reads
Bulk Insert – Insights That Will Make You Drool
Bulk insert can be an extremely helpful tool to help ingest data into SQL Server efficiently. Sometimes, it is necessary to capture metrics in regards to the bulk insert...
2022-01-24 (first published: 2022-01-07)
824 reads
Daily Coping 7 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-07
20 reads
Running Powershell code in Vim
I’ve been mucking about with Vim a bit recently and recently found myself (for reasons unknown tbh) writing powershell scripts in it. Once I’d written a script, I would...
2022-01-26 (first published: 2022-01-07)
374 reads
What permissions are required for temporary tables?
Managing permissions is a constant issue for Database Administrators, but rarely do DBAs consider permissions for tempdb. Everybody’s looking for something, but how often do you get requests for...
2022-01-19 (first published: 2022-01-06)
541 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Alamat BCA KCP Atrium Telp:08218520154
WhatsApp CS 628218520154 Ruko Atrium Blok E. 12-13, RT.5/RW.18, Sunter Agung, Kec. Tj. Priok,...
Alamat BCA KCP Bungur Telp:08218520154
WhatsApp CS 628218520154 Jl. Bungur Besar Raya No.32 & 32A, RT.3/RW.1, Gn. Sahari Sel.,...
Alamat BCA KCP Cempaka Putih Raya Telp:08218520154
WhatsApp CS 628218520154 Jl. Cempaka Putih Raya No.118 B,C,D, RT.16/RW.3, Cemp. Putih Tim., Kec....
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers