Content in the Cloud
Steve Jones has some concerns over new options in SQL Server 2014 that might lead some customers to experiment in a way that causes them unexpected pain.
2013-11-25
83 reads
Editorial
Core T-SQL
Steve Jones thinks there is a list of core skills that any database developer or DBA needs. This week he asks you for a list of those things you think should be included.
2017-11-03 (first published: 2013-11-22)
794 reads
What is SQL Server not good at?
Today Steve Jones talks about some of the problems in SQL Server. Should we be documenting the situations in which features don't work well?
2013-11-21
375 reads
It Starts with Version Control
Steve Jones knows that good development practices require lots of skill and practice, but the basis for stability with your code is version control. He talks about some reasons why you might want to implement it.
2013-11-20
431 reads
Who Inspires You?
Today we have a guest editorial from Chris Shaw. After the recent PASS Summit, Chris talks about the value of getting inspired by people he listens to talking about SQL Server.
2013-11-18
138 reads
What Counts for a DBA: Deduction
Like Sherlock Holmes, a DBA needs the sound deductive reasoning to pinpoint the root cause of a crime, in amongst a thousand interesting but irrelevant details.
2013-11-18
146 reads
Dream Jobs
Today we have a guest editorial from Andy Warren. Andy asks today if you've thought about a dream job, and if so, what would it be?
2013-11-15
182 reads
Time for Learning
Today Steve Jones talks about the time required to increase your skills and debates about what time you need to invest each year to gain knowledge.
2013-11-14
257 reads
Runtime Code
Do you test your code? What about code that is generated by applications and executed at runtime. Is that tested well? Steve Jones wonders.
2013-11-13
138 reads
Test Coverage
We don't test software well enough. Obviously we don't write high enough quality software, but testing should catch more issues. Steve Jones talks about how you can perform better T-SQL testing.
2016-12-20 (first published: 2013-11-12)
272 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers