Putting counters in names
It’s not all that unusual, or unreasonable to put a counter in a name. For example let’s say you need ... Continue reading
2022-10-03 (first published: 2022-09-13)
557 reads
Kenneth Fisher
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant to go out 9/29) Brent Ozar ... Continue reading
2022-10-01
111 reads
What’s next 4th time
It’s now been about two and a half months since I was given notice and decided to blog about my ... Continue reading
2022-09-28 (first published: 2022-09-08)
210 reads
Creating a SERVER ROLE created a LOGIN as well.
One of my co-workers came to me the other day and told me that they found their network id as ... Continue reading
2022-09-21 (first published: 2022-09-06)
339 reads
Conversion Precedence
Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the ... Continue reading
2022-09-20
19 reads
Making the mouse pointer easier to see.
I know this is way off my usual content but the other day someone was mentioning how easy it is ... Continue reading
2022-09-15
23 reads
SQL Homework – September 2022 – Query window challenge
I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will ... Continue reading
2022-09-14 (first published: 2022-09-01)
323 reads
Why is security important in a dev environment?
I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve ... Continue reading
2022-09-05 (first published: 2022-08-23)
231 reads
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in ... Continue reading
2022-08-31 (first published: 2022-08-18)
435 reads
When good enough is good enough
Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not ... Continue reading
2022-08-30
23 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
You Have Homework
Comments posted to this topic are about the item You Have Homework
SSIS 2019 or 2022 - Microsoft Connector for Oracle
Hello all, I am having one heck of a time installing Microsoft Connector for...
bringing a .bak across the wire without rdp'ing or mapping into the sql server
hi, a peer of mine would like to be self sufficient in bringing small...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers