The APP_NAME() function returns the application name of the current session. See what it returns in SSMS and how it helps you audit where data comes from.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Getting Started and Creating JSON Using SQL Server 2016 – JavaScript Object Notation
SQL Server 2016 adds JSON support. Here is a quick look at what JSON (JavaScript Object Notation) is and how to create your first JSON document with a query.
Interview Question of the Week #026 – 64 Bit Vs 32 Bit Confusion
Resolve 64 bit vs 32 bit questions for SQL Server, separate engine and client architecture, and inspect the actual Windows host.
SQL Server – 2016 – New Feature: Dynamic Data Masking
Would you want your credit card number shown in clear text? Dynamic Data Masking, new in SQL Server 2016, hides sensitive data right in the database.
SQL SERVER – Tips working with Files inside SQL Server
Placing data and log files on different drives is not the whole story. Here are my tips for working with files inside SQL Server as a DBA.
SQL SERVER – How Do We Find Deadlocks? – Notes from the Field #086
To Find Deadlocks, I collect the graph of competing sessions and resources. The cycle distinguishes a deadlock from ordinary blocking.
SQL SERVER – FIX – Export Error – ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
Importing an Excel file with the SSMS Import Wizard failed because the Microsoft.ACE.OLEDB.12.0 provider is not registered. Here is how I fixed it.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.