(Prasant Nanda) The new version of SQL server 2014 comes with various capabilities for OLTP and DW system along with enhancements previous version features.

(Pinal Dave) Yesterday I wrote about how we can install SQL Server 2014. Right after the blog post was live, I received a question from the developer that he has installed SQL Server 2014 and attached a database file from previous version of SQL Server.

(Greg Larsen) With the on-boarding of the resource governor in SQL Server with SQL Server 2008 we were able to start throttling applications and DBA processes that consumed large amounts of CPU and Memory.

(Jen McCown) Ever heard of orphaned users? It’s a database user account, disconnected from its associated login. You typically get this when you take a database backup, and restore it to a different server.

(Kenneth Fisher) Once upon a time in a version of SQL far far away we had system tables that were easy to see and could even be updated. One day one of these system tables “sysobjects” went to its fairy god-corporation Microsoft and begged to be hidden away from its mean step-dbas and step-users.

(Scott Mattie) This is a long overdue topic that I have wanted to cover for a couple of years and have finally got a chance to setup for a lab environment. I wanted to expand upon Brent Ozar’s article: How to Set Up SQL Server 2012 AlwaysOn Availability Groups. I also used Brent’s SQL Server 2012 Av

(Dallas Snider) From visual inspection alone, one can deduce that decrypting an encrypted column using the DecryptByKey function in a SELECT statement will take longer than selecting the column stored in plain text. If you have been in the information technology industry long enough, you have probab

(Allen White) In all the years I’ve worked as a server administrator, I’ve always logged into each server I work on to gather data or make changes. On Windows servers, the standard way to do this is to use Remote Desktop (RDP), which gives you keyboard and monitor access to the server, and allows yo

(Marcin Policht) In our most recent article published on this forum, we started an overview of securing Microsoft Azure-based SQL Database deployments, focusing on SQL Server- and database-level firewall access control and methods that can be employed to implement it.

(John Desch) Working in the field of Business Intelligence I get the opportunity to work with some really large (read that as multi-terabyte) OLAP databases. Multi-terabyte OLAP databases, while not yet common place, are being seen with greater frequency and they do present a few interesting challen