Future Data Driven is Coming Sept 27 for FREE
The Future Data Driven 2023 virtual conference is coming on September 27. Register today and save a note in your calendar. I have been honored to speak at this...
2023-09-07
28 reads
Speaking at the Future Data Driven Summit 2023
I’m going to give a lightning talk at the online (free) Future Data Driven Summit. The subject is How I saved 80% on my Azure Data Factory Costs. The...
2023-09-08 (first published: 2023-09-07)
12 reads
How to curb aggressive parallelism in Microsoft SQL Server
Microsoft SQL Server, like most modern database systems, can convert a query into a set of parallel instructions to improve efficiency. This is map-reduce before map-reduce was a popular...
2023-10-02 (first published: 2023-09-06)
469 reads
Running Flyway from PowerShell–A Gotcha
I ran across an interesting gotcha while trying to run a Flyway command from PowerShell. Specifically, the snapshot command and providing a parameter that is the snapshot.filename parameter. Someone...
2023-09-06
144 reads
Manually updating Statistics in SQL Server
Having up to date statistics is vital for getting the best performance out of your queries. Even though SQL Server automatically updates statistics in the background for you, you...
2023-09-06
34 reads
Power BI VertiPaq Engine: Optimizing Column Encoding
Power BI encoding is a powerful optimizing option that is often overlooked because it’s not visible in neither the Power BI Desktop tool nor in Power BI Service. Natively,...
2023-09-07 (first published: 2023-09-06)
706 reads
IRL #8: SQL Server Down
Problem: My PocketDBA® client called in with a non-responsive SQL Server. Application errors, timeout, alerts firing. SQL Server box is up, and the services are running. Background: This is...
2023-09-06
47 reads
Temporal Table Data Fixes
I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...
2023-09-29 (first published: 2023-09-05)
611 reads
SQL Server is not a Car
Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...
2023-09-05
49 reads
SQL Homework – September 2023 – Time for temporal tables.
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading
2023-09-27 (first published: 2023-09-05)
418 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
ALAMAT KONTAK BCA KCP Cikande WA {08218154393}
WA:08218154393 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok C-6,...
ALAMAT KONTAK BCA KCP Ciceri Telp:08218154393
WA:08218154393 Jl. Jend. Sudirman No.38, Sumurpecung, Kec. Serang, Kota Serang, Banten 42118
Alamat Kantor BCA KCU SIDOARJO Wa(082144477715)
Wa:0821-4447-7715 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers