Who should have Sysadmin rights?
The point of this article is that only service accounts and/or specific network sql admin accounts should have sysadmin rights.
2019-03-11
1,595 reads
Editorials
Databasee Brainstorming
We sometimes need to think differently about different situations. Steve notes that we might approach the way we solve problems in new ways.
2019-03-08
189 reads
2019-03-07
104 reads
The Data Incident
Google and Microsoft have plans for dealing with data incidents. Steve thinks you should as well.
2019-03-06
79 reads
The Creepiness of AI
It seems that many companies are implementing AI into their systems. Steve notes that this isn't always a good idea.
2019-03-05
90 reads
2019-03-04
114 reads
2019-03-04
107 reads
Schema Security
This week Steve is wondering about the use of schemas for security or other purposes.
2019-03-01
514 reads
The RDBMS is Often the Right Tool
Today Steve gives reasons why he thinks the RDBMS is often better than a NoSQL database of any sort.
2019-02-27
105 reads
Should the Data Lake be Immutable?
Data warehouses and lakes are often loaded from other data, so should they be immutable?
2019-02-26
813 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers