SQL Puzzle 1: Magic Squares
This is the first in what I hope will be a semi-regular series of recreational puzzles where SQL can be...
2017-06-07
1,632 reads
Identifying failed queries with extended events
Back to some core SQL this week and one of my favourite features, extended events.
Introduced in SQL Server 2008...
2017-06-07
6,144 reads
SQL Server 2016 Row Level Security In Action
Row Level security was introduced with SQL Server 2016 and allows us to specify predicates for what rows can be...
2017-06-07
45 reads
Best Practices: Defining Explicit Length for Varchar/Nvarchar
SA0080 : Do not use VARCHAR or NVARCHAR data types without specifying length. Level: Warning
When using varchar/nvarchar it should be explicitly...
2017-06-07
782 reads
Random Advance C# FAQs
Difference between const, readlonly and static readonly? const: const variable value is set as constant value at compile time. it can not...
2017-06-07
370 reads
5 Things You Need to Do When Performance Testing JSON in SQL and C#
Watch this week's video on YouTube
Want to learn more about using JSON in SQL Server? Watch me present at the online GroupBy conference on June 9, 2017 at 8am.
I've...
2017-06-06
30 reads
T-SQL Tuesday #091 – Databases and DevOps
Implementing DevOps with databases presents a unique set of challenges. However, just because something might be hard doesn’t mean that...
2017-06-06
426 reads
Power BI Custom Visuals Class (Module 54 – Route Map)
In this module you will learn how to use the Route Map Power BI Custom Visual. The Route Map uses...
2017-06-06
764 reads
Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
147 reads
Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
370 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
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
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...
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