It's your last chance to take part in the 2021 State of Database DevOps survey! If you or your organization uses databases, we want to hear from you! Complete the survey for advance access to the final research report, and to be entered into a prize draw for a $500 Amazon voucher. Plus, for each submission we receive, we’ll donate $1 to the World Health Organization’s COVID-19 Solidarity Response Fund. Take the survey here.
Introduction Performance, performance, performance. While performance in SQL Server can be achieved with code improvement and proper infrastructure maintenance, both tasks require an effort. Code reviews and deep index analysis would take time, but sometimes the obvious is right in front of you. Let's talk about HEAP tables, aka tables with no clustered indexes that […]
The annual Advent of Code challenge is underway, and you can use it to help grow your career.
In this tip we will go through the steps for setting up customer managed keys or Bring your own key (BYOK) to be used for transparent data encryption for an Azure SQL Database.
With 2020 coming to a close, it's time to look at the new year ahead. Join our final 2020 summit this December 10th, to discover how to implement a generative culture for successful IT teams and how database DevOps will drive growth and ROI in a remote world. Register to tune in live or watch the recordings.
Today Steve notes that we often don't have all the knowledge or information we need, but we can work to acquire it.
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]
In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file.
Today Steve looks at legacy systems and the challenges they pose as we try to adapt them to new requirements.
Ever wonder about index column order; this piece should give some insight.
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
Terminal 2, Gate 3, RT.001/RW.010, Pajang, Kedatangan, Tangerang City, Banten 15126
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Rukan Batavia, Jl. Tiang Bendera 5 No.42 L-M, Roa Malaka, Kec. Tambora, Kota Jakarta...
Jl. Daan Mogot No.KM. 11, Wisma SSK, Kecamatan Cengkareng, Kota Jakarta Barat, Daerah Khusus...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers