Another Query to Help Find the Right Event
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with...
2016-07-21
5 reads
Blog Posts
Common Table Expression, Just a Name
The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that...
2016-07-21 (first published: 2016-07-18)
3,606 reads
Day 2: Agile Fundamentals: Scrum, Kanban, Lean and XP
It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum, Kanban,...
2016-07-21
412 reads
Great Value IT Training - 21st July
As I have mentioned in previous posts, we have done a deal with Learning Tree to be able to offer...
2016-07-21
328 reads
Join me at SQL Saturday 531, Louisville, KY
So, I have the privilege of not only delivering a regular session, Introduction to Power BI Desktop, at SQL Saturday...
2016-07-21
627 reads
Limitation of In-Memory OLTP in SQL Server 2016 – Sp_rename not allowed
Hi friends, one more limitation of In-Memory OLTP is SQL Server 2016 is that sp_rename is not allowed to change...
2016-07-21
511 reads
Off topic–Would you SQL your license plate?
I was recently browsing www.myplates.com and I’ll say it’s actually quite fun to see what plates people have randomly bought....
2016-07-21
592 reads
ReadyRoll and Octopus Deploy Webinar
I’ll be hosting a webinar next week, Thursday, July 28, with Daniel Nolan (t) (founder of ReadyRoll and fellow Redgate...
2016-07-21
567 reads
Rename a Primary Key–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-07-21
1,754 reads
SQL 2016 SSIS new feature AutoAdjustBufferSize
If you have not already seen in the What’s New in Integration Services list there is a new property for...
2016-07-21
1,754 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