PASS Subcommittee
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer. This past week I got word back concerning that...
2011-03-31
Jason Brimhall
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-03-30
3,876 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with it a bit lately to make sure I have...
2011-03-30
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain...
2011-03-29
904 reads
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain functionality in SQL Server, you have some presentation scripts...
2011-03-29
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is...
2011-03-28
1,855 reads
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is really not too big of a deal. While demonstrating...
2011-03-28
11 reads
SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either...
2011-03-25
1,313 reads
Tools note
I was asked a few months ago to allow some advertising on my blog. I hadn’t given the idea a...
2011-03-24
827 reads
Tools note
I was asked a few months ago to allow some advertising on my blog. I hadn’t given the idea a whole lot of thought but was reminded again today...
2011-03-24
2 reads
Blogs
Master the Foundational Basics
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Forums
How to write this query?
Hi everyone I have two tables storing stock prices. Each table comes from a...
ssrs order of operation question
hi i need "sample size" in my report's 4th data region which is a...
Query Network Protocols from T-SQL or PowerShell
Hello experts, I want to be more organized about the SSL certificates we have...
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers