The Work of the Ancients
We tend to keep data around for a long time. Today Steve Jones is looking to see how long you've kept your databases around.
2019-10-11 (first published: 2015-10-02)
309 reads
Editorial
Have a Think
It's easy for most of us to get caught up in work and not stop to think about the larger picture, or the longer term. Steve Jones thinks you should make time for both of these.
2019-10-24 (first published: 2015-10-01)
267 reads
2015-09-30
489 reads
Are you a Data Scientist?
A data scientist needs some specialized skills. Today Steve Jones talks a bit about the requirements to be good at this job.
2019-05-01 (first published: 2015-09-29)
580 reads
No Time for Testing
Testing software is important, but we always seem to find reasons not to. Steve Jones has a few thoughts about testing.
2023-01-02 (first published: 2015-09-28)
246 reads
2015-09-28
118 reads
Logging Tables
Today Steve Jones looks at the need to log data from an application or process. Are there good and bad ways to design the structures to log information?
2019-11-05 (first published: 2015-09-25)
610 reads
Data Masking for Convenience
Steve Jones talks a bit about the new data masking feature in SQL Server 2016 and how useful it can be.
2015-09-24
134 reads
Everyone is a Target
Today Steve Jones looks at the targeted attacks by hackers against individual security professionals.
2015-09-23
121 reads
Data Sprawl
The challenges of data growth and sprawl can be compounded by the variety of tools and platforms available. Steve Jones notes that you might need to learn a bit about different technologies.
2015-09-22
129 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...
Automatically generate tabular model partitions
Hi. I hope someone can give some useful suggestions. My workplace have a suite...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
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;