Archives: April 2012
Lately I’ve taken to watching TED talks in the evening. They’re thought-provoking, usually entertaining, and, best of all when watching late at night, short. I have to control myself though, I could spend hours jumping from one great topic to another. Really, I should probably watch something less thought-provoking right… Read more
Come this August 4th, 2012, the Big Apple will be baking, but not just because of the hot summer day we're expecting! No, something much more filling will be cookin, with the announcement that SQLSaturday is returning to NYC!
We've been thinking, talking, planning, and hoping behind the scenes that… Read more
Download the slides and sample scripts here.
It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this, I thought it was a good time to release an updated version of my SQL Server 2012 Diagnostic Information Queries. These queries are meant to be used with SQL…
It’s been a long time, almost a year since Andy Warren and I kicked off The Mentoring Experiment. We had a successful cycle 1, and are not in the process of looking for mentors for cycle 2. Once we get an idea of how many people are willing to… Read more
I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a nutshell, if you have a table with an IDENTITY seed less than 1000, when you do a failover the table is reseeded to 1001. The steps to reproduce are posted… Read more
Attendance was excellent with 227 total consisting of locals and groups from Minnesota, Iowa, Missouri, Indiana,… Read more
A while ago Robert Cary posted an article on SQL Server Central entitled 2005 Paging – The Holy Grail which is, as the title would suggest about paging in SQL Server. This article provoked some really interesting chat around the subject and is well worth a read.
This is now… Read more
Of course, your architecture depends on your business requirements along with technical, historical, and political factors. While business requirements are usually business-specific, we can start with a list of broad requirements, or architecture goals, that most organizations would support:
1. Excellent query performance for users Read more
0 comments, 1,894 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 25 April 2012
Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and resource usage, much better than asymmetric keys. Creating a symmetric key is fairly simple, using DDL that’s easy to understand.
One note before I show this is that symmetric keys… Read more
Download the new white paper: How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues
SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to… Read more
I had a chance over the weekend to finish reading the Verizon 2012 Data Breach Investigations Report. It’s a compilation of data about 2011 data breaches and they try to call out what they see as interesting in addition to showing a few different views of the data. It’s… Read more
I’m sure most people have identity values lurking somewhere in their databases. In fact I would guess that most people have a lot of them.
An often overlooked fact is that while they are an ever increasing/decreasing value, they do have limits.
If you have a high number of inserts… Read more
- Federation is a database object like other objects such as tables, views, stored procedures or triggers.
- It is also known as Sharding.
- There can be multiple federations in a database.
- It is data dependent/data directed routing so it can scale out across databases.
- It is a feature that you…
What more could you add to a SQL Server backup product? It seems that many software products, including Red Gate’s SQL Backup Pro, have been able to handle the things most DBAs care about for some time: compression and encryption. Today my company has released a new version of… Read more
Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring versus the more traditional Failover Clustering. Both are features provided by SQL Server for achieving high availability, buth they both have pro’s and con’s that could make a decision hard.… Read more