SQL

New Software… New Possibilities? {2}

by Evin C
Having only been working on Microsft SQL Server R2 2008, we have very limited exposure to other types of software available to users. The article I have chosen is actually bringing new software to us in the form of Microsft SQL Server 2012. Global Knowledge, a worldwide leader in IT and business training, recently announced in February that they will be offering five training courses for Microsft SQL Server 2012. In the five-day long courses, “students will work with the beta version of pre-released SQL Sefver 2012 software and complete many SQL Azure-enabled lab exercises.” These students will be gaining the know-how to maintain a SQL Server 2012 database, including certain backup strategies, collaboration with SQL Server Agent and even some troubleshooting methods. The opportunity to go to these courses will give you the ability to master querying and basic design with this new database software. Considering it is still in the beta, there is a still a long way to go before full implementation. read more...

SQL Incorporation into Blackberry {2}

by Ermie C
Mobile devices have been part of our lives ever since the smart phones were created.  It’s found a way to help us organize our lives, find information, and keep people from forgetting people’s phones numbers.  Idera, who spoke to blackberry systems, has created something called, “SQL Mobile Manager 3.0” that can create and manage SQL servers and administration.  This a great way for business people to be able to manage their accounts on the go.    To be able to access Microsoft SQL Server it has opened up the limitless abilities of a business owner. read more...

SQL Server Virtual DBA App {7}

by Willen L
This article talks about a new application that was recently released that allows you to monitor their SQL Server in real time on a windows phone. This application is aimed towards IT managers and database administrators that want to keep a close eye on their databases without going through the hassle of accessing their SQL Server that involves complicated log in and VPN access and remote connecting in just to monitor stuff on their Servers. This application lets the user access the information just by providing the Virtual DBA password and then it does all the work and connects the user and displays real time statistics like errors, performance, and uptime details. This app is also available  for the ipad/iphone. read more...

A Greener Government {2}

by Monica G
Legislatures are finally going green, or at least in Massachusetts they are. The Massachusetts legislation just implemented a new system called Legislative Automated Workflow System (LAWS) for all of the work that passes through the districts and courts. This was all made possible by an IT solution company named Tallan, Inc. The system was designed from the ground up so it would comply with the Americans with Disabilities Act. It uses Microsoft technologies such as ASP.NET, SQL Server and SharePoint Server. The system allows ordinary people to view any bill throughout its entire lifecycle from filing to enactment. And legislators and their people will be able to “draft and file legislation, engage in bill sponsoring, managing committee activities and all other functions” from the State House to their own district. read more...

Managing SQL Server’s Management Features (…get it?) {1}

by Evin C
This week’s article has come from eWeek and details improved management capabilities that come from SQL Server 2008 R2. With Microsoft’s continued support into this software and an endless amount of possibilities for the program, I hope to see many more updates in the future. The new management capabilities the software has expanded upon included further improvement to the report system, the SQL Server Utility “which enables administrators to manage and monitor multiple database applications and server instances from a central interface called a Utility Control Point (UCP)”, and a new tool titled PowerPivot. This article details each new feature and goes into it’s application to Business Intelligence (BI). read more...

2012: The Rise of Microsoft SQL Server 2012 {1}

by Ermie C
This article is about how Microsoft is now creating a new version of Microsoft SQL Server.  This version has to deal with a lot of the same features, but with some new features attached to it.  The new product is set to be presented to the public on March 7th and there will be will two different versions of the product given.  First there is the Business Intelligence version and then there is also, the standard version.  However, this March 7th release would be kind of criticized as a publicity stunt to present an incomplete product.  There are some critics that say that Microsoft is only doing this because they want to get something out there.  To me, it feels like it’s going to be the Vista of SQL Servers.  We all know how that turned out.  Also, they said that with the new features it would be very hard to implement.  So the best way to implement the new features would be already incorporating it with the already used database in a person’s business.  To sum it up, critics say to use it with other database tools and pic and choose the features they would like to use. read more...

7 performance tips for faster SQL queries {4}

by Toan T
Writing SQL queries is a simple task that everyone can do but how to write efficient query that does not affect performance is another issue. As a matter of fact, many developers from every platforms are struggling and seemingly stuck in using simple DO WHILE loops and many of them often have their own methods for writing codes that they are too reluctant to think outside the box. For effective query writing, there are seven tips that the article recommended using. read more...

SQL Attacks {Comments Off on SQL Attacks}

by Abubaker D

So my article is talking about Malware that are installed on people’s computers through Web Paging. Lately, there have been a large number of internet sites that have been compromised by SQL injection attacks. What happens is simple; the attack modifies the databases used by the sites so that they redirect the user to other sites that could serve them Malware. The attack is known as “Lizamoon”. Cisco Scansafe reports that Lizamoon has been part of an ongoing series of attacks they have been following for 7 months. In that time they observed 42 malware domains used in the attack. They claim the attacks have a high failure rate. What happens in the attack is that it installs a rogue Anti-Virus named Windows Satiability Center. The program reports problems on the computer and asks for payment for the “full version” to fix them. read more...

Look Before You Leap {1}

by Han C
Being able to use available knowledge to help build an effective and efficient product for your customer is crucial in the business world. Coming up with the right solution the first time can make the difference in money and time. That is why this article stresses the importance of forward engineering. Although the article itself it still rather old. The information is relevant to what we have done in our second assignment and maybe even our third and final assignment. The article discusses the benefits of implementing forward engineering practices in business systems analysis, for example, “Logical modeling gets it right and physical modeling makes it optimal for the chosen database platform and technology.” Furthermore, the author does not believe in merely relying on reverse engineering to provide the necessary business in’s and out’s and recommends forward engineering whenever possible. read more...

Data Types {2}

by Jamal A
The article I read talks about the most important contemplations of selecting correct data types when designing a SQL Server database. It talks about how choosing a correct data type in the database design phase can have a significant impact on the efficiency and performance. According to the article, the SQL Server offers six sets of data types. First and formost commonly used data types that stores numeric information are called “The Exact Numeric Data Types” that includes: int, decimal, and money.  The next data type is called “The Approximate Numeric Data Types”, this data type are not as commonly used as the exact numeric data types. The approximate numeric data type includes: float, and real. Moving on, the next data type that is mentioned in this article is called “Date and Time Data Types”, this data types allow designers to easily work with time zones. After that, the next data type in the category is called “Character String Data Types”, it is used to store text values in Microsoft SQL Server databases, and this includes: char, nchar, varchar, nvachar, and text.  The next data type that is mentioned in this article is called “Binary Data Types”, it allows DBAs to store any type of binary data, this includes: bit, binary, varbinary, varbinary(max), and image. Finally, the last data type that is mentioned in this article is called “The Other Data Types”, it includes: cursor, sql_variant, table xml, and uniqueidentifier. read more...