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
164 reads
Editorials
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
126 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
158 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
180 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
114 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
115 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
127 reads
A Refreshing Break
Steve Jones talks about his recent vacation break and one change that made it a huge success.
2011-11-30
120 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
220 reads
Little Love Lost for SMO
SMO is a very useful way of automating a wide range of routine database jobs, but Phil Factor laments Microsoft's apparent ambivalence towards the technology, including a lack of anything remotely resembling adequate documentation.
2011-11-28
207 reads
Blogs
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers