Should I Be Worried About skip-2.0?
A new piece of malware which hooks into SQL Server, skip-2.0, has been making the tech media rounds. If you’ve not read about it yet or you’re looking for...
2019-10-25
68 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
SQL Server Security: Fixed Database Roles
Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.
2019-09-18 (first published: 2003-12-12)
64,101 reads
July 2019 – New Microsoft security update for Spectre variant
If you remember the flurry of news from the beginning of 2018 about side channel attacks called Spectre and Meltdown, Microsoft has included in its July update a patch...
2019-08-20 (first published: 2019-08-07)
357 reads
New Security Update for SQL Server in July 2019 Patches
It doesn’t look like this would affect SQL Server 2008 or SQL Server 2008 R2 since the earliest reported platform is SQL Server 2014, but in Microsoft’s release of...
2019-07-17 (first published: 2019-07-09)
1,731 reads
Basic SQL Server Configuration Help for Involuntary DBAs
After my presentation at the Techno Security and Digital Forensics conference, I had a information security professional stop by to ask a few questions. He’s in the position where...
2019-06-24 (first published: 2019-06-10)
1,188 reads
Guidance on Moving Off of SQL Server 2008 and 2008 R2
July 9, 2019 will be here soon. With it comes the end of support, including security updates for SQL Server 2008 and SQL Server 2008 R2 unless you either...
2019-06-21
49 reads
Why Security Through Obscurity Is Bad (Alone)
Security through (by) obscurity is where we try to protect an asset by hiding it. Anyone who has ever played the game Capture the Flag knows that a motivated...
2019-06-21 (first published: 2019-06-05)
392 reads
Amazon’s Concept of Ownership and Technical Debt
I’m reading Think Like Amazon: 50 1/2 Ideas to Become a Digital Leader. In talking about Amazon’s pursuit of a second headquarters, John Rossman wrote the following regarding ownership: Amazon’s second leadership...
2019-06-12
371 reads
#tsql2sday – A Letter to My 20 Year-Old Self
Self, I am writing this to you in my mid 40s. I know when I was 20, I wasn’t thinking about 30, much less 40. Here’s some advice I’d...
2019-06-11
31 reads
Building Your Brand Right
I was interviewed yesterday by Stephen Wynkoop (twitter) for the upcoming SSWUG Virtual Conference on May 23rd. One of the questions was about how to keep management engaged on...
2019-06-07 (first published: 2019-05-21)
472 reads
Blogs
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple...
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Forums
Edition features
SELECT * FROM sys.dm_db_persisted_sku_features If the result set has no records is it conclusive...
The Subtle Differences Between COALESCE and ISNULL
Comments posted to this topic are about the item The Subtle Differences Between COALESCE...
SQL Server Collations
Comments posted to this topic are about the item SQL Server Collations
Question of the Day
SQL Server Collations
At what levels can we set the collation in SQL Server 2022?
See possible answers