Daily Coping 2 Jul 2021
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-02
16 reads
Blog Posts
EightKB Summer 2021 Edition
The schedule for EightKB Summer 2021 Edition has been announced! Here’s the schedule: – N.B. – I particularly like that if you click on the session on the website,...
2021-07-02 (first published: 2021-06-15)
195 reads
Is the [sysname] SQL Server System Data Type Alias Name Case-Insensitive?
(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
105 reads
Quickly Determining Azure SQL Database Size
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
50 reads
Daily Coping 1 Jul 2021
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
12 reads
I Still Can’t Believe It!
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
20 reads
MVP for Another Year 2021-2022
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
26 reads
SQL Homework – July 2021 – Log shipping
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
24 reads
Daily Coping 30 Jun 2021
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
36 reads
Data Mesh: Centralized vs decentralized data architecture
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
14 reads
Blogs
Webcast Tomorrow on SQL Server Disaster Recovery
By Brian Kelley
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL...
SQL Server Quickie #48 – Azure SQL Managed Instance
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking...
Spark Connect Dotnet November 2024 Where are we?
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
Forums
Generating (semi-)fake purchase data
I know how to generate fake data (thanks to Jeff Moden's articles!)... the problem...
Export database and tables no table data
Trying to move a database from one sql server instance to another on separate...
Package to Project model conversion
Hi All, With previous customer range we were always required to work in the...
Question of the Day
What's the Ceiling?
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers