Speaker of the Month: March 2016
I’m finally getting back out to community events so I should be able to avoid giving this gigantic honor to professional...
2016-03-04
409 reads
Blog Posts
Fix a Network Binding Order Warning
Network Binding Order Warning One of the more common errors I see when setting up a Windows cluster (usually in...
2016-03-03 (first published: 2016-02-26)
1,724 reads
How to Grant Permissions Only on the Replica in Database Mirroring and AlwaysOn AG
You work with Database Mirroring or AlwaysOn AG, and you want to make sure your end users work only on...
2016-03-03
308 reads
My favourite wait state– ASYNC_NETWORK_IO
Sometimes it does feel that a problem is a database problem until proven otherwise. When this does occur I have...
2016-03-03 (first published: 2016-02-28)
2,836 reads
Post Deploy Scripts In Composite Dacpacs not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy...
2016-03-03
46 reads
Post Deploy Scripts In Composite Dacpacs not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy...
2016-03-03
38 reads
Post Deploy Scripts In Composite Dacpacs not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy into a database as a whole. Even if you...
2016-03-03
6 reads
Post Deploy Scripts In Composite Dacpac's not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy...
2016-03-03
811 reads
Cross-database queries in Azure SQL Database
A limitation with Azure SQL database has been its inability to do cross-database SQL queries. This has changed with the...
2016-03-02
710 reads
Find failed SQL Job in last 24 Hours using Powershell
This post is based on the request to get failed SQL jobs in last 24 hours and output should be...
2016-03-02
670 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