The SQL Server Security Model, Part 1: Logins [Foundations Friday]
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
764 reads
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
764 reads
Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...
2016-01-21
440 reads
Happy New Year, and welcome back! One of the projects I undertook over the holidays was to give the site...
2016-01-12
279 reads
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-23 (first published: 2015-11-17)
2,128 reads
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-17
407 reads
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-17
392 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
322 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
213 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
218 reads
Thanks to everyone who participated in week 1 of the SQL New Blogger Challenge! Eight posts were written this week...
2015-11-07
420 reads
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Life's Little Frustrations
Comments posted to this topic are about the item When INCLUDE Columns Quietly Inflate...
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers