More CPU Means More Data
Faster CPUs allow us to perform more complex modeling and analysis of variables, and hopefully come up with better decisions. However that more complex analysis means more data.
2012-09-13
173 reads
Editorials
Creativity
What if you could stop all work for a month and have people find ways to improve the business? Would you take the chance?
2012-09-12
157 reads
Mining and Algorithms
The algorithms that you use to query or mine data are very important. Amazon knows their recommendations algorithms are important. Do you know what's important in your job?
2012-09-11
275 reads
A Cloudy Future
The future of employment in the technology industry means learning to do more with less.
2012-09-10
139 reads
Document First, Code Later
Phil Factor on the many advantages of building the code from the documentation. For one, it forces us to learn the language and concepts of the business processes before designing the schema.
2012-09-10
294 reads
The Dream Machine
This Friday Steve Jones has a fun poll. If your new boss told you to spec out a machine, what would you choose?
2012-09-07
142 reads
Privacy
Privacy is a big deal in the digital world, but it's also something companies don't handle well. Steve Jones notes that however things change in the future, the data professional will need to pay more attention to issues in this area.
2012-09-06
98 reads
Rogue Algorithms
As computers get more complex and automated, the chance for rogue algorithms grows. Steve Jones reminds us that we should be careful in how we code and that a little forethought from managers can help.
2012-09-05
203 reads
Ridiculous
Bad behavior at conferences hasn't been a problem at SQL Server events, but it has been elsewhere. Steve Jones thinks this is unacceptable.
2012-09-04
336 reads
2012-09-03
63 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
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...
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