I am a SQL Administrator and today I will share my experience about an issue on SQL server, which corrupted the transaction logs and left the database in a...
2019-09-25 (first published: 2019-09-17)
2,867 reads
I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. ... Continue reading
2019-09-25
24 reads
In my final post about gatekeeping in technology, I have to come clean about something. Let’s go through this journey together. In the first post we spoke about what...
2019-09-25
16 reads
An amazing blog post by Microsoft describing the idea of hot patching the database engine in Azure SQL Database to allow for minimal downtime when applying patches to SQL...
2019-09-25
35 reads
I’m going to lose today again. This time I’m headed back to Australia and in flight. I wonder if I’ll get used to this, as I expect between work...
2019-09-25
22 reads
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on Github. This dockerfile was under the mssql-server-linux-non-root directory and (you guessed it) allows SQL Server...
2019-09-25 (first published: 2019-09-18)
998 reads
Do you frequently use the “log_reuse_wait_type_desc” column in the [crayon-5f297eff3d7ff981952735-i/] view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting...
2019-09-24
1,493 reads
At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....
2019-09-24
324 reads
At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....
2019-09-24
14 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-24 (first published: 2019-09-17)
1,002 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers