Name the schema when you create an object (or else)
This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...
2016-04-06
698 reads
Blog Posts
Quick Encryption with Always Encrypted
What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted?...
2016-04-06
834 reads
SSIS Trick: Adding Multiple Packages to a Project
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing...
2016-04-06
16,930 reads
SSMS Preview Plan Comparison Tool and Plan Viewer Optimizations
With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS,...
2016-04-06
707 reads
Tools of the trade
I’ve been meaning to write this post for a while now, nice and simple, just want to list the tools...
2016-04-06
526 reads
TSQL– Search for Strings in Object Definitions
I have been working nn an environment that had multiple copies of a database on the same SQL server instance....
2016-04-06
348 reads
Configure SQL Server Database Mirroring: Step By Step
Database Mirroring in SQL Server is deployed as a method to increase the availability of a SQL Server database in...
2016-04-05 (first published: 2016-03-25)
97,605 reads
MongoDB -Calculating Collection Size
Calculating Collection Size
We can get the size of a collections by using the shell’s functions
db.collection.dataSize(): Returns data size in bytes...
2016-04-05
678 reads
Partitioning and filegroup restores
I’ve been playing around with partitioning quite a lot recently and wanted to write a quick post about how it...
2016-04-05 (first published: 2016-03-24)
1,759 reads
Power BI Embedded is here
The announcement of Power BI Embedded came last week during Microsoft’s Build Conference and now enables software vendors or anyone...
2016-04-05
575 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
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...
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