Tag: PHP

Does SQL Server work with PHP

Coming from a SQL Server, and PHP background, I often get asked, does SQL Server work with PHP? The answer is YES. I have been using SQL Server and PHP together in a high availability load balanced environment with multiple data

Posted in SQL Server Tagged with: , ,

SQL Server Performance for Developers

For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to

Posted in DevTeach Tagged with: , , , , ,

Speaking at Vancouver DevTeach this week.

This week I will be attending and speaking at Vancouver DevTeach. This event taking place on December 2nd to 4th 2013 at the Vancouver Sheraton Wall Center Hotel. Monday and Tuesday I have morning presentations which leaves the rest of

Posted in DevTeach, Performance Tagged with: , , , , , , ,

Working on my sessions for DevTeach in Vancouver in December.

The two sessions I will be presenting at DevTeach in Vancouver BC will be the following: Using FILESTREAM and FILETABLES in SQL Server – Configuring and Using FILESTREAM and FILETABLES in SQL Server Developers love to use SQL Server to

Posted in DevTeach Tagged with: , , , , , ,

Sessions Accepted for DevTeach Vancouver BC

Today I learned that two of the sessions that I proposed for Vancouver DevTeach were accepted. This event taking place on December 2nd to 4th 2013 at the Vancouver Sheraton Wall Center Hotel. It will have 3 full days of main

Posted in Classes, TSQL Tagged with: , , , , , , ,

T-SQL Technical Debt

Technical Debt is a programming concept that is also known as code debt. The concept of Technical Debt applies closely with Agile software development, but also applies to database development. There are many tools available to report on technical debt

Posted in Database Health, Technical Debt Tagged with: , , , , , ,

TSQL 2012 – OFFSET and FETCH

Its about time, MySQL has had a feature LIMIT which is similar to the  usage of OFFSET and FETCH for years.  Now in SQL Server 2012 Microsoft introduces OFFSET and FETCH. The OFFSET and FETCH functionality is used to achieve

Posted in CTE, SQL 2012, TSQL 2012 Tagged with: , , , , , , ,

SQL Server ODBC Driver for Linux

The Microsoft SQL Server ODBC Driver for Linux provides native connectivity from Linux to Microsoft SQL Server. Just released 11/21/2011 – Linux ODBC driver for SQL server. http://www.microsoft.com/download/en/details.aspx?id=28160   Hopes: I hope this is better than the original SQL Server

Posted in Other Tagged with: , ,