Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!
Microsoft has announced that SQL 2014 was in fact an elaborate April Fool’s joke and that Microsoft intends to move...
2014-04-01
407 reads
SQLStudies
Default nullability of a new column
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs?...
2014-03-31
1,180 reads
Default nullability of a new column
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs?...
2014-03-31
1,038 reads
Collation: Expression
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-04-02 (first published: 2014-03-26)
1,726 reads
Collation: Expression
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-03-26
506 reads
Collation: Location
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-03-24
830 reads
Collation: Location
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-03-24
636 reads
Thank you!
I won’t be able to make it to the PASS Summit this year but I still consider myself part of...
2014-03-19
676 reads
Collation: Definition
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-03-19
1,977 reads
Start with stupid
True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked...
2014-03-17
573 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
any reason to avoid asking ssis to extract files from ftp
hi we have to replace talend which generally was used to move files. talend's...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers