SQL Math: Whole Numbers, Real Numbers
It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no...
2011-03-28
1,870 reads
SQL Awesomesauce
An Analogy is like a Tree….
For years, I’ve been trying to express how everything ties into everything else. A big part of understanding any given...
2011-03-25
485 reads
Maaaaaagic Tables!!!
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-24
2,377 reads
Not Cool Enough for Firefox
I’m pretty consistently behind the curve on most things. It took three years for me to get into The Office...
2011-03-22
874 reads
Filmed: DBAs@Midnight Episode 2.30
Friday night (as per usual) we filmed a new episode of our 2 1/2 year old webshow, DBAs@Midnight in front...
2011-03-19
845 reads
Women in Technology SQL Lunch!
Attend SQL Lunch...the power of my sweater compels you...
This week on Friday, March 17 we’re having a free panel talk,...
2011-03-17
659 reads
24 Hours of PASS Spring 2011 Code Sins
Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring...
2011-03-15
668 reads
SQL University – Teach Your Children Well
“If you had a daughter, would you really encourage her to get into IT?” … “Yes, if she loved it.”
- My...
2011-03-10
968 reads
T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!
Let’s get this out of the way right now: I am SO going to take advantage of this T-SQL Tuesday...
2011-03-08
891 reads
Women in Technology PPT Template
Well hey-howdy-hey (as we don’t say in Texas), it’s Women’s History Month! And by all accounts, it’s going to be a...
2011-03-04
1,008 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
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
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