TSQL Tuesday #63 – Security
This months T-SQL Tuesday is hosted by none other than Kenneth Fisher (B|T). His topic for this month revolves around...
2015-02-12
560 reads
The SQL Professor
Friends Of Red Gate 2015
I’m excited that I’ve been asked to be back involved for another year in the Friends of Red Gate program. This...
2015-01-27
512 reads
Impact Player Series – Part 1
I wanted to start this series in regards to impact players that go above and beyond in the SQL Community....
2015-01-26
565 reads
A Healthy SQL Server
T-SQL Tuesday has come and gone and I missed the boat due to some ongoing work constraints. With that said...
2015-01-19
546 reads
Impact Players – SQL Style
Awhile back I did a post on my Fab Five – was one of my favorite ones I’ve done to date...
2015-01-12
418 reads
Reports In SSISDB
I was approached with an in shop issue where a group could not view the execution reports in the SSISDB....
2015-01-09 (first published: 2015-01-07)
10,556 reads
Blink – Year is gone
As the door begins to knock I start to wonder who it can be. As I begin to open it...
2014-12-22
496 reads
SQL Sentry Plan Explorer – Don’t Leave Home Without It
If you’ve been around me long enough then you realize that I am a Red Gate fanatic. With that said...
2014-12-09
1,140 reads
T-SQL Tuesday #61 – Giving Back
It just seems to me that these block parties of T-SQL Tuesday come quicker each month. I’m always thrilled when...
2014-12-12 (first published: 2014-12-09)
4,579 reads
PASS Summit 2014 ~ My GameTime Experience
“How did you like your convention?”
“How was your trip?”
“What did you learn?”
“Where did you go for a week?”
“Who did you...
2014-11-25
1,536 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