(Brady Upton) SQL Server Partitioning can be a bit confusing and can lead some companies in a different direction as far as archiving data. Writing the T-SQL code to create partition functions, partition schemes, and then altering the table to use the partition can be overwhelming for some DBA’s.

(Chad Churchwell) Lots of DBA’s use the built in maintenance plans to set up backups and other database maintenance. SQL Server, through SSMS provides the user with a drag and drop experience to create some pretty intelligent backup and maintenance plans. There plans are nothing more than SSIS pac

(Kenneth Fisher) Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change.

(Pinal Dave) A common question I receive is that how do user know which version user is using and what is the latest version available for the product. Here is something at this beginning of the year, check with your production server. See if you are using the latest version of the product or if you

(Roman Rehak) One of the greatest challenges with scaling out SQL Server is selecting the right option when a database needs to scale. When a database or a set of databases behind an application becomes more heavily used, database architects and developers need to be prepared well in advance to make

(Derik Hammer) We are all familiar with table variables, local temp tables, and global temp tables but what some people over look is that stored procedures and functions can also utilize tempdb.

(Dallas Snider) When creating pie charts using data from Analysis Services, having the MDX query calculate and return the percentages along with the counts or sums is extremely efficient. In this tip, we walk through an example of how this can be done.

(Jason Strate) From time to time, you might have caught yourself in a conversation similar to the following:

(Pinal Dave) This is the fourth part of the series regarding Redundant Indexes. If have not read earlier part – there is quite a good chance that you will miss the context of this part. I quickly suggest you to read earlier three parts.

(Mike Fal) Cleaning up old security info is always something that’s hard to stay on top of. Employees who leave or change responsibilities can make it difficult to track which logins need to remain in our instances.