2022-09-21
498 reads
2022-09-21
498 reads
Recently I needed to check the compatibility level of a database and SSMS didn’t work. This is what I did in T-SQL.https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16 Another post for me that is simple...
2022-09-21
19 reads
SQL Server on RDS has a more configurable option that allows you to meet the specific requirements of your application in a similar was as you would on-premises, while still being a managed service.
2022-09-21
191 reads
Today’s coping tip is to leave positive messages for yourself to see regularly. I could use post-its, or something else, but something that has worked well for me with...
2022-09-21
8 reads
Today’s coping tip is to find a caring, calming phrase to use when you feel low. Life is mostly good, but there are times I feel down, depressed, low,...
2022-09-20
6 reads
A traffic cop isn't a great analogy for a DBA, but all too often it is an accurate one.
2022-09-19 (first published: 2018-03-20)
282 reads
Today’s coping tip is to make time to remember if you’re busy, allow yourself to pause and take a break. I’m in the UK today, and at the Redgate...
2022-09-19
8 reads
2022-09-19
482 reads
Today’s coping tip is to make time to aim to be good enough, rather than perfect. I find that many of us that work in technology want a solution...
2022-09-16
5 reads
I was honored to speak at Future Data Driven last year. This year has a great lineup with some fantastic sessions on data related topics. Register today for the...
2022-09-16 (first published: 2022-09-02)
177 reads
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers