Daily Coping 6 Nov 2020
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...
2020-11-06
39 reads
[Solved] SQL Backup Detected Corruption in the Database Log
Summary: In this article, we will discuss about the ‘SQL Backup Detected Corruption in the Database Log’ error. It will also describe the reason behind the error and manual...
2020-11-06
26 reads
[Solved] SQL Backup Detected Corruption in the Database Log
Summary: In this article, we will discuss about the ‘SQL Backup Detected Corruption in the Database Log’ error. It will also describe the reason behind the error and manual...
2020-11-17 (first published: 2020-11-06)
2,732 reads
Microsoft Power BI Quick Start Guide – Second Edition
Earlier this week I announced the release of a new Power Platform book. While I’m super excited about that book I’m also excited to announce
2020-11-19 (first published: 2020-11-06)
701 reads
Adding a user to an Azure SQL DB
Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t ... Continue reading
2020-11-19 (first published: 2020-11-05)
367 reads
Daily Coping 5 Nov 2020
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...
2020-11-05
32 reads
Restoring Database Users After Copying the Database
A former colleague emailed me with a question about retaining/fixing database users and permissions after restoring a database. They were copying a database from one instance to another, with...
2020-11-04
3,128 reads
Redgate SQL Data Masker Refreshing Schema
This is a quick blog to help me remember what is going on with the Data Masker product. This is for the SQL Server version, but I believe the...
2020-11-04
48 reads
T-SQL Tuesday Retrospective #003: Relationships
In my quest to respond to every T-SQL Tuesday since the dawn of the end of 2009, it was only a matter of time before Rob Farley’s name came...
2020-11-04
31 reads
Daily Coping 4 Nov 2020
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...
2020-11-04
26 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers