I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

This assignment practices SQL DDL. Write the SQL DDL to create the following 5 tables describing cooking: Recipe, Ingredient, Author, Cook, Requires. Make sure that every table has a primary key. An ...

creating tables and inserting data SQL-samurai-project / creating tables and inserting data Cannot retrieve latest commit at this time.

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Billed as “Microsoft’s cloud first data platform,” SQL Server 2014 will be released to manufacturing this week, with general availability scheduled for April 1, 2014. SQL Server 2014’s biggest new ...

Are you ready to unlock the power of Microsoft SQL Server 2014? In this blog entry I will examine my 3 favorite new features that show how SQL Server 2014 provides high-performance OLTP, optimization ...