Working with Firebase Version 9 Modular SDK and React Typescript
The post Working with Firebase Version 9 Modular SDK and React Typescript appeared first on SQLServerCentral.
development
Why Are Linked Server Queries So Bad?
No, I don’t want to be your valentine. Remember when you were in school, and you had a […]
A data transformation problem in SQL and Scala: Dovetailing declarative ...
Part II : Equivalent Solutions in Functional Programming – Scala Part I of this two-part series presented […]
#TSQL2sday 136 Wrap-Up: Your Favorite (and Least Favorite) Data Types
For this month’s T-SQL Tuesday, I asked you to blog about your most-loved and least-loved data types. Crazy, […]
What is interpolation?
Interpolation is a mathematical technique which was popular before we had a lot of cheap computing power. […]
4 Things I Love About Integers #TSQL2sday
I love integers. Furthermore, I think we’ve all been taking them for granted. Integers are clean, elegant datatypes […]
A data transformation problem in SQL and Scala: Dovetailing declarative ...
Part I: Problem Space, SQL Server Simulation and Analysis This article covers an interesting approach to a […]
Heaps in SQL Server: Part 4 PFS contention
The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part […]
Normal Forms
Everyone gives lip service to normalized databases. But the truth is that normalization is a lot more […]
“Not to write any procedure over 50 lines”
In Joe Celko’s Stairway to Database Design series, he writes: The rules of thumb for T-SQL are not […]
Hands-On with Columnstore Indexes: Part 4 Query Patterns
The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Hands-On with Columnstore Indexes: Part 2 […]
Heaps in SQL Server: Part 3 Nonclustered Indexes
The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part […]
How Do I Know If My Query Is Good Enough ...
When I ask that question, here are some of the things I think about: How many times am […]
[Video] The Top 10 Developer Mistakes That Won’t Scale on ...
You’re a C# or Java developer building an application that stores data in Microsoft SQL Server, and you […]
A One-Slide Summary of the Differences Between TDE and Always ...
The folks on Twitter liked this, so sharing it here: It’s a one-slide summary from a SQL Critical […]
Hands-On with Columnstore Indexes: Part 3 Maintenance and Additional Options
The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Hands-On with Columnstore Indexes: Part 2 […]
Sit Down. We Need to Talk About Your Scalar Functions.
Thanks for coming today. I apologize for baiting you in here with a picture of toilet paper. That’s […]
Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines
The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Hands-On with Columnstore Indexes: Part 2 […]
Heaps in SQL Server: Part 2 Optimizing Reads
The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part […]
[Video] How to Find Queries Using OPTION RECOMPILE (And Their ...
For years, I hated troubleshooting servers with high CPU usage caused by queries constantly asking for new execution […]
Heaps in SQL Server: Part 1 The Basics
The series so far: Heaps in SQL Server: Part 1 The Basics This article is the beginning […]
Hands-On with Columnstore Indexes: Part 1 Architecture
Indexes are the key to efficient performance in any relational database. Few index enhancements have been introduced […]
[Video] Altering Datatypes With (Almost) No Downtime
Sometimes, your INT columns run out of space, and you need to alter them to be a larger […]