(Amit Agarwal) Ever thought of SQL (on VM or On-Premise server) Input Trigger for the Function app?
Tag: sql server
Fun with sp_rename
(Kenneth Fisher) Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in the near future. There is a new command RENAME that is specifically for Azure SQL Data Warehouse and Parallel Data Warehouse.
Checklist for Finalizing a Data Model in Power BI Desktop
(Melissa Coates) My colleague and friend Meagan Longoria has been giving me a few “gentle nudges” to update an old post about this topic:
Azure SQL Analytics
(Arun Sirpal) Azure SQL Analytics is currently in preview mode, still it is very impressive. The goal of this feature is to visualize important SQL performance metrics for your Azure SQL Database. There are a couple of things you need to do first.
Limitations When Working with SQL Server Views
(Ben Richardson) Views in SQL Server are nothing more than saved SQL queries. Views provide an abstraction layer to underlying data, simplifying data access. However there are certain limitations for SQL Server views.
SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?
(Pinal Dave) One of my clients reported an issue where they were running low on free disk space on the drive where they have file-stream files.
Script to find failed SQL Server Backups and validate re-running code was successful
(K. Brian Kelley) We have notifications configured to let us know when a backup job fails. However, that doesn’t tell me if we successfully re-ran the backup job and now have a good backup.
What is impersonation for?
(Kenneth Fisher) I was doing some research on impersonation the other day, and among other things, I ran across a forum question Use of IMPERSONATE permissions in SQL Server?
How SQL Server containers can help ease database deployment
(Robert Sheldon) Docker containers can make the SQL Server deployment process more efficient and flexible. Here’s what they are and how to get started on creating containers for SQL Server databases.
Seeking response on: LDAP Authentication with SQL Server 2017 on Linux
(Manoj Pandey) Few days back I got an email from one of the reader of this blog “Amit Bhatt”. As I haven’t worked much with the AD/LDAP stuff, thus I thought to throw this question to you guys thru this blog post.
