2017-01-30
68 reads
Editorials
The New SQL Server 2016 Edition Limits
There are some changes to memory limits in SQL Server 2016 SP1 Standard Edition.
2017-01-26
1,638 reads
The War Room
When things go wrong, how do you handle them? Steve Jones comments on crisis management using a great example from Amazon.
2017-01-25
197 reads
Something I learned while unemployed
Being unemployed is difficult. Here's something I learned to help me through it.
2017-01-24
276 reads
2017-01-23
108 reads
2017-01-23
94 reads
Legacy Limits
Sometimes the hardware or software we use prevents upgrades, which isn't necessarily good for any of us.
2017-01-20
76 reads
2017-01-18
178 reads
Delaying Patches is Problematic
Many of our security issues come down to not patching software when there are updates available.
2017-01-17
110 reads
The Development Lab
This week Steve Jones looks at hardware and the ways in which you might assemble a set of computers for building software.
2017-01-16
52 reads
Blogs
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
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