Category Archives: SQLServerPedia Syndication
-
What’s next 4th time
6September 8, 2022 by Kenneth Fisher
It’s now been about two and a half months since I was given notice and decided to blog about my …
Continue reading -
Creating a SERVER ROLE created a LOGIN as well.
1September 6, 2022 by Kenneth Fisher
One of my co-workers came to me the other day and told me that they found their network id as …
Continue reading -
SQL Homework – September 2022 – Query window challenge
Leave a commentSeptember 1, 2022 by Kenneth Fisher
I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will …
Continue reading -
When good enough is good enough
3August 30, 2022 by Kenneth Fisher
Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not …
Continue reading -
Explicit and implicit datatype conversions
2August 25, 2022 by Kenneth Fisher
Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because …
Continue reading -
Why is security important in a dev environment?
10August 23, 2022 by Kenneth Fisher
I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve …
Continue reading -
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
Leave a commentAugust 18, 2022 by Kenneth Fisher
I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in …
Continue reading -
SQL Server Query Tuning and Optimization by Benjamin Nevarez
Leave a commentAugust 16, 2022 by Kenneth Fisher
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin Nevarez (blog|twitter), and as soon as …
Continue reading -
Using DBCC CLONEDATABASE to create a schema only copy of your database.
Leave a commentAugust 11, 2022 by Kenneth Fisher
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s really cool when I need it. …
Continue reading -
Visiting with DBAs at midnight : T-SQL Tuesday #153
Leave a commentAugust 9, 2022 by Kenneth Fisher
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our host for this month’s episode of …
Continue reading
SQL Studies 