Selective Logging with the UPDATE() Function
Triggers can be very useful when you want to log changes to your data, but what if you’re only interested...
2016-06-22 (first published: 2016-06-16)
2,381 reads
Blog Posts
SQL Server Security Series, part 1
In the first entry in this SQL Server security series, we will demonstrate a brute force attack against SQL Server...
2016-06-22
484 reads
SQLSaturday Orlando 2016 Call for Speakers Closes July 17, 2016
We’ve advanced the closing date for the SQLSaturday Orlando call for speakers to July 17. That’s to give us time...
2016-06-22
396 reads
A Better (Free) Search in SSMS
A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we...
2016-06-21 (first published: 2016-06-15)
4,073 reads
Columnstore Indexes – part 85 (“Important Batch Mode Changes in SQL Server 2016”)
Continuation from the previous 84 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I wanted to write a blog post...
2016-06-21
501 reads
SQL Server Service Broker – Networking
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database...
2016-06-21
285 reads
What’s New in Reporting Services 2016
Today I had the pleasure of presenting to the Higher Ed Data Warehousing and BI Group. We discussed the long...
2016-06-21 (first published: 2016-06-14)
5,418 reads
Columnstore Indexes – part 84 (“Practical Dictionary Cases”)
Continuation from the previous 83 parts, the whole series can be found at http://www.nikoport.com/columnstore/
In this blog post I wanted to...
2016-06-20
620 reads
Comparing two query plans
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server....
2016-06-20 (first published: 2016-06-14)
3,358 reads
Implementing Fuzzy Sets in SQL Server, Part 0: The Buzz About Fuzz
By Steve Bolton
…………I originally planned to post a long-delayed series titled Information Measurement with SQL Server next, in which I’d...
2016-06-20 (first published: 2016-06-13)
2,409 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