I’m Not Attending #sqlpass Summit 2012 and I’m Sorry For Myself
I really wanted to attent PASS Summit this year, I’ve never attended before. I was preparing myself mentally since the...
2012-10-12
684 reads
I really wanted to attent PASS Summit this year, I’ve never attended before. I was preparing myself mentally since the...
2012-10-12
684 reads
This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly...
2012-09-14
2,771 reads
Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and...
2012-08-15
14,365 reads
Apparently, SQL Saturday isn’t popular in the west. See for yourself. I wanted to see what cities frequently host SQL...
2012-08-03
1,546 reads
I’m having a little fun with documenting basic information about indexes in my current project. I’m posting the scripts here...
2012-07-31
2,080 reads
MaxConcurrentExecutables, a package level property in SSIS determines the number of control flow items that can be executed in parallel....
2012-07-20
19,040 reads
A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key...
2012-06-28 (first published: 2012-06-24)
7,707 reads
I occasionally review the search terms people use to get to this blog and secretly celebrate knowing my post helped...
2012-06-19
1,206 reads
Topic for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@SQLVariant) is Logging.
I like to think of logging as a...
2012-06-19 (first published: 2012-06-12)
3,789 reads
As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought...
2012-05-17
903 reads
Setting page visibility and the active page are often overlooked last steps when publishing...
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
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