Recipe 8: Analyzing a Workload
Welcome to a new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...
2022-03-02
141 reads
Blog Posts
Traveling to SQL Bits
I’m heading to SQL Bits this weekend, and will be in London most of next week for the conference. I’m excited. SQL Bits is my favorite conference, as I’ve...
2022-03-02
14 reads
Understanding Volumes vs Storage Pools
In hindsight, I should have done this differently. In a previous post I discussed how I carved up 18TB of storage into various storage pools. Now that I have...
2022-03-02 (first published: 2022-02-18)
637 reads
Daily Coping 1 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-01
9 reads
Goal Progress for Feb 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. February became more of a work month for me, and...
2022-03-01
9 reads
Heap Tables
In today’s blog posting I want to talk about Heap Tables in SQL Server. Heap tables are tables without a Clustered Index. A table in SQL Server can have...
2022-03-01
385 reads
Recipe 7: Finding Unused Tables
Welcome toa new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the xesmarttarget...
2022-03-01
275 reads
Setup Resource-Based Kerberos Constrained Delegation for Group Managed Service Accounts
In my previous post, I discussed how to setup Kerberos constrained delegation and a limitation of using that method. This post will discuss how we can used resource-based Kerberos...
2022-03-01
190 reads
SQL Homework – March 2022 – Formatting
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries ... Continue reading
2022-03-01
18 reads
SQL Homework – March 2022 – Formatting
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries ... Continue reading
2022-03-01
1 reads
Blogs
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Advice I Like: Tipping
By Steve Jones
When in doubt, overtip – from Excellent Advice for Living This is close to...
Forums
What is the Affordable Price of Alectinib 150mg Capsule?
Online pharmacies are your only option if the need is to buy the affordable...
How Much AI Code Would You Use?
Comments posted to this topic are about the item How Much AI Code Would...
Browsing for Instances
Comments posted to this topic are about the item Browsing for Instances
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers