Synchronously Refreshing a Power BI Dataset using Azure Logic Apps
The post Synchronously Refreshing a Power BI Dataset using Azure Logic Apps appeared first on SQLServerCentral.
Learn PostgreSQL – New Technology Week
This is the last week of the year and most places it is a holiday. While we learn about SQL Server entire year, let us get out of the comfort zone and learn about different technology every day of the week. Today we will discuss where we can learn Post …
Performance Tuning Using Extended Events: Part 2
Performance tuning is the process of analyzing query plans, execution plans, indexes, partitioning, etc. and finding ways to reduce the time a query takes or reduce resource usage by that query. There are four events that I found can help you to i …
My Home Office Studio Setup: Winter 2019
I run a lot of online training classes, and some of you who do webcasts from home might be interested to see how all this works. I did pretty well this year, so I upgraded my home office setup to sneak some expenses in on my taxes. Here’s what I …
Learn MariaDB – New Technology Week
This is the last week of the year and most places it is a holiday. While we learn about SQL Server entire year, let us get out of the comfort zone and learn about different technology every day of the week. Today we will discuss about where we can lear …
Querying database schema using graph tables
SQL Server 2017 introduced the concept of graph data tables as part of the SQL Server database engine. With SQL Server 2019, there were some enhancements like ‘shortest path’ function and constraints on edge tables that make this feature mo …
SQL Prompt by Keyboard
The post SQL Prompt by Keyboard appeared first on SQLServerCentral.
How to Restore Model Database in SQL Server
The post How to Restore Model Database in SQL Server appeared first on SQLServerCentral.
Can Admin Rename SA Account in SQL Server? – Interview Question of the Week #256
Question: Can Admin Rename SA Account in SQL Server?Answer: Yes, of course. The syntax for to rename SA account is very simple:Can Admin Rename SA Account in SQL Server?ALTER LOGIN sa WITH NAME = [SQLAuthority]Every single time when I ask this question …
SQL SERVER – Parameter Sniffing and OPTIMIZE FOR UNKNOWN
I consider myself fortunate that I often receive a follow-up question from my earlier blog posts. Today we will discuss Parameter Sniffing and OPTIMIZE FOR UNKNOWN. In the earlier blog post, I had discussed how one can avoid the parameter sniffing by d …
Database Security, People and Processes
Database developers and DBAs can use many “mechanical” security mechanisms to safeguard corporate data. Robert Sheldon has written an excellent six part Introduction to SQL Server Security covering most of them. However, DBAs know that thes …
SQL SERVER – Parameter Sniffing and Local Variable in SP
After reading yesterday’s blog post about SQL SERVER – Parameter Sniffing Simplest Example, I received a follow-up question from my client with whom I have worked earlier in a recent consulting engagement of Comprehensive Database Perf …
Overview of Azure SQL Database Networking
The post Overview of Azure SQL Database Networking appeared first on SQLServerCentral.
Voting Open for #SQLBits Sessions, and Here’s My Oddball Idea
Voting is open now for SQLBits sessions, and I have to warn you that there are a LOT of sessions to choose from. Bits doesn’t just flat out take the top vote-getting sessions – they use votes as part of the session selection factor – …
Wait statistics workshop at SQLBits in London 2020 – finally!
We’re coming to SQLBits finally! Both Kimberly and I will be there for the first time in London in March/April – at long last the dates work for us – plus Erin will be there again too. The training day schedule for the conference …