Indexing In Memory OLTP Tables
Indexing on In Memory OLTP tables is a little different from your traditional on-disk rowstore tables…
In Memory Differences…
There is no...
2018-12-24 (first published: 2018-12-04)
2,900 reads
Blog Posts
Merry Christmas
Wish you all a Merry Christmasand may this festival bring abundant joy and happiness in your life!
From Technology with Vivek Johari
2018-12-24
159 reads
Merry Christmas
Wish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!
From
Technology with Vivek Johari
2018-12-24
3 reads
Quick and Easy XE for Azure DB
This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB. I demonstrate the use of the GUI to...
2018-12-24
17 reads
Thread-safe PowerShell Logging with PSFramework
In my previous post, I mentioned that I wasn’t checking the status of my RSJobs because I had logging built into my function. I originally tried to log out...
2018-12-24
67 reads
Last Week Reading (2018-12-23)
The Christmas is coming. But before we start the festive time and sit down to the Christmas Eve dinner – a...
2018-12-23
183 reads
Call for Speakers for Orlando Code Camp Closes Jan 18, 2019 & We Need SQL Speakers
Orlando Code Camp is March 30. 2019 in Lake Mary (same location as SQLSaturday Orlando) and we’re hoping to have...
2018-12-22
246 reads
Advent of Code 2018 – Day 2 (Inventory Management)
Advent of Code 2018 – Day 2
As I explained in yesterday’s post, I’m participating in this year’s Advent of Code challenge,...
2018-12-21 (first published: 2018-12-04)
1,831 reads
Azure Portal Enhancements – Switching Accounts
More and more I am impressed on the Azure Portal. Microsoft continues to make enhancements to the user interface (UI)...
2018-12-21
247 reads
Database Fundamentals #20: Using the JOIN Operator, Inner Join
It is entirely possible to try to JOIN two tables on almost any field, as long as the two data...
2018-12-21 (first published: 2018-12-03)
2,516 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers