Page focused on the latest technologies
Posts tagged rest
What Do We Need in SQL Server?
0
What should be included in the next release of SQL Server? SQL Server 11 is being worked on now, and there are a number of features that I’m sure will be new, as well as some improvements to old features.
But what should be changed/added/improved upon? Brad McGehee asked that question in his September Blog question. There are some really interesting ideas in the comments, and I hope that some of these get submitted to Connect for inclusion in SQL 11, or even SQL 12. The product will always need work, and we should all be looking forward to future versions.
Read the rest of “What Do We Nee in SQL Server?” at SQLServerCentral.
See the article here: What Do We Need in SQL Server?
Community Direction
0hought it was a great idea. It was a way for real users to submit bugs, and others to see those bugs, voting on them if they thought they were important. It would help Microsoft determine what features and bugs are important and perhaps allocate resources accordingly. However there was a fundamental problem with the system. People would see individual items, and could vote for them, but wouldn’t have an idea of what other items might be listed.
The work on SQL 11 is underway, and recently I got a note from Itzik Ben-Gan asking people to vote for windowing enhancements to the T-SQL language. I’m not sure exactly of all the places that these are useful, but Itzik is one of the smartest people I know and I tend to believe that if he finds these enhancements useful, they are likely going to make T-SQL easier to work with.
Read the rest of “Community Direction” at SQLServerCentral.
Read more here: Community Direction
Hot Skills
0What are the hot skills to work on in 2011? I found this article that gives you a list of some of the things that companies will be looking for according to a survey in Computerworld. It’s a fairly standard list of generic skills that companies are looking for, but it ended with something that I think that people often overlook: business acumen and communication skills.
How many of us have to work with someone regularly that is not a technologist? How many times do you have to explain something to a business person in a way that is devoid of technical jargon? I would bet that most of us have to do that. However it seems that too many technology professionals still want business people to better understand what we provide with our computer hardware and software. Instead of us learning more about the business, we want the business to tell us what we should do.
Read the rest of “Hot Skills” at SQLServerCentral.
See the rest here: Hot Skills
Big Data and SQL
0I ran across this article on 8 Big Data Deployments in Detail, which was funny since the detail consisted of an old system, a new one, a capacity, a date, and a paragraph. If that’s detail, then I wonder what a synopsis would be. Only one of the 8 was using SQL Server, and that had even transitioned to a ParAccel system. Most of the other systems used Oracle previously and they ranged from 7TB (not big, IMHO) to 2.5PB (which is big).
Despite that lack of any real information on what these companies were doing, I did see some interesting things listed. There were a few notes that mentioned compression in a few places, often column store based compression that dramatically speeded up processing for the systems.
Read the rest of “Big Data and SQL” at SQLServerCentral
Read the original here: Big Data and SQL
NoSQL Is Not Everywhere
0How many places really use NoSQL? Facebook, one of the largest sites on the Internet, has had their Cassandra database service receive a lot of press over the last year. In pointing to them as an example, many technologists use the argument that if Facebook uses Cassandra to run their extremely data intensive business, then it ought to be good enough for the rest of us.
Cassandra might be great for your business, but is it the best choice? How does that argument apply when Microsoft.com, also one of the largest web sites in the world, serves millions of users a day with SQL Server as the back end? Twitter also uses an RDBMS to store it’s tweets. It uses the MySQL database, an RDBMS, though they are investigating and integrating Cassandra in places.
Read the rest of “NoSQL Is Not Everywhere” at SQLServerCentral.
Visit link: NoSQL Is Not Everywhere
