Are you a new SQL Server DBA? Live Blog @LearningTree
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration course in LEC in London. Following on from...
2016-07-12
558 reads
Training To-Do List for New DBA
Are you an entry-level DBA, or looking to make the career switch? Feel like you are looking up from the...
2016-07-18 (first published: 2016-07-12)
4,947 reads
Improvements with SSMS 2016
The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However,...
2016-07-19 (first published: 2016-07-11)
3,622 reads
Monday Morning SQL Break – July 11, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. I spent the weekend with family...
2016-07-11
875 reads
Same Query, Different Servers, Different Performance. Now What?
Based on the number of times I see this question on forums, it must be occurring all the time. You...
2016-07-19 (first published: 2016-07-11)
2,430 reads
Tips to Fix Database Consistency Errors – Reported By DBCC CHECKDB
Overview
While working on SQL Server, sometimes users get stuck in annoying situations when database become inaccessible. After executing DBCC CHECKDB...
2016-07-11
6,092 reads
ETL Modularity
Imagine for a moment that you’ve built a software thing. In fact, we’ll call it Thing. You put a lot...
2016-07-18 (first published: 2016-07-11)
2,091 reads
Basic Statistics with SQL – Introduction
I was a student of statistics in school and college. I didn’t get to use much of anything I learned...
2016-07-10
679 reads
SQL Server – String_Escape function in SQL Server 2016
Hi friends, in SQL server 2016 another string function that introduced is String_Escape. This function can escape special characters within...
2016-07-10
1,525 reads
Join me for a free SQL Performance webcast on July 14th!
With less than we week away, I can say that I’m really excited to reach more people in the community...
2016-07-08
407 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
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
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...
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