Archive for the ‘SQL’ Category

Posted by admin on May - 14 - 2014 0 Comment

With the release of SQL Server 2014 right around the corner, it’s difficult not to look back and marvel at the platform’s evolution. I began working with SQL Server back during SQL Server 6.0. I was developing database systems on the IBM S/38 but moved to SQL Server when the Fortune 500 company that I  [ Read More ]

Categories: IT News, SQL, Windows
Posted by admin on April - 14 - 2014 0 Comment

SQL Server 2014 comes with a set of enhancements as compared to its processors that brings a lot of business benefits to the applications in OLTP and OLAP environments. This article highlights a few key enhancements that are built into the product. Performance Enhancements These are performance enhancements that can help your workload run faster.  [ Read More ]

Categories: IT News, SQL
Posted by admin on October - 11 - 2012 0 Comment

Last week, a hacker group claimed that it breached computer systems at 100 major universities. Team GhostShell gained access to servers at Stanford, Harvard, and the University of Michigan, among others. The technique used, SQL injection, is not new or complex, but reportedly it’s becoming increasingly common. Here’s a quick guide to defending your servers. Basic  [ Read More ]

Categories: IT News, SQL
Posted by admin on March - 12 - 2012 0 Comment

Microsoft has released to manufacturing (RTM’d) its SQL Server 2012 product, as of March 6, the day before the company’s virtual “launch” of its new database. So when can you get the bits? If you’re an MSDN/TechNet subscriber, you can download them as of March 7, the Softies said. If you’re a volume-license customer, you  [ Read More ]

Categories: IT News, Microsoft, Software, SQL
Posted by admin on February - 9 - 2011 0 Comment

Overview This article provides a simple Web page to play multimedia files on a home computer using a BlackBerry phone. It does this by using SQL Server to store selected binary images (documents, music, videos, etc.) bulk copied to it. Such images may be opened on a smart phone, copied to other SQL Servers, or  [ Read More ]

Categories: IT News, Programming, SQL
Posted by admin on October - 21 - 2010 0 Comment

Recently at SQLBits York I demonstrated the new SQL Sentry Plan Explorer (formerly the “Plan Viewer”) and officially announced its upcoming release.  We are now pleased to make the beta version of the tool available for download! Background We had originally envisioned query analysis features only as part of the fully licensed version of SQL  [ Read More ]

Categories: IT News, Programming, SQL
Posted by admin on June - 21 - 2010 0 Comment

Creating Accounts After installing the Active Directory Directory Services role, there are several new tools available from the Administrative Tools section of the Start menu. Throughout the remainder of the article we will be working through the “Active Directory Users and Computers” tool. Domain Administrator Account The first account we are going to create on  [ Read More ]

Categories: IT News, Microsoft, SQL
Posted by admin on May - 25 - 2010 6 Comments

Alan Le Marquand SQL Server and SharePoint have always worked together well. When SharePoint Server 2010 and SQL Server 2008 R2 were released, there were some significant improvements to the integration between SharePoint and SQL Server 2008 R2 Reporting Services (SSRS). Here’s a look at how to configure and use the latest enhancements. Server Integration  [ Read More ]

Categories: IT News, SQL
Posted by admin on May - 21 - 2010 1 Comment

I was reviewing the Microsoft training courses for SQL2008 for a set of application developers who wanted to learn more about SQL Server. In doing so I came across some commands that I either had not heard of or had not used before. INTERSECT EXCEPT ALL ANY ALL and ANY have been around for donkeys  [ Read More ]

Categories: IT News, Programming, SQL
Posted by admin on May - 10 - 2010 20 Comments

The road to SQL started with Dr. E.F. Codd’s paper, “A Relational Model of Data for Large Shared Data Banks“, published in Communications of the ACM in June 1970.   His colleagues at IBM, Donald Chamberlin and Raymond Boyce were working on a query language (originally named SQUARE, Specifying Queries As Relational Expressions) that culminated in  [ Read More ]

Categories: IT News, SQL
  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Youtube

Search Site

Popular Posts

Review: The Apple iP

In these times we have little opportunity for mystical religious ...

Everything you need

The iPhone OS 4.0 event just wrapped up and the ...

The end of SQL and r

The road to SQL started with Dr. E.F. Codd's paper, ...

Microsoft Arc Keyboa

I am losing the war on clutter. Apparently my desk ...

John Shepherd-Barron

John Shepherd-Barron, the Scotsman credited with inventing the world's ...

Sponsors