(last updated: 2021-07-02 @ 19:55 EST / 2021-07-02 @ 23:55 UTC ) The sysname data type (in SQL Server) is a system-provided, though not built-in, alias for NVARCHAR(128). This...
2021-07-02
125 reads
Recently I needed to determine how much storage space each database on a logical server was consuming. I was doing some DR testing and I need to give the...
2021-07-02
96 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-01
24 reads
I received my MVP award letter from Microsoft today. This will make the fourth time I’ve been awarded and I still can’t believe it. I just wanted to help...
2021-07-01
30 reads
A few minutes ago, I received an email from Microsoft presenting me with the 2021-2022 Microsoft Most Valuable Professional (MVP) award. This is my 8th award and I am...
2021-07-01
34 reads
Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy ... Continue reading
2021-07-01
44 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-06-30
43 reads
One of the biggest differences between the Data Mesh and other data platform architectures is a data mesh is a highly decentralized distributed data architecture as opposed to a...
2021-06-30
26 reads
I remember when I was first learning to code there was always the argument of how long a name should ... Continue reading
2021-06-30 (first published: 2021-06-15)
1,079 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wrote a previous post on how to...
2021-06-30
127 reads
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Wa:0817-866-887 Jl. Soekarno Hatta No.33, Trajeng, Kec. Panggungrejo, Kota Pasuruan, Jawa Timur 67111
Telp Cs: 08218200174 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera...
Telp Cs: (0821)8200174 Jl. Pangeran Diponegoro No.15, Petisah Tengah, Kec. Medan Petisah, Kota Medan,...
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