Should Production Databases Be in a VCS?
Steve Jones talks version control, but from the production perspective.
2016-02-16
102 reads
Editorial
An Age of AI?
The age of artificial intelligence seems to be here, but it's a little different to what we were promised.
2019-07-22 (first published: 2016-02-15)
431 reads
Zero Downtime for 2016
Someone made a call to architect zero downtime for databases. Steve Jones isn't sure this is the best thing you could do.
2016-02-15
155 reads
The Push to Upgrade from SQL Server 2005
There's a push to upgrade those SQL Server 2005 instances with support ending this April.
2016-02-12
117 reads
Reasonable Timeframes
Steve Jones talks about the timeframes for updating and fixing security problems in applications.
2016-02-11
84 reads
The Digital Woes of Public Records
Public records have been open in the past, but today's digital access might mean problems.
2016-02-09
100 reads
Culture and Performance
Culture is important at our workplace. Steve Jones notes this can be important when trying to get the most performance from your employees.
2016-02-08
142 reads
SQL, and Ye Shall Find
Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.
2016-02-08
106 reads
Who's Got a Preteen SQL Server?
This week Steve Jones wonders about the age of your instances and whether you are planning on upgrades or aware of how many out of support instances you might have.
2016-02-05
177 reads
The New Operating System
We have an operating system for how our organizations are run. Steve Jones talks about a new one that might be important for the world rules by software.
2016-02-04
137 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;