(blobeater) There is a new way to setup Azure elastic jobs to run against a target group of databases (targeting an elastic pool).
Tag: sql server
Consulting 105 – Why Don’t I Want My Customers to Return for the Same Problem? – SQL Server Performance Tuning
(Pinal Dave) This is the fifth of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement.
Create File with Content Using PowerShell
(Tim Smith) In this tip, we’ll look at some of the basics of creating files with PowerShell. We may create files to add data, creating flags for processes, specifying formats, or formatting output in a manner we can use in spreadsheets or database tables.
Consulting 104 – Why Do I Give All the Performance Tuning Scripts to My Customers? – SQL Server Performance Tuning
(Pinal Dave) This is the fourth of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement.
Writing and Testing Azure Functions with Function Monkey – Part 3
(James) Part 3 of my series on writing Azure Functions with Function Monkey focuses on writing tests using the newly released testing package – while this is by no means required it does make writing high value acceptance tests that use your applications full runtime easy and quick.
Microsoft SQL Server: Current Identify Column Value in a Table
(Greg Larsen) What is the current identify column value in my table?
Power BI Drill Through Example
(Scott Murray) Does Power BI include any drill through navigation features? Can filters be applied to the drill through process?
Power BI Sentinel: Backup, Documentation, Change Tracking And Lineage Tracking For Power BI
(Chris Webb) A few weeks ago at SQLBits I had a demo of a very interesting new tool for Power BI users called Power BI Sentinel. The website, with all the details, is here:
Connect To SQL Server – Back to Basics
(Jason Brimhall) The first critical task any data professional should ever learn how to do is how to connect to SQL Server. Without a connection to SQL Server, there is barely anything one could do to be productive in the data professional world (for SQL Server).
If It Requires A Change Control Ticket To Change It, It Should Be In The Change Control System
(Denny Cherry) I’ve seen a couple of conversations recently about companies that want to be able to script out their database schema on a daily basis so that they have a current copy of the database; or systems that have to change permissions with the database frequently, and they need to export a c
