Tech Lunch News
Predminulý týden (10. listopadu 2021) jsme porádali už nekolikátý verejný Tech Lunch. Jde o pulhodinový call, na kterém pravidelne prezentujeme novinky ze sveta dat (datové sklady, Azure, SQL Server,...
2021-11-23
18 reads
Blog Posts
Daily Coping 22 Nov 2021
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...
2021-11-22
17 reads
Decoding SSRS Subscription Agent Jobs
Hello and welcome back… It has been a few months since I have published a blog post. More like 126 days, to be exact. Unfortunately, I have been dealing...
2021-11-22 (first published: 2021-11-16)
670 reads
Failover Groups for Managed Instances
If you have been following me for a while you will know that I really like the Fail over groups within Azure SQL DB and it is no different...
2021-11-22
30 reads
Reading Data from the Command Line in PowerShell–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In every language I’ve coded in, there is...
2021-11-22
104 reads
SQL Server 2022 is coming
SQL Server 2022 is still in private preview (Microsoft MVP folks have access to it), but you can now read about the new release before it is released: SQL...
2021-11-22
195 reads
SQL Server 2022 is coming
SQL Server 2022 is still in private preview (Microsoft MVP folks have access to it), but you can now read about the new release before it is released: SQL...
2021-11-22
6 reads
STRING_SPLIT Has Ordinals
I noticed the docs for STRING_SPLIT now show that there is a third parameter. This brings us an ordinal for the positioning of the data. The format is now:...
2021-11-22 (first published: 2021-11-17)
1,628 reads
Daily Coping 19 Nov 2021
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...
2021-11-19
49 reads
My PASS Data Community Summit 2021 Speaking Experience
If you’d asked me 5 years ago if I would ever speak at Summit, I’d have said “no way, not possible.” I didn’t even think I was able to...
2021-11-19
15 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Alamat Kantor BCA KCP Fatmawati Telp:0821-8200-203
Telp/WA 62 8218200203 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota...
Alamat BCA KCP Gatot Subroto Telp:0821-8200-233
Telp/WA 62 8218200233 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 Lt GF unit C,...
Alamat BCA KCP Warung Buncit Telp:0821-8200-174
Telp/WA 62 8218200174 Gedung Multika, Jl. Mampang Prpt. Raya No.71-73, RT.1/RW.1, Tegal Parang, Kec....
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers