I have been doing a lot of posts of late about extended events but have failed to share some of the essential building blocks, such as the use of the file target. I am not looking to do a series of definitions, but just share a couple of quick tips and examples here and there that […]
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index defragmentation routines. Some people perform routine index maintenance, some people do not, and still others have done some sort of “set it and forget it” script provided by a vendor and may or may not […]
There is plenty of legislation and regulation in place these days that strongly suggest encrypting a database. In SQL Server, we have the ability to comply with these regulations in a couple of different ways. We can choose to encrypt at the column level or we can choose to encrypt the entire database using TDE […]
When SQL Server 2005 was released, a nifty little feature was included called synonyms. Despite being around since SQL Server 2005, I think this feature is often under-utilized or, more importantly, it is implemented in a very bad way.
Today I want to share a couple of examples. We will take a look at examples of […]
This Thursday, December 6, 2012, the SQL PASS Performance Virtual Chapter will be holding online sessions all day long in an the first ever Performance Palooza!. There are eight one-hour online sessions, covering a variety of performance related topics. It is a fantastic speaker line-up, of which I feel privileged to be part of. All […]
I have spoken at a lot of SQL Server Events over the past few years including a bunch of SQL Saturdays, User Groups, PASS Virtual Chapters, and PASS SQL Rally. But my abstracts for The PASS Summit were never accepted. Until this year. So a few weeks ago, I had my chance to speak for […]
Linked Servers are a very popular way to access distributed data in environments with lots of SQL Server instances on different serves, or even on other Database Management Systems like Oracle or MySQL. While linked servers can be very useful if used correctly, I have found that more often than not, they are not used correctly […]
Whenever a demo fails, it always seems to be something really stupid. This time was no exception. In my first session today here at SQL Saturday #153 in Salt Lake City, my last demo inexplicably didn’t work. I had tested it this morning right before the session. So I promised the attendees I would post […]
Really looking forward to the event this Saturday (October 20, 2012) at Neumont University in South Jordan. SQL Solutions Group has been a sponsor of the event for 5th event we have sponsored and and it has always been a great experience. We’ll be there with a booth so stop by and say hello.
In addition […]
When building ETL processes, one of the things we always like to do is to account for every row. But setting up error data flows can be very time consuming since they are schema dependent. The following solutions is a generic way to log bad rows that can be re-used without modification. It is also […]