Database Development Gone Wrong
I recently shared a story about how I was personally responsible for a development project going off the rails (and...
2019-03-13
431 reads
Blog Posts
Differences Between the Various Binary Collations (Cultures, Versions, and BIN vs BIN2)
(last updated: 2019-03-15 @ 02:45 EST / 2019-03-15 @ 06:45 UTC )
Binary collations are, in many ways, simpler to understand than non-binary collations...
2019-03-13
13,943 reads
Does SQL Server 2019 run on Ubuntu 18.04 LTS?
Yes. Here’s the proof from an output of SELECT @@VERSION: [crayon-5c98bf6b3202b962253620/] Here’s a screenshot of me running mssql-cli on the...
2019-03-13
687 reads
Enable Mail Profile – Back to Basics
I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to...
2019-03-13
272 reads
How Do You Export A Database in Azure Data Studio
I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I...
2019-03-13 (first published: 2019-02-25)
2,381 reads
PASS Summit 2019 Call for Speakers is Open – How I Sketch Out My Submission Ideas
Are you interested in speaking at the Professional Association for SQL Server’s annual Summit conference? The call for speakers is now open, and you may submit up to three...
2019-03-13
10 reads
Power BI Monthly Digest – March 2019
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of...
2019-03-13
947 reads
Quick tip: Zoom in Azure Data Studio
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis,...
2019-03-13
2,452 reads
Quick tip: Zoom in Azure Data Studio
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis, maybe you want to customize it to suit your...
2019-03-13
22 reads
SQL Server Deadlocks
A quick video clip showing how to create a deadlock in SQL Server and find information about it.
2019-03-13
1,122 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
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...
Forums
Alamat Kantor BCA KCU PONTIANAK Telp:082144477715
WA:0821-4447-7715 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
ALAMAT BCA KCU DAAN MOGOT Telp:08218200205
WhatsApp:08218200205 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
Alamat Kantor BCA KCU DAAN MOGOT Telp:0817781222
WA:08218154393 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
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