Data loading into Azure SQL Data Warehouse
Azure SQL Data Warehouse (SQL DW) is a new platform-as-a service (PaaS) that distributes workloads across multiple compute resources, called massively parallel processing (MPP)....
2016-03-23
622 reads
Blog Posts
I’m presenting for the Pass Security Virtual Chapter!
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter....
2016-03-23
477 reads
Last Day to Submit Your Letter of Interest for the 2016 PASS Nominating Committee
I submitted my letter just a few minutes ago. It’s a template, doesn’t take more than 5 minutes to fill out and...
2016-03-23
489 reads
SQL Server Podcasts
Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help...
2016-03-23
394 reads
Color Themes for Power BI
Color coordination is important in report and dashboard design. We’ve seen theming and color pallet options in the prior iteration...
2016-03-22
1,178 reads
ETL Logging
If you were to poll data professionals on which tasks they enjoy working on the most, ETL logging would probably...
2016-03-22 (first published: 2016-03-14)
2,405 reads
Columnstore Indexes – part 80 (“Local Aggregation”)
Continuation from the previous 79 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given the number under-the-hood performance & manageability improvements...
2016-03-21
552 reads
Columnstore Indexes – part 81 (“Adding Columnstore Index to InMemory Tables”)
Continuation from the previous 80 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Microsoft is doing an amazing job with...
2016-03-21
514 reads
Database Growth Trends – Idera Diagnostic Manager
How fast are your databases growing? Should I panic about a 1 TB database that has 100 GB free on disk? Am I safe with a 100 GB database...
2016-03-21
36 reads
Database Growth Trends – Idera Diagnostic Manager
How fast are your databases growing? Should I panic about a 1 TB database that has 100 GB free on...
2016-03-21
661 reads
Blogs
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...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
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