SQL Server – Do temporary work with temporary Stored Procedures & tables

SQL Server temporary tables and global temporary tables: For temporary work, we use temporary tables and global temporary tables. There is nothing complex about their usage. Use Temp tables if only your sessions needs access to the data in the temp table using the #TempTable naming format. To share data in a temp table across … Continue reading SQL Server – Do temporary work with temporary Stored Procedures & tables

Setup a Linked Server to MS Access from SQL Server – Beat the errors

Normally, it is easy enough to setup a Linked Server on SQL Server to other data sources. Problems are usually caused by one of the usual culprits that have to be addressed SQL Logins simply do not work well when trying to do this type of setup The Windows login has to have permissions to the … Continue reading Setup a Linked Server to MS Access from SQL Server – Beat the errors

“Practical PowerShell for Developers/DBA’s – 0 to 60 in 60 minutes” Presentation

Thanks to everyone who attended my "Practical PowerShell for (BI) Developers/DBA's - 0 to 60 in 60 minutes". The material accompanying the presentation is available for download here: https://1drv.ms/u/s!Amo-DPh_8ru9hT1W-bA2NadBAajK Feel free to experiment with the code and post feedback/comments. Please reach out if you have questions.