Easily Shred Event Data
It has been nearly a year since I started an extensive series about Extended Events. Previous to that start, I...
2016-08-04 (first published: 2016-08-01)
2,459 reads
Blog Posts
SQL Server 2016 Cumulative Update 1
On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to...
2016-08-04
330 reads
T-SQL Tuesday #081: Sharpen Something – Reminder
Sharpen Something
Last week I sent out the invite for the August TSQL Tuesday blog party. In that invite I promised...
2016-08-04 (first published: 2016-08-02)
1,395 reads
Great Value IT Training early August Update
Its that time of the week when get the latest Learning Tree courses that have been available for £750 plus...
2016-08-03
344 reads
Minimizing SQL Server DBCC CHECKDB Performance Impacts
Overview
SQL Server is the most popular relational database management system, which is used by many organizations to maintain their data....
2016-08-03
1,544 reads
SQL Server 2016 – Perform Volume Maintenance
One of the server settings that I always enable when configuring a new instance of SQL is database instant file...
2016-08-03
466 reads
Undocumented Commands
There isn’t really a need to do what I am doing in this blog post but I guess one reason...
2016-08-03
202 reads
Using impersonation to allow a task without granting the required permission.
I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can...
2016-08-03 (first published: 2016-08-01)
2,035 reads
What’s the difference between LEFT and RIGHT OUTER JOINs?
A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?”
There are several different...
2016-08-03
1,296 reads
DacFxed - Powershell Nugetized DacFx wrapper
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
45 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
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
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