What Are You Thankful For
Bob Pusateri (B | T) wrote a blog post yesterday for anyone who was interested on sharing what they were thankful...
2014-11-18
517 reads
The SQL Professor
T-SQL Tuesday #60 Roundup – Step Right Up
We had a great turnout for this months T-SQL Tuesday Block Party. Coming into this month and knowing that I...
2014-11-16
609 reads
T-SQL Tuesday #60 Something New Learned
So, here it is. I put the challenge out to discuss something new learned last week. I was fortunate enough...
2014-11-11
598 reads
T-SQL Tuesday #60 – Something New Learned
Lights go on, it’s another game day, grabbed my bat and headed for the plate only this time we are...
2014-11-05
564 reads
Im At Summit Now What?
Pass Summit 2011 – Photo Provided by Pat Wright
We are a week out from PASS Summit 2014 and there will be...
2014-10-28
586 reads
T-SQL Tuesday #59 – My Hero!
It always amazes me how fast these T-SQL Tuesday block parties come about; it seems like we just finished one...
2014-10-14
594 reads
The Question – Why?
The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...
2014-10-14 (first published: 2014-10-06)
5,935 reads
C-R-U-D The Basics
C-R-U-D The Basics
What is CRUD? Well, there are a lot of things I can think of when I use the...
2014-10-09 (first published: 2014-10-01)
8,114 reads
Passwords – A T-SQL Tuesday Topic
Being engrossed with the daily tasks at hand I completely missed this month’s T-SQL Tuesday is being brought to you...
2014-09-18
307 reads
SQL Prompt 6.4 – Get It
This guy looks just like me a few weeks ago only one difference…..he has hair!!! Okay seriously though, I felt...
2014-09-18
458 reads
Blogs
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common...
A New Word: Lackout
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Delta Lake over Spark Connect
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
Forums
Shades and Reflecting on SQLBits and the Bright Future of Data
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
Merge techniques
In Azure SQL DB, i want to merge records from the staging table to...
SSRS error: The Value for the image 'Image1' has a constant value...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
Question of the Day
Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers