My Surprise MVP Party
Two Fridays ago, Sean and I sat down for our weekly DBAs@Midnight webshow* as usual. Unusually, we were expecting an out-of-town...
2011-01-24
576 reads
SQL Awesomesauce
RTFM365, Week 7
[Commence whine-a-thon, thinly veiled as an introductory paragraph to a blog.]
As I knew it would, it is getting VERY difficult...
2011-01-24
483 reads
Blog Sins
Thoughts come together, and the hybridization of your thoughts give rise to new ideas. Here are the thoughts:
I have this...
2011-01-21
670 reads
Who do you want to see at SQLRally and 24HOP?
I dig democracy: I like all this voting for SQL sessions at events.
Voting is open this week, Jan17 – 23, for...
2011-01-19
613 reads
Un-SQL Friday: Your Tech Giants
This started as just a regular blog…but it’s sparked such a big conversation online, I’ve decided to make it an...
2011-01-19
1,078 reads
T-SQL Tuesday #014 Roundup
Wow…the inagural 2011 T-SQL Tuesday was so big, it lasted a week! A few quick observations, then on to the...
2011-01-18
1,266 reads
RTFM365, Week 6
Just a quick note this week….things are quite crazy right now, and I’m struggling to keep reading on my days...
2011-01-18
430 reads
T-SQL Tuesday: Resolutions
In my invitation to T-SQL Tuesday #014, I picked the topic “Resolutions”, clearly to play on the new year. The...
2011-01-11
747 reads
Top 10 SQL #Awesomesauce for 2010
Here at MidnightDBA.com, we’re all about you! And us! It’s just us, and you. Which is why I’ve put together...
2011-01-10
800 reads
RTFM365, Week 5
I’m trying to plan out this week better, and come at the RTFM readings with a sense of direction an...
2011-01-07
449 reads
Blogs
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Question of the Day
Using table variables in T-SQL
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