This article will follow a practical approach to choose the right candidate for clustered index. It'll investigate through the best practices recommended for clustered index, with the help of...
2020-05-13 (first published: 2020-04-28)
859 reads
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2020-05-13 (first published: 2020-04-29)
593 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-13
11 reads
Last time we looked at the internals of how dates and times are stored in SQL Server. This week we’re going to look at how numbers are stored. This...
2020-05-13
113 reads
The SQL Prompt Public preview extension for Azure Data Studio is out and you can add this easily. This is a quick post showing a few ways to install...
2020-05-13
192 reads
The other day I had a random thought. I wonder if there is a version of Azure Portal for Android. ... Continue reading
2020-05-13
73 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-12
16 reads
I’ve done a follow-on to my webinar with Kevin Kline on Learning from Data Breaches. Here we’ll talk about some specific technologies that come out of the box with...
2020-05-12
28 reads
There are many quality resources regarding SQL Server 2019, from eBooks to videos about the newest features and how one would implement these within your business. I recommend the...
2020-05-12
30 reads
This month’s T-SQL Tuesday is hosted by my friend Glenn Berry. Glenn invites us to write about what we have been doing as a response to COVID-19. Glenn shared...
2020-05-12
10 reads
The DBA life is fraught with pain. Those battles that we endure are mostly...
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
WA:08218154393 Jl. Raya Jati Makmur, RT.001/RW.007, Jatimakmur, Kec. Pd. Gede, Kota Bks, DKI Jakarta...
WA:08218154393 Ruko Cikarang Plaza, Jl. Yos Sudarso No.5 Blk B, RW.6, Cikarang, Kec. Cikarang...
WA:08218154393 Madison Square, Business Park Lippo Cikarang, Jl. MH. Thamrin No.163, Cibatu, Cikarang Selatan,...
Can I set Accelerated Database Recovery on tempdb?
See possible answers