Accessing XML and JSON content
Building on my earlier post of JSON and XML data, using the same table today we will take a look at accessing data. With that… Read More »Accessing XML and JSON content
TSQL
SQL 2019 Page and Row Compression with XML and JSON
On a week long theme on XML and JSON in SQL Server, this is the second post. After the first post of just showing how… Read More »SQL 2019 Page and Row Compression with XML and JSON
JSON and XML in SQL Server
This post is the first in a series of blog posts around using XML and JSON in SQL Server. XML has been supported, although slightly… Read More »JSON and XML in SQL Server
How Much Backup History is Too Much?
How much is too much when it comes to backup history. What we are talking about here is how much backup history do you want… Read More »How Much Backup History is Too Much?
SQL Server Text Data – Reclaiming space
Earlier in the week I answered a question about reclaiming space, and after that post, I decided to put it into a video. Take a… Read More »SQL Server Text Data – Reclaiming space
Setting text field to empty or null does not release the space used
Here is a quest that was submitted on the blog today. HelloJust have a question about a table of mineone of the columns is of… Read More »Setting text field to empty or null does not release the space used
Script to bulk add SysAdmins to SQL Server
Recently I had a project where I needed to add a number of logins as SQL Server sysadmin users to several SQL Server instances. Rather… Read More »Script to bulk add SysAdmins to SQL Server
Size of all databases on an instance
Occasionally I have the need to look up the size of all databases on an instance, based on the log file size and the data… Read More »Size of all databases on an instance
Who does SQL Server run xp_cmdshell command as?
When you execute xp_cmdshell SQL Server runs a command at the operating system level similar to the old DOS prompt, or CMD shell. There are… Read More »Who does SQL Server run xp_cmdshell command as?
SQL Server – Writing to a File
Posted 3/29/2020 — Edited 3/30/2020 to fix a couple of copy and paste errors, and to clarify a couple of items. Thanks Charlie for your… Read More »SQL Server – Writing to a File