http://www.mssqltips.com/ Last five SQL Server tips from MSSQLTips.com en-us http://www.mssqltips.com/images/mssqllogo.gif http://www.mssqltips.com 119 70 Fri, 3 Feb 2012 08:00:00 GMT When preparing for SQL Server Integration Services interview be sure to understand what questions could be asked in the interview. In this tip series (tip 1, tip 2, tip 3, tip 4), I will try to cover some common Integration Services interview questions to help you prepare for an SSIS interview. In this tip we will cover interview questions related to the data profiling, protection level, package configuration and more. http://www.mssqltips.com/tip.asp?tip=2559 Fri, 3 Feb 2012 08:00:00 GMT My company is getting ready to rollout SharePoint 2010. As the only DBA on staff, I need a quick introduction to the product that is geared to a DBA. Can you help me out? Check out this tip to learn more. http://www.mssqltips.com/tip.asp?tip=2606 Thu, 2 Feb 2012 08:00:00 GMT IntelliSense can be a very powerful ally for the T-SQL developer. It can significantly reduce keystrokes, prevent you from guessing at object names, make sure you spell them correctly (and use the right case), and can help you understand the interface to several programmable entities such as stored procedures and built-in functions. In Management Studio 2012, there are some enhancements to IntelliSense that will make it even more powerful - including more intelligent caching, and partial keyword matching (so you no longer have to remember what letter the waits DMV *starts* with - just type "waits" and it will narrow it down). I have seen several cases in forums, newsgroups and on twitter where folks complain that IntelliSense is "not work http://www.mssqltips.com/tip.asp?tip=2591 Wed, 1 Feb 2012 08:00:00 GMT As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt. http://www.mssqltips.com/tip.asp?tip=2361 Tue, 31 Jan 2012 08:00:00 GMT My auditors have asked me to identify what runs when my SQL Servers first start up. In this tip we look at different things that can run when an instance of SQL Server starts. http://www.mssqltips.com/tip.asp?tip=2598 Mon, 30 Jan 2012 08:00:00 GMT If you are preparing for a SQL Server DBA interview as the interviewer or interviewee, today's tip should offer value to you. This tip has interview style questions graded as either easy, moderate or advanced related to SQL Server backup and recovery. Check out the questions and good luck! http://www.mssqltips.com/tip.asp?tip=1517 Sat, 28 Jan 2012 08:00:00 GMT I'm creating a SQL Server Reporting Services (SSRS) report based on datasets that I have no control over and they have more data in the result set than what is required for the report. Is there a way that I can filter the datasets inside the SSRS report itself? Check out this tip to learn more. http://www.mssqltips.com/tip.asp?tip=2597 Fri, 27 Jan 2012 08:00:00 GMT My organization is in the process of hiring a junior SQL Server DBA to add to our team. What are some fair questions to ask as a portion of the interview process? I want to make sure we hire someone who has a good base of knowledge. I am concerned are Senior SQL Server DBAs are looking to stump the candidates which is not really my goal. Do you have any suggestions? http://www.mssqltips.com/tip.asp?tip=1626 Fri, 27 Jan 2012 08:00:00 GMT In the latest installment of the SQL Server interview questions, we will outline questions suitable for a DBA interview to assess the candidates skills related to SQL Server Agent. In this tip, the questions are there to read, but the answers are intentionally hidden to really test your skills. Once you read the question and have determined your answer, then highlight the answer to see how you did. Good luck! http://www.mssqltips.com/tip.asp?tip=1391 Fri, 27 Jan 2012 08:00:00 GMT I have transactional replication configured in my production environment. It appears the subscriber data is quite far behind from the publisher database. In this tip we look at ways to identify how far behind the subscriber is for replication. http://www.mssqltips.com/tip.asp?tip=2590 Thu, 26 Jan 2012 08:00:00 GMT