First Class Jobs
This week Steve Jones examines the idea of making jobs in SQL Server, first class citizens.
2016-12-02
101 reads
Editorials
Learn to Earn
Learning more about your craft can translate into more earnings, but it won't be easy.
2016-12-01
106 reads
The Pressure to Compromise Ethics
There are always people that ask workers to deceive, defraud, or mislead customers. This is true for software developers as well.
2016-11-30
96 reads
Finally, Create or Alter
Today Steve Jones looks at the CREATE OR ALTER syntax, added in SQL Server 2016 SP1.
2016-11-29
162 reads
Hire the Right People
Today Steve Jones discusses the need to hire the people to do the tasks we need done, not the position we filled.
2016-11-28
124 reads
Online T-SQL Scripts and Copyright
The issue of copyright for online scripts is a grey area. If a script is published without any form of copyright notice, most people assume that it is freely available for reuse. It's not necessarily the case.
2016-11-25 (first published: 2009-04-20)
636 reads
2016-11-24
51 reads
Monitor All the Changes
Today Steve Jones looks at the potential downfalls of monitoring every change without lots of filtering.
2016-11-22
97 reads
2016-11-21
159 reads
2016-11-21
162 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