Wait Statistics in Azure SQL Database
You need to be aware that you’re going to see differences when you’re working with Azure SQL Database when it...
2016-03-07 (first published: 2016-02-29)
1,934 reads
Blog Posts
Get the Total Item Size for an Exchange database
Hey there!
This one is for those Exchange admins who think it is a sin to use hands for something that...
2016-03-06
791 reads
Columnstore Indexes – part 78 (“Temporary Objects”)
Continuation from the previous 77 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to spend some time...
2016-03-05
506 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports:
SQL Server default instance...
2016-03-05
84 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...
2016-03-05
16 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports:SQLServer default instance port...
2016-03-05
150 reads
SQL Server ports
When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...
2016-03-05
10 reads
Blogger questions: How often should I blog?
What with the #sqlnewblogger effort we’ve been seeing a lot of new bloggers (and some old ones starting up again)...
2016-03-04 (first published: 2016-02-29)
1,255 reads
Dynamic Data Masking
Here’s a new feature that I like very much: Limiting exposure of sensitive data like user emails, phone numbers, addresses,...
2016-03-04 (first published: 2016-02-29)
2,162 reads
PowerShell–Don’t Use Write-Host
I’ve written a few scripts and programs lately, mostly just for fun. In those scripts, I’ve used Write-Host to return...
2016-03-04
1,638 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