System-Versioned Temporal Tables
Every once in a while, I like to take a moment and learn something new about the latest SQL Server...
2017-08-30
1,201 reads
Blog Posts
What you need to know about memory limits on SQL Server
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max...
2017-08-30
357 reads
Working with the registry from within SQL Server
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...
2017-08-30 (first published: 2017-08-16)
3,766 reads
You might be a DBA if
I’d been trying to think of a fun post to write and an homage to Jeff Foxworth’s You might be...
2017-08-30
1,881 reads
Database Fundamentals #8: All About Data Types
SQL Server provides all different kinds of data types in order to give you more flexibility and control for how...
2017-08-29
1,429 reads
Database Fundamentals #8: All About Data Types
SQL Server provides all different kinds of data types in order to give you more flexibility and control for how...
2017-08-29
650 reads
Power BI Custom Visuals Class (Module 64 – Dot Plot MAQ Software)
In this module you will learn how to use the Dot Plot Custom Visual by MAQ Software. The Dot Plot...
2017-08-29 (first published: 2017-08-17)
1,565 reads
Power BI Custom Visuals Class (Module 66 – Calendar by Tallan)
In this module you will learn how to use the Calendar Custom Visual by Tallan. The Calendar Visual provides a...
2017-08-29
831 reads
Tech news: Your phone screen is a dirty rotten spy
Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic...
2017-08-29
395 reads
The 10 Basic Concepts of T-SQL
For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the...
2017-08-29
1,385 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers