The Endless Upgrade Cycle
Steve Jones notes that security can be a reason to upgrade your systems, but it can also result in an endless cycle.
2014-03-26
126 reads
Editorials
Inspiring Change
Day 2 at the PASS Summit provides some inspiration for Steve Jones at the Women in Technology luncheon.
2014-03-25 (first published: 2009-11-05)
152 reads
Divide and Conquer
Schemas may be largely irrelevant to small databases, where it is no trouble to assign permissions to individual objects, but they are vital for a hard working corporate database that is being actively developed and used by several applications, with thousands of objects that must be assigned the correct permission.
2014-03-24
220 reads
Is Unit Testing Important?
Testing our applications is important, but at what level do we need to test? Steve Jones talks about unit testing today, and wonders if this is prevalent for SQL Server developers.
2014-03-24 (first published: 2009-11-10)
535 reads
Privacy and Data
Much of the data collected by companies is being sold for profit. This data isn't treated well and while not much may change, perhaps we should be aware of how we handle data as professionals.
2014-03-20
110 reads
2014-03-19
476 reads
Getting Started with Azure
Many people have been unsure of cloud computing and what it means for your particular application. Steve Jones notes there's a great new demo that can help you get started exploring the Azure offerings.
2014-03-17
178 reads
How Many Passwords?
How many passwords do you have? Steve Jones has a lot and while he notes there are some new ways for us to authorize ourselves for servers, they aren't necessarily making things more secure or less complex.
2014-03-17
144 reads
Squeezing the DBA
What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.
2014-03-14 (first published: 2009-09-03)
344 reads
#sqlhelp
The #sqlhelp hashtag on Twitter is a great way to interact with the SQL Server community and get help.
2014-03-13
254 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