SQL Server 2014 SP1 released, and revoked
Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has...
2015-04-16
629 reads
Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has...
2015-04-16
629 reads
Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a...
2015-04-07
506 reads
Today I learned that you can’t adjust the font size in SQL Server Management Studio’s Object Explorer pane. Nor registered...
2015-04-02
611 reads
I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)...
2015-03-16
576 reads
We’re in London right now for SQLBits, which has been ABSOLUTELY LOVELY so far. If you happen to’ve seen our...
2015-03-06
440 reads
We were having a good time on DBAs@Midnight, when Sean got a weird pop up message that said all his...
2015-02-07
1,113 reads
We released Minion Reindex version 1.1 last week. The changes are fairly small: Made sure Minion Reindex handles all nonstandard naming...
2015-01-29
1,252 reads
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...
2015-01-23
1,929 reads
It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes...
2014-12-15
643 reads
I’m reading Andy Warren’s excellent essay “Thoughts on raising funds and spending funds for PASS chapters”, and it’s bringing together...
2014-11-13
862 reads
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
i have subscription of github copilot which i can access in vs 2022 comunity...
Comments posted to this topic are about the item Password Guidance
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