SQL Server – Conditions when value of @@error changes
Hi friends, when we do error handling in our SQL code we use different methods like TRY/CATCH, RAISERROR etc. to...
2016-06-02 (first published: 2016-05-24)
1,367 reads
Blog Posts
SQL Server 2016 available today
In case you haven't heard, SQL server 2016 is generally available today! If you haven't try it out, you should...
2016-06-02
851 reads
SSMS new feature - Showplan comparison
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans...
2016-06-02
352 reads
sys.dm_db_wait_stats DMV
Come on guys, lets “UP- vote” this suggestion for the actual SQL Server product – even the “Scary DBA” likes the...
2016-06-02
251 reads
Why Do I Write? And Should I Continue?
It’s been about six months now since my career to a sharp right turn. At the request of my kids, I left a decade of consulting for a role...
2016-06-02
17 reads
Why Do I Write? And Should I Continue?
It’s been about six months now since my career to a sharp right turn. At the request of my kids,...
2016-06-02
374 reads
Another Recursive CTE–Doing Math
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-06-01
529 reads
Independent Azure Data Platform Instructors
The Azure Data Platform is taking off. I’m seeing more and more interest on the forums, at conferences and in...
2016-06-01
434 reads
Master_Views: master_objects, master_tables, etc
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of...
2016-06-01 (first published: 2016-05-23)
1,586 reads
Power BI Custom Visuals Class (Module 01 – Custom Visuals Introduction)
Welcome to an exciting new FREE class that I am launching today! Over the next year (that’s right year!) I...
2016-06-01
2,255 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
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...
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