Caching
A SQL Server database can easily be seen as a bottleneck as all data must be retrieved from a single machine. However a caching strategy in your application and alleviate load and improve performance.
2014-02-26
252 reads
Editorials
Lawsuits and Data Breaches
Steve Jones notes that a data breach resulted in a lawsuit. How long before that's a common practice, and should we be preparing as data professionals.
2014-02-25
143 reads
Auditing Matters
We might not be able to stop hacks, attacks, or issues with our databases, but knowing that they've occurred is important. Steve Jones notes that we might need auditing more than security.
2014-02-24
169 reads
2014-02-24
105 reads
The SQLCLR Impact
Has the SQLCLR system impacted your SQL Server environment? Steve Jones wants to know if it has or has not today.
2014-02-21
220 reads
2014-02-19
824 reads
The Security of Interconnected Systems
We are interconnecting more and more computer systems and applications all the time. Security becomes a problem when one of these systems hasn't been properly configured, secured, or coded. Steve Jones notes this is becoming a real problem.
2014-02-18
142 reads
2014-02-17
186 reads
Why Should You Network?
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
2014-02-17 (first published: 2009-08-17)
252 reads
What is Continuous Integration for Databases?
What is continuous integration for databases? Steve Jones gives a short explanation and information on why you might care about this.
2014-02-13
442 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