Struggling With Due Diligence
It’s been a while since my last post, there are various reasons for my absence: work, illness, having our house...
2016-06-23
531 reads
SQL Swimmer
Did you know?
Did you know that the call for speakers for PASS Summit 2016 opened on February 3, 2016?
Did you know that...
2016-02-15
428 reads
What is Power BI?
One of the “benefits” of being a chapter leader is that sometimes it means doing a presentation yourself when you...
2016-02-02 (first published: 2016-01-25)
3,015 reads
What Do You Want?
It’s that time of year, planning for PASS Summit 2016. We’ve already put out the Call for Volunteers, which closes...
2016-01-22
375 reads
We Want You!
It seems like PASS Summit 2015 was just yesterday and here we are again, getting ready for Summit 2016 already. ...
2016-01-08
403 reads
Scripts – A Living History
As a DBA, I have a collection of scripts that I use for anything from auto-fixing logins to seeing who...
2015-11-20
965 reads
Aggregation Design is Back!
If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012...
2015-11-19
463 reads
One Tool to Rule Them All – Almost
There we so many cool announcements at the PASS Summit this year, but one of my favorites was the “One...
2015-11-18
593 reads
My Build and Deploy Process (as Requested by Bill Fellows)
Recently I attended Reg-Gate’s SQL in the City event in Seattle, WA. I was in Seattle for the annual PASS...
2015-11-10 (first published: 2015-11-05)
2,659 reads
The Whirlwind That Is October – Part 3
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-11-03
505 reads
Blogs
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...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
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