Attending TechEd Europe 2014!

This week I am at Microsoft TechEd Europe which is being held from October 28-31 at Fira Barcelona in Barcelona, Spain. In case you didn't know as yet, this is the last time Microsoft is holding the TechEd event and it will be replaced by another event called Microsoft Ignite which is being held May 4–8, 2015 in Chicago, Illinois.

If you are attending the event and wish to meet or have SQL Server questions for me then visit the Data Platform section in the Cloud + Enterprise Booth of Microsoft Solutions Experience (MSE) area after 1 pm on Thursday 30th. You can also meet me at the Ask the Experts session in the TechExpo from 6:30 pm to 8:00 pm also on Thursday.

Read more »

SQL Server 2014 RTM

Yesterday Microsoft officially released SQL Server 2014. 

Tweeted by @SQLServer

Some of features that had me excited about this release are:
In-Memory Capabilities
Microsoft released a new feature called,  In-Memory OLTP and enhanced the existing feature known as Columnstore Indexes.

In-Memory OLTP
This is a memory-optimized database engine integrated into the SQL Server engine. It allows you to create tables in memory which can be used to provide performance improvements as well as deal with possible concurrency problems. Finally something cool for the DBAs!

Columnstore Index
ColumnStore indexes uses xVelocity In-Memory (formerly known as VertiPaq) technology to provide improvements in query execution time which is beneficial for common data warehouse data sets. This was a feature that was also introduced in SQL Server 2012. However you could only create nonclustered columnstore indexes and once created the tables cannot be updated. In SQL Server 2014, you can now create updatable clustered columnstore indexes and they also provided three new system views:

    • sys.column_store_segments
    • sys.column_store_dictionaries
    • sys.column_store_row_groups

AlwaysOn Availability Groups
This is a high availability and disaster recovery option that was introduced in SQL Server 2012 and gave the you all the benefits of Database Mirroring as well as other benefits such as Active Secondaries. SQL Server 2014 allow you to have a maximum of 8 secondary replicas (increased from 4). This is great for reporting and of course sharing the querying load. Also Readable secondary replicas stay online if  the primary isn't available. This was what was expected in 2012 but is should be available in 2014.

Hybrid Cloud Solutions
As I mentioned AlwaysOn AG I thought I should start off the cloud solutions features by highlighting the fact that you can now use Azure VMs as replicas through the Add Azure Replica wizard. Another feature is the ability to store data files as Windows Azure blobs. The last hybrid cloud feature that I wanted to highlight is SQL Server Managed Backup to Windows Azure. This allows users to manage and automate database and log backups to the Windows Azure blob storage both at the database and instance level.

Cardinality Estimation Improvements
Using knowledge of modern OLTP and data warehousing workloads, the cardinality estimator was redesigned to improve the query plans.

Other features include:
  • SSD buffer pool extension
  • Resource Governor for IO
  • Backup To URL
  • Encryption of Backups
  • Hosting a SQL Server Database in a Windows Azure Virtual Machine
  • Delayed Durability
  • Partition Switching and Indexing
  • Managing the Lock Priority of Online Operations
  • Incremental Statistics
  • Sysprep enhancements

SQL Server 2014 has new and improved features for everyone (DBAs, Developers and BI enthusiasts) and is definitely a product that you should be excited to get your hands on. You can download the evaluation from here or if you have an MSDN subscription then you can download it from here.

Read more »

Significance of Square Brackets [] in T-SQL Code

After one of my T-SQL presentations, I was asked about the significance of square brackets around objects in T-SQL. I had an idea of their purpose but to confirm I asked T-SQL guru, Itzik Ben-Gan.

Basically he highlighted the fact that a database object name is known as its identifier (e.g., a name of a column, table, etc.) and it can be either regular or irregular.
When the identifier is regular, delimiting it is optional but when the identifier is irregular (e.g., starts with a digit, has a space within it, is a reserved keyword, etc.), it has to be delimited.
T-SQL supports two kinds of delimiters:
  1. Square brackets, e.g., [Order Details], which is proprietary.
  2. Double quotes, e.g., "Order Details", which is standard.

Both delimiters for irregular identifiers results in no errors

No delimiters for irregular identifiers results in errors

If you want to know what makes an identifier regular then check here under “Rules for Regular Identifiers”.

Read more »

PASS Azure VC Meeting - Increase data safety and uptime with SQL Server 2014 and Windows Azure

Topic: Increase data safety and uptime with SQL Server 2014 and Windows Azure

Speaker:  Hans Olav Norheim - Software Developer, Windows Azure SQL Database & SQL Server

Date: Thursday March 20th 2014 12:00-13:00  Central Time
           ADD TO CALENDER

Would you like to ensure availability and backup of your data, but don't want to invest in more hardware? SQL Server 2014 comes with support for backup and disaster recovery in Azure. Join and learn about how you can secure your data as well as keep applications available and reduce the risk of losing data if something should go wrong.

About Speaker:
Hans is from Norway and has worked with SQL Server since the early 2000s as a customer, a few years back before he joined the SQL Server Engine team as a developer in the engine programmability team (T-SQL/SQL). Today he focuses mostly on the distributed infrastructure running Windows Azure SQL Database.

Visit our homepage and follow us on Twitter!

Read more »

Solving the Management Studio Error: Saving Changes is not permitted

Saving a table after making modifications (e.g. changing the data type) might result in the following error:

To avoid this error follow these steps:
  1. Select "Options" from the "Tools" menu.

  1. Select "Designers" and uncheck the "prevent saving changes that require table re-creation" option.

  1. Click "OK".

Read more »

PASS Summit 2013 Review

This is my fourth PASS Summit but my first time attending it outside of Seattle. I like Seattle but I have to admit it was nice to visit some place new and the fact that it was warmer was definitely a plus. Also since Charlotte is the hometown of SQL Sentry they gave us a treat with maps, evening shuttles and sponsorship for various events. 

Welcome Reception

This year I decided to attend more sessions because I wanted information about particular topics and I also wanted to see certain people present in-person. There is always a wide selection of interesting topics and knowledgeable and outstanding speakers at the Summit so choosing sessions is always a task. I believe that a main benefit of attending the event is networking and visiting vendors. I attended some of the evening events such as the welcome reception and exhibitor reception and met many attendees and vendors. The Community Appreciation Party which takes place on the Thursday night is also a great place to meet old friends and make new ones. This year the party took place at the NASCAR Hall of Fame which had many historical cars as well as activities such as High Octane Theatre, the Simulated Track and the Pit Challenge. 

NASCAR Hall of Fame

The venue, Charlotte Convention & Trade Center, was a suitable size for the event even though some might say the rooms were small for some sessions. The Summit had a large number of attendees that will continue to increase and because of the quality of speakers and sessions it seems inevitable that all sessions will have to be held in large rooms. I was shocked at my first planned session when I entered the room and saw people sitting on the floor and I was blown away the next day when I saw a queue to enter a session. My own planned session at that same time was also full. Just to be clear I’m not complaining but highlighting how much the Summit has grown.

Leaving PASS Summit 2013

I must admit that this year time management was a task especially since I wasn't familiar with the venue but I still learned and networked which are my main goals at this event. I had a great time seeing my old friends and making some new ones. In the last four years, I have never regretted taking the time or spending the money to attend the PASS Summit. If you work mainly with SQL Server and have never been to PASS Summit then I recommend attending Summit 2014 in Seattle, especially with the upcoming release of SQL Server 2014

Read more »

Red Gate's SQL in the City US Tour 2013 Review

I attended one of these events last year in Seattle and it exceeded my expectations. SQL in the City is a free event that takes place in various cities and provides great learning and networking opportunities for the SQL Server community. This year they visited three cities; Pasadena, Atlanta and Charlotte with touring speakers Steve Jones, Grant Fritchey and members of Red Gate product team. I attended two out of three events and also spoke at the Charlotte event.

This event had speakers Tim Radney doing a session titled 'Life as a DBA' and Stuart Ainsworth doing a session called 'Simplifying SQL Development'. I had a great time meeting Red Gate team members again as well as their new members  and also hanging out with attendees like Tim Radney's son. The sessions were very informative but I have to say that the most useful information I got was the advice that the presenters gave me for my session in Charlotte.

Red Gate team in Atlanta
Steve Jones Presenting

I have been looking forward to this event since August,  when I found out that I was accepted to be a speaker, because it would be my first time presenting in the US! I got to the event very early to review my slides but spent most of the morning in awe because of the venue; the Ritz-Carlton is awesome! Eventually when I settled down I saw Tony Davis, author of Red Gate's Transaction Log Management book, and asked him to review my slide deck. His feedback caused me to make some necessary last minute changes and after three cups of coffee I was ready to go.

There were 105 people at my Understanding and Controlling Transaction Logs session and I received some positive feedback from people after the session and also a good rating from Red Gate's review. To be honest presenting for the first time in the US, added some stress to me before the session but the advice from the guys in Atlanta and seeing familiar faces in the crowd during my session made it so much easier to present. It was a great experience and I want to thank Annabel Bradford, Carly Harding, Amy Roberts, Hannah Jermy and the rest of the Red Gate team for giving me this huge opportunity and also for all their assistance in preparing for it. Also want to thank people like Tony David, Steve Jones, Grant Fritchey for the advice and tips in the morning.

Presenting in Charlotte

Besides me and the rest of the touring team, this event had speakers like Louis Davidson, Kevin Boles, Kevin Hazzard and Mickey Stuewe. The sessions that I attended were fun and informative. The extra fun stuff started around 4 pm when the Charlotte BodyWorks masseurs came to relieve some people tension, followed by the networking event at 5 pm that included food, drinks and of course free swag. I want to congratulation the Red Gate team on another successful SQL in the City Tour. How do I know it was a success? Well besides me enjoying it and learning things I met someone later in the week who had attended  and to paraphrase her "For a free event I was impressed at the level of sessions, all of them were very useful and they were done by good presenters. Some paid events don't even give you that."

Performing a demo

You can download my slide deck as well as any of the other presentations from Red Gate SQL in the City site. I want to thank Paul Randal for permission to use some of his demos during my presentation.

UPDATE: While writing this post I received a Christmas card from the "Friends at Red Gate" team so I wanted to public acknowledge that and wish everyone at Red Gate a very happy holiday and a Happy New Year as well.

NEXT REVIEW: PASS Summit 2013 Review!

Read more »