When I first started work as a software developer, I knew that getting an environment set up where I could compile a project might take a few hours or a few days. The complexities of how people built software projects, the dependencies, and more were handled in a very immature manner. These days I can […]
2022-11-16
165 reads
Accessibility ensures that everyone has a great experience on your site. Bikkani explains how to achieve web accessibility.
2022-08-29
Firebase is a SaaS platform that provides developers with many services to improve productivity and reduce build time. In this article, Goodness Woke demonstrates working with Firebase Version 9 and React Typescript.
2022-05-09
In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.
2021-04-20
This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a SQL execution plan for software design.
2021-03-18
When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect performance. In this article, Uwe Ricken demonstrates how to measure PFS contention.
2021-01-25
To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In this article, Joe Celko reviews normalizing databases including commonly used normal forms.
2020-12-15
All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform well and how to get around the issues.
2020-09-24
Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap is faster than a clustered index.
2020-09-17
In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including the TOP operator, compression, and partitioning.
2020-07-15
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
Hi all, We have a database configured for asynchronous mirroring. We have some planned...
I have created a table as per below query CREATE TABLE [dbo].[mydbtemp]( [Datetime] [datetime]...
what I want is to apply some filter patterns to search the data. For...
Ask SSC