Create quick queries quickly with SSAS in Azure
In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or...
2017-01-04
286 reads
Quick Prompt Tips–Custom Procedure Templates
One of the things that I often do is create stored procedures. The syntax for doing so is simple, but...
2017-01-04
513 reads
The Side Project
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...
2017-01-11 (first published: 2017-01-04)
1,362 reads
When was SQL Server installed?
In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve...
2017-01-04
13,842 reads
My Interview published on Microsoft Technet Blog
Wish you a Happy New Year to all the readers and technical enthusiasts!!!
https://blogs.technet.microsoft.com/wikininjas/2017/01/02/interview-with-a-sql-server-expert-and-wiki-ninja-prashanth-jayaram/
My interview is published on the Microsoft Technet blog...
2017-01-03
451 reads
Epic Life Quests
It is easy to get caught up in the daily details of life and not take the time to reflect on longer term goals and accomplishments.
Inspired by Brent Ozar...
2017-01-03
13 reads
Launching #TAPtips – Valuable Tips from Decades of Practice
Launching #TAPtips Blog Posts While forming Datalere, Carlos and I wanted to continue with our contributions to the Denver, Colorado...
2017-01-03
197 reads
Be Careful of Your Create Stored Procedure Batch
I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this:
CREATE PROCEDURE...
2017-01-03
3,769 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about that, there were months where I barely managed to...
2017-01-03
7 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
167 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