Thanks to all 180+ of you who joined the Data Architecture Virtual User Group for a hour all about SQL Server 2019! We reviewed everyone's favorite new features of...
2020-01-22
68 reads
This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...
2020-01-21
4 reads
This won’t be the last blog I write for six weeks, but it is the last one I’ll syndicate and in which write about technical stuff. Today is my...
2020-01-21 (first published: 2020-01-10)
381 reads
Jon Shaulis (blog|twitter) is hosting T-SQL Tuesday this month. Thanks Jon! And the subject is obvious if you read the ... Continue reading
2020-01-21 (first published: 2020-01-14)
561 reads
A few years ago, I wrote about my first experience speaking at SQL Saturday. Recently I had a conversation with one of our first-timers speaking at SQL Saturday Rochester...
2020-01-20
I am super excited to announce that I have been selected to speak at SQL Saturday Spokane on March 21, 2020. Not only have I been selected to speak,...
2020-01-20
9 reads
In this video, David give a quick introduction into the Undercover Catalogue.
2020-01-20
36 reads
Working with Extended Events will help you become a better DBA. Working with PoSh can also help you in many various tasks to become a better DBA. Combine the...
2020-01-20 (first published: 2020-01-10)
272 reads
Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog...
2020-01-20 (first published: 2020-01-09)
482 reads
When you use delta lake there are a couple of interesting things to note based around the fact that the data is stored in parquet files which are read-only...
2020-01-20
12 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...
i have subscription of github copilot which i can access in vs 2022 comunity...
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
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