SQL Server Indexing Book Giveaway – Part 7
More of the same with the next Expert Performance Indexing for SQL Server book giveaway. So far, I’ve sent out six copies of...
2016-08-01
812 reads
Blog Posts
There Is No Difference Between Table Variables, Temporary Tables and Common Table Expressions
I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was “personal...
2016-08-01
1,407 reads
Top 3 books for Becoming TOGAF Certified
I often get asked what books are useful for preparing for the TOGAF certification exam. The resources are generally from...
2016-08-01
982 reads
Speaking at IT/Dev Connections!
I’m proud to announce that I will be speaking at IT/Dev Connections on October 11th 2016 in Las Vegas! I...
2016-07-31
647 reads
Speaking at IT/Dev Connections!
I’m proud to announce that I will be speaking at IT/Dev Connections on October 11th 2016 in Las Vegas! I can’t begin to tell you how excited I am...
2016-07-31
17 reads
The End of the BAC–Why?
In a post titled The Future of the BA Community PASS announced that there would be no Business Analytics conference...
2016-07-30
827 reads
Columnstore Indexes – part 86 (“New Trace Flags in SQL Server 2016”)
Continuation from the previous 85 parts, the whole series can be found at http://www.nikoport.com/columnstore/
With the release of SQL Server 2016,...
2016-07-29
970 reads
Database Sessions at VMworld 2016
This year’s involvement in VMware‘s VMworld conference is up on the content catalog! I am extremely proud to announce my participation...
2016-07-29
878 reads
Deploying Row Level Security with SQL Compare
Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for...
2016-07-29 (first published: 2016-07-25)
1,299 reads
Off-Topic: Phone number spoofing. Why is this still a thing?
A bit of history
Long ago there were such things called diverters. The phone company used them so employees could dial...
2016-07-29
911 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