Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing...
2015-03-03
60 reads
How to Fix Latch Problems when Working with Ascending Keys in SQL Server
Traditionally, we want our Clustered Index to have the following attributes:
Narrow: So that our clustered index and the non-clustered indexes that point...
2015-03-03
683 reads
50 Shades of Brown – The Series
That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to...
2015-03-03
677 reads
A Handy function
If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...
2015-03-03
187 reads
Simple-Talk Article
In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated...
2015-03-03
846 reads
SQL Server, Error message 1785, and cascading deletes: How it kills kittens
I've been gone for a bit, forgive the long delay. Who would have thought the hatred for a cascading delete...
2015-03-03
1,130 reads
Should I check tempdb for corruption?
You all know that checking our databases for corruption regularly is a must. But what about tempdb? Do you need...
2015-03-02
4,605 reads
SQLSaturday Phoenix Wrap-Up
We had a great day at SQLSaturday Phoenix this weekend! The weather was beautiful (about 60°F warmer than at my home...
2015-03-02
251 reads
SQLBits XIV – Welcome to the UK
A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was...
2015-03-02
648 reads
No Such Thing as a DevOps DBA
Sjor Takes (b|t) has just barely started blogging, but he’s got a great post about a discussion he had with...
2015-03-02
807 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers