Searching for People
Inside Redgate Software, someone posted a picture and was asking if anyone knew who the person was. In this case, there had been a conversation at an event, and...
2023-08-16
33 reads
Blog Posts
SQL Homework – August 2023 – Have the best practices changed while you weren’t looking?
It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We ... Continue reading
2023-08-16 (first published: 2023-08-01)
508 reads
T-SQL Tuesday #165: Database Job Titles Roundup
This month I prompted bloggers to talk about what database job titles mean to them. Thank you to all who posted on this topic! Don’t worry; if you still...
2023-08-16 (first published: 2023-08-15)
14 reads
Fill Out The State of the Database Landscape Survey and Maybe Win
If you’re like me, you sometimes wonder how different other environments are from the one I work in. Well, the ones I used to work in. These days I...
2023-08-15
7 reads
SQL Server Patching
Why should you patch your SQL Server instances? Compliance, stability, security, reliability, functionality, and more. Microsoft regularly releases updates to SQL Server known as Cumulative Updates (CUs). Cumulative updates...
2023-08-15
35 reads
Running SQL Server in Docker Swarm
I haven’t touched Docker Swarm for a looooong time but I was asked about running SQL Server in Swarm at a conference a while back…so here’s how it can...
2023-08-14 (first published: 2023-07-26)
363 reads
Which Schema is Queried First?–#SQLNewBlogger
I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. I wrote...
2023-08-14 (first published: 2023-07-26)
381 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-13 (first published: 2023-08-12)
2,238 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-12
33 reads
A New Word: Aubadoir
aubadoir – n. the outworldly atmosphere just before 5 am, when the bleary melodrama of an extremely late night becomes awkwardly conflated with the industrious flourescence of a very...
2023-08-11
199 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers