In-Memory OLTP Part 2 : Memory-Optimized tables
In part 1 of the In-memory OLTP articles we gave you an introduction into In-memory OLTP, showing what the requirements...
2015-01-11
4,188 reads
Blog Posts
Friday Followup For January 9, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-01-09
398 reads
How to resolve connection errors when loading data in SSAS Tabular project
This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar...
2015-01-09
584 reads
I Am Grateful For
A while back I wrote about saying “Thank you” to people. Last night I was listening to NPR on my...
2015-01-09
690 reads
Learning SQL #1–Start from buying a Copy of SQL Server Developer Edition
If learning SQL is in your New Year Resolution, then you will be happy to read this post.
We all make...
2015-01-09
1,047 reads
On Failure
The first rule of blogging is that you should write about topics you know a lot about. And I know...
2015-01-09
687 reads
Reports In SSISDB
I was approached with an in shop issue where a group could not view the execution reports in the SSISDB....
2015-01-09 (first published: 2015-01-07)
10,698 reads
Six practical tips for social media success in 2015
Social media is the new résumé. In many ways, it’s even better than a résumé – a person’s social media stream...
2015-01-09 (first published: 2015-01-02)
6,044 reads
SQL – Split delimited columns using XML Or UDF function
The requirement is to convert the delimited column into rows
Input data and required output details are given below
EnoEnameEslocEDept1ABCNJ10,20,30,40,50Output:-
EnoEnameEslocEDept1ABCNJ101ABCNJ201ABCNJ301ABCNJ401ABCNJ50Download the Script Split...
2015-01-09
1,348 reads
SQL Saturday NYC Update #3
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-01-09
468 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers