Can you use Power Query to move data out of Excel and into SQL Server? Well, it turns out you can… with some limitations. This blog post details what I found out while researching this problem. I ...

On my local PC I have SQL Server installed and the Adventure Works DW 2017 and Contoso Retail DW sample databases: Both of these databases have date dimension tables called DimDate. Let’s say you want ...

Simply join two SELECT statements with the UNION keyword to combine the results of two queries into a new table. When working with databases other than Microsoft's SQL Server, check the manual to ...

SQL Server Permission Manager is a suite of scripts that allows you to take "snapshots" of users and permissions across any or all of the databases on your SQL Server. These snapshots then allow you ...

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...

Revokes permissions on a table, view, table-valued function, stored procedure, extended stored procedure, scalar function, aggregate function, service queue, or ...

Hekaton tables are fully transactional and durable and accessed using T-SQL in the same way as regular SQL Server tables. A query can reference both Hekaton tables and regular tables and a transaction ...

Part of the SQL Server 2022 blog series. Microsoft SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives ... CREATE EXTERNAL TABLE (CET): ...