Basic Inner Joins – Basic Skill #4
This post is part of a series based on my presentation The Top Ten Skills You Need for SQL Server....
2011-10-04
1,553 reads
This post is part of a series based on my presentation The Top Ten Skills You Need for SQL Server....
2011-10-04
1,553 reads
Today Steve Jones talks about learning those advanced features that you don't get the chance to use in your daily work.
2011-10-04
323 reads
When you create a SQL Server login (with SQL authentication), you have the option of enforcing password policies from Windows...
2011-10-03
6,197 reads
SQL Bits was great
It’s been two years or more that I’ve been invited to SQL Bits. Not by email, but...
2011-10-03
1,262 reads
A series training in the UK is happening this week. Read more to find out any of the 16 user group meetings can fit into your schedule.
2011-10-03
2,008 reads
This editorial was originally published on Oct 17, 2006. It is being republished as Steve is at SQLBits 9 today. Should we change the way we deal with posts and replies? Answer today.
2011-09-30
68 reads
I made it to Cambridge and actually feel OK. I wonder how I’ll feel tomorrow, but the two day adjustment...
2011-09-29
802 reads
Steve Jones talks about his trip to SQL Bits 9: Query Across the Mersey, which begins today.
2011-09-28
83 reads
When you have a disaster, the time that you have to restore service is usually referred to as the RTO...
2011-09-28
1,271 reads
It’s an interesting article on how to pay people from Dan Ariely at Business Week. It’s a look at some...
2011-09-27
1,152 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