7 Reasons Why Migrating Off SQL 2005 is a Good Idea

While end of support for SQL Server 2005 SP4 came on April 12th 2011, end of extended support for SQL Server 2005 happens on 12 April 2016. That means no help and no more hotfixes from Microsoft in regards to any data still living in SQL 2005 databases. Further details in regards to this can…

0

The “SQL Guy” Post # 30: How to Recover from a Lost SA Password in SQL Server 2012

Working at Microsoft provides many opportunities to receive pearls of wisdom from individuals at other parts of the organization.  Saleem Hakani sent along this little gem a few days ago and I wanted to share it with you.  It outlines how to recover an SA password if you forgot it – though you do need…

2

The “SQL Guy” Post # 29: Using SEQUENCE in SQL Server 2012

Before joining Microsoft I spent many years working as an Oracle DBA, SQL Server DBA, consultant, trainer, and so on.  I got to see the differences in features and functionality between a wide variety of products.  I also saw that there was a different approach that Oracle and SQL Server used for incremental numbers in…

0

The “SQL Guy” Post # 28: Introducing the New IIF() Function in SQL Server 2012

In SQL Server 2012 we have added the IIF() function to the SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE condition within a single function. This helps in simplified code and easy to read conditions.   In earlier versions…

1

The “SQL Guy” Post # 27: Increasing Developer Productivity with Snippets

This week we have something for you to share with the SQL Server developers, as well as use in your DBA T-SQL scripts to make life easier when you re-use common code.  Saleem Hakani provides some guidance on new functionality in SQL Server 2012 to help make you more productive when creating T-SQL code. SQL…

0

The “SQL Guy” Post #26: New OFFSET and FETCH Query Options in SQL Server 2012

SQL Server 2012 introduces brand new query hints that allow you to implement query paging solution. In the past, we have used TOP operator to return the top number of rows from a table. However, OFFSET & FETCH options of the ORDER BY clause can give you more benefits than just the TOP operator.  …

0

The “SQL Guy” Post #25: String Concatenation Using CONCAT() in SQL Server 2012

SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to 255 string or variable values in to one single string. It requires a minimum of two input values when calling the function and takes care of implicitly converting the data values to a string by…

0

The “SQL Guy” Post # 24: Backing Up Large Mission-Critical Databases

In an ideal world, hard drives and other hardware never fail, software is never defective, users do not make mistakes, and hackers are never successful. However, we live in a less than perfect world and we should plan and prepare to handle adverse events.   In today’s topic, we will focus on best practices for…

0

The “SQL Guy” Post # 23: TRIGGER-less Tracking of Database Changes

There are times when you need to track all the changes happening to a table. In the past, developers have used custom code to track changes by calling stored procedures, triggers and until recently even change data capture (also known as CDC). SQL Server now supports a simplified method of auditing changes using DML statements…

0

The “SQL Guy” Post # 22: Understanding Transparent Data Encryption

You may have heard about Transparent Data Encryption (TDE), which was introduced in SQL Server 2008. But what does it do, what are its advantages and disadvantages and how can you leverage this technology in SQL Server? Keep reading this tips and tricks article to learn how.   Transparent Data Encryption (also called as TDE)…

0