SQL Server 2016: Soaring to new heights

With enhanced performance features, full cloud integration, and industry-leading security features, SQL Server 2016 is providing organizations with … [Read more...]

Microsoft Transact SQL (T-SQL) Demystified

The example SQL script includes Line Numbers for ease of reference and reflects the default SQL Server Management Studio (SSMS) color coding scheme as … [Read more...]

3 Ways to Make More Money & Advance Your Career in IT

Let’s say you've been in IT for a while. You dig working with technology and you don't despise the users who call in with their crazy questions. But … [Read more...]

In-Memory OLTP in SQL Server 2014

The development name for this new technology is Hekaton. It’s Greek and means 100 (hundred) which was the aim of performance improvement with this … [Read more...]

I want to go into IT – Where do I start?

Ah yes, an age-old question asked by young go-getters right out of junior college, massively in-debt graduates from universities, and folks who have … [Read more...]

Backing Up Multiple Databases in an Instance of SQL Server

Sometimes things that seem complicated are much easier than you think and this is the power of using T-SQL to take care of repetitive tasks. One of … [Read more...]

SQL Server TempDB Usage, Performance, and Tuning Tips

What is TempDB responsible for in Microsoft SQL Server? Global (##temp) or local (#temp) temporary tables, temporary table indexes, temporary … [Read more...]