Encryption Works
Encryption is supposed to protect data, and it appears to be working as police and authorities are often stymied by encrypted disks. Steve Jones recommends you encrypt your disks on all your machines.
2011-12-12
337 reads
Editorials
The Employment Contract
This Friday Steve Jones wants to know if you'd like to have an employment contract of some sort. Do you want your duties, or maybe exlcusions, explicitly spelled out in an agreement?
2011-12-09
155 reads
Not So Unbreakable
Oracle touted its database software as unbreakable, but many security researchers think the company is not spending enough effort on security. Steve Jones has a few comments.
2011-12-08
114 reads
Sharing Your Database Server
Is is time to consider sharing your database server with other applications? Steve Jones thinks with today's powerful servers and changes to licensing, this might make sense.
2011-12-07
148 reads
Layers of Security
A good security scheme will contain many layers. Today Steve Jones talks about one of those: good habits.
2011-12-06
166 reads
Not having TDE in all editions is stupid
Transparent Data Encryption is only available in Enterprise Edition and above. Steve Jones thinks that's a mistake.
2011-12-05
112 reads
A Welcome Intruder
This Friday Steve Jones asked about penetration testing of your security. Have any of you ever tested your systems?
2011-12-02
101 reads
Fast Migrations
Virtualization is an important technology for anyone working with servers, and as vendors look to improve the performance of their hypervisors, this technology might be more important for data professionals to understand.
2011-12-01
124 reads
A Refreshing Break
Steve Jones talks about his recent vacation break and one change that made it a huge success.
2011-11-30
113 reads
Thinking Time
Do you get time to stop and think, without being pressured to solve a specific problem? Steve Jones notes that it's important to get that creative time to grow and produce better work.
2011-11-29
210 reads
Blogs
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Forums
A Strange Query
Comments posted to this topic are about the item A Strange Query
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Import data from json file with special characters
I am using the following script to import data from a json file. This...
Question of the Day
A Strange Query
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers