Query Data Store–SQL Server 2016
SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to...
2016-12-27
607 reads
New Formatting in #SQLPrompt
I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t...
2016-12-27
674 reads
A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup
I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery...
2016-12-26
474 reads
Query Store- Part 5: Checking forced plans and Query Store Failures
Most of you would know that using query store one can force query plans. Is there a need to check...
2016-12-26
1,896 reads
Configure Internal and Private Networking for Hyper-V Virtual Machines
In the previous tutorial, we went through how to setup “External Network” to access the internet on Hyper-v client machine....
2016-12-25
2,897 reads
User Contains Invalid Characters – Back to Basics
While creating database users, it is possible to encounter an invalid character error message. This article will help clarify the error message.
Related Posts:
Changing Default Logs Directory - Back...
2016-12-24
249 reads
User Contains Invalid Characters – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-24
1,918 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....
2016-12-23
5 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....
2016-12-23
13 reads
Indexes optimize for the system databases
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and...
2016-12-23
276 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